LogoLogo
Ctrlk
Start Trial
  • Overview
    • What is DeltaStream?
    • Core Concepts
  • Getting Started
    • Free Trial Quick Start
    • Starting with the Web App
    • Starting with the CLI
  • How do I...?
    • 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
  • Integrations
    • Setting up Data Store Integrations
  • Setting up Enterprise Security Integrations
  • 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
    • Metrics
    • SQL Syntax
      • Data Formats (Serialization)
      • Data Types
      • Identifiers and Keywords
      • Command
      • DDL
      • Query
        • APPLICATION
        • Change Data Capture (CDC)
        • CREATE CHANGELOG AS SELECT
        • CREATE STREAM AS SELECT
        • CREATE TABLE AS SELECT
        • Function
        • INSERT INTO
        • Materialized View
        • Query Name and Version
        • Resume Query
        • RESTART QUERY
        • SELECT
        • TERMINATE QUERY
      • Sandbox
      • Row Key Definition
    • DeltaStream OpenAPI
Powered by GitBook
On this page
  1. Reference
  2. SQL Syntax

Query

APPLICATIONChange Data Capture (CDC)CREATE CHANGELOG AS SELECTCREATE STREAM AS SELECTCREATE TABLE AS SELECTFunctionINSERT INTOMaterialized ViewQuery Name and VersionResume QueryRESTART QUERYSELECTTERMINATE QUERY
PreviousUPDATE STORENextAPPLICATION

Last updated 7 months ago