What is the difference between Streaming live table and live table?

Aj2
Databricks Partner
 

Ajay-Pandey
Databricks MVP

live table or view always reflects the results of the query that defines it, including when the query defining the table or view is updated, or an input data source is updated. Like a traditional materialized view, a live table or view may be entirely computed when possible to optimize computation resources and time.

streaming live table or view processes data that has been added only since the last pipeline update. Streaming tables and views are stateful; if the defining query changes, new data will be processed based on the new query and existing data is not recomputed.

Ajay Kumar Pandey

View solution in original post

bbp
Databricks Partner

Instead of copy paste if someone can explain in practical terms with example, that would be upto the standard of DataBricks community