Comment on page
SQL is the primary interface for DeltaStream. From creating Databases and Streams, to running continuous queries, or building Materialized Views on these Streams, you can do it all in a simple and familiar SQL interface. DeltaStream provides SQL extensions that enable users to express streaming concepts that don’t have equivalents in traditional SQL.
When writing streaming queries in the UI, successful queries will show up in the Query tab. Interactive streaming queries and queries on Materialized Views will print results on the page. Similarly for the CLI, successful streaming queries can be listed with the LIST QUERIES command and interactive streaming queries and queries on Materialized Views will print results directly in the console.
SQL commands are actions that do not change database entities and do not process data. Examples of useful commands include listing and describing DeltaStream entities, inviting users to your Organization, granting privileges, and printing the records in Topics.
SQL commands are only useful when using the CLI. The UI provides the functionality of these commands through the interface.