topic Re: Streaming live table in Data Engineering

Streaming live table

Fnazar — Wed, 31 Jan 2024 11:09:17 GMT

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 :

Please help me debug

Yeshwanth — Wed, 31 Jan 2024 15:51:30 GMT

Seems like we Cannot stream from Materialized View.

Lakshay — Wed, 31 Jan 2024 18:27:35 GMT

Streaming from Materialized view is not supported.

jose_gonzalez — Wed, 31 Jan 2024 18:58:52 GMT

You can use materialized views in serverless only