Is CREATE STREAMING LIVE VIEW deprecated?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2025 02:59 AM
Hi,
I'm trying to learn Lakeflow Pipelines (DLT) and found some examples online where the CREATE STREAMING LIVE VIEW statement is used. When I try to search for it in the Databricks document, there is nothing really I can find on them.
https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-view
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2025 03:44 AM
Hello @GeertR ,
The LIVE virtual schema is a legacy feature of Lakeflow Declarative Pipelines (DLT) and is deprecated. You can still use it with pipelines that were created in legacy publishing mode, but the pipeline configuration UI no longer lets you create new pipelines in that mode.
You can refer to this doc, to look into more details about the LIVE syntax:
https://docs.databricks.com/aws/en/dlt/live-schema?utm_source=chatgpt.com
You can refer to this doc, to look into the available syntax:
https://docs.databricks.com/aws/en/dlt/concepts
Hope that helps,
Best, Ilir
