LogoLogo
⌘Ctrlk
Start Trial
LogoLogo
    • What is DeltaStream?
    • Core Concepts
    • Free Trial Quick Start
    • Starting with the Web App
    • Starting with the CLI
    • Create and Manage Data Stores
    • Manage Users and User Roles
    • Create DeltaStream Objects to Structure Raw Data
    • Use Namespacing for Organizing Data
    • Create and Query Materialized Views
    • Create a Compute Pool to Work with Iceberg
    • Create a Function
    • Secure my Connection to a Data Store
    • Serialize my Data
    • CDC Pipeline Using a Single Slot
    • Call DeltaStream’s REST API
    • Expose a Materialized View over MCP
    • Configure DeltaStream as Private SaaS using Bring your own cloud (BYOC) model
    • Setting up Data Store Integrations
  • Setting up Enterprise Security Integrations
    • Using an AWS S3 Store as a Source to Feed an MSK Topic
    • Building a Proactive GenAI Agent with Real-Time Context
    • Metrics
    • SQL Syntax
      • Data Formats (Serialization)
      • Data Types
      • Identifiers and Keywords
      • Command
      • DDL
      • Query
        • APPLICATION
        • CREATE CHANGELOG AS SELECT
        • CREATE STREAM AS SELECT
        • CREATE TABLE AS SELECT
        • Function
        • INSERT INTO
        • INSERT INTO ENTITY
        • Materialized View
        • Query Name and Version
        • Resume Query
        • RESTART QUERY
        • SELECT
        • TERMINATE QUERY
        • Change Data Capture (CDC)
      • Sandbox
      • Row Key Definition
      • System Tables
    • DeltaStream OpenAPI
  • Configure DeltaStream as Private SaaS using Bring your own cloud (BYOC) model
Powered by GitBook
For the complete documentation index, see llms.txt. This page is also available as Markdown.
  1. Reference
  2. SQL Syntax

Query

APPLICATIONCREATE CHANGELOG AS SELECTCREATE STREAM AS SELECTCREATE TABLE AS SELECTFunctionINSERT INTOINSERT INTO ENTITYMaterialized ViewQuery Name and VersionResume QueryRESTART QUERYSELECTTERMINATE QUERYChange Data Capture (CDC)
PreviousUPDATE STORENextAPPLICATION

Last updated 1 year ago