Streaming live table

Fnazar
New Contributor II

‎01-31-2024 03:09 AM

I am trying to create a streaming live table using the below syntax : 

CREATE OR REFRESH STREAMING LIVE TABLE revenue_stream AS 
(SELECT * FROM stream (finance_silver.finance_db.revenue)) 

And as I am trying to execute this notebook via DLT pipeline i am getting the below error :

Fnazar_0-1706699205272.png

Please help me debug

0 Kudos

Yeshwanth
Databricks Employee
Databricks Employee

‎01-31-2024 07:51 AM

Seems like we Cannot stream from Materialized View. 

Refer to this Documentation: https://docs.databricks.com/en/error-messages/error-classes.html#streaming_from_materialized_view

0 Kudos

Lakshay
Databricks Employee
Databricks Employee

‎01-31-2024 10:27 AM

Streaming from Materialized view is not supported.

0 Kudos

jose_gonzalez
Databricks Employee
Databricks Employee

‎01-31-2024 10:58 AM

You can use materialized views in serverless only

0 Kudos