SQL

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.

DDL

SQL DDLs are queries that create, delete, or modify database structures. Unlike queries, DDLs do not process any data. Examples of useful DDLs includes creating Databases, creating Streams, dropping Entities, and updating Stores.

DDLs are useful in the UI and the CLI. However, the UI also provides an interface for many of these DDLs, such as creating Stores.

A full list of SQL DDLs can be found in the DDL section under SQL Syntax.

Query

There are two main types of SQL queries that actually process data — Streaming or continuous queries and Materialized view queries. We cover both in the Query page under Core Concepts.

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.

A full list of SQL queries can be found in the Query section under SQL Syntax.

Command

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 Entities.

SQL commands are only useful when using the CLI. The UI provides the functionality of these commands through the interface.

A full list of SQL commands can be found in the Commands section under SQL Syntax.

Last updated