Hi,

I was wondering that what are differences between Materialized view and Streaming table? which one should I use when I extract data from bronze table to silver table since I found that both CREATE LIVE TABLE and CREATE STREAMING LIVE TABLE could achieve the goal and keep the data up-to-date when I set the pipeline mode to continuous?

​

​for my project:

1. I first created streaming live table to ingest events into bronze tables
2. I want to create some silver layer tables which derived from bronze tables and do some transformation.

​My questions are:

1. Since delta live table Materialized view support incremental maintenance and update, is it better to always use CREATE LIVE TABLE in silver layer?
2. Are there any differences between STREAMING TABLE and Materialized view ?

Thanks a lot.

​

​