LogoLogo
search
Ctrlk
Start Trial
  • Overview
    • What is DeltaStream?
    • Core Conceptschevron-right
  • Getting Started
    • Free Trial Quick Start
    • Starting with the Web App
    • Starting with the CLI
  • How do I...?
    • Create and Manage Data Storeschevron-right
    • Manage Users and User Roleschevron-right
    • 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 Storechevron-right
    • Serialize my Datachevron-right
    • CDC Pipeline Using a Single Slot
    • Call DeltaStream’s REST API
    • Expose a Materialized View over MCP
  • Integrations
    • Setting up Data Store Integrationschevron-right
  • Setting up Enterprise Security Integrationschevron-right
  • use cases
    • Using an AWS S3 Store as a Source to Feed an MSK Topic
    • Building a Proactive GenAI Agent with Real-Time Context
  • Reference
    • Metricschevron-right
    • SQL Syntaxchevron-right
      • Data Formats (Serialization)chevron-right
      • Data Types
      • Identifiers and Keywords
      • Commandchevron-right
      • DDLchevron-right
      • Querychevron-right
        • APPLICATION
        • CREATE CHANGELOG AS SELECT
        • CREATE STREAM AS SELECT
        • CREATE TABLE AS SELECT
        • Functionchevron-right
        • INSERT INTO
        • INSERT INTO ENTITY
        • Materialized Viewchevron-right
        • Query Name and Version
        • Resume Query
        • RESTART QUERY
        • SELECTchevron-right
        • TERMINATE QUERY
        • Change Data Capture (CDC)chevron-right
      • Sandboxchevron-right
      • Row Key Definition
    • DeltaStream OpenAPIchevron-right
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. Referencechevron-right
  2. SQL Syntax

Query

APPLICATIONchevron-rightCREATE CHANGELOG AS SELECTchevron-rightCREATE STREAM AS SELECTchevron-rightCREATE TABLE AS SELECTchevron-rightFunctionchevron-rightINSERT INTOchevron-rightINSERT INTO ENTITYchevron-rightMaterialized Viewchevron-rightQuery Name and Versionchevron-rightResume Querychevron-rightRESTART QUERYchevron-rightSELECTchevron-rightTERMINATE QUERYchevron-rightChange Data Capture (CDC)chevron-right
PreviousUPDATE STOREchevron-leftNextAPPLICATIONchevron-right

Last updated 10 months ago