Streaming live table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 :
Please help me debug
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2024 10:27 AM
Streaming from Materialized view is not supported.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2024 10:58 AM
You can use materialized views in serverless only