Is CREATE STREAMING LIVE VIEW deprecated?

[GeertR]

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,

[ilir_nuredini]

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