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
          • CREATE MATERIALIZED VIEW AS
          • SELECT (FROM 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
  3. Query

Materialized View

CREATE MATERIALIZED VIEW ASSELECT (FROM MATERIALIZED VIEW)
PreviousINSERT INTONextCREATE MATERIALIZED VIEW AS

Last updated 2 months ago