https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-streaming-live-table-and-live/m-p/17122#M11172 <P>A&nbsp;<B>live table or view always reflects the results of the query that defines it</B>, including when the query defining the table or view is updated, or an input data source is updated. Like a traditional materialized view,&nbsp;<B>a live table or view may be entirely computed</B>&nbsp;when possible to optimize computation resources and time.</P><P>A&nbsp;<B>streaming live table or view processes data that has been added only since the last pipeline update</B>. 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.</P><P></P> Tue, 13 Dec 2022 11:52:38 GMT Ajay-Pandey 2022-12-13T11:52:38Z https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-streaming-live-table-and-live/m-p/17121#M11171 Tue, 13 Dec 2022 08:03:53 GMT https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-streaming-live-table-and-live/m-p/17121#M11171 Aj2 2022-12-13T08:03:53Z https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-streaming-live-table-and-live/m-p/17122#M11172 <P>A&nbsp;<B>live table or view always reflects the results of the query that defines it</B>, including when the query defining the table or view is updated, or an input data source is updated. Like a traditional materialized view,&nbsp;<B>a live table or view may be entirely computed</B>&nbsp;when possible to optimize computation resources and time.</P><P>A&nbsp;<B>streaming live table or view processes data that has been added only since the last pipeline update</B>. 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.</P><P></P> Tue, 13 Dec 2022 11:52:38 GMT https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-streaming-live-table-and-live/m-p/17122#M11172 Ajay-Pandey 2022-12-13T11:52:38Z https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-streaming-live-table-and-live/m-p/117365#M45483 <P>Instead of copy paste if someone can explain in practical terms with example, that would be upto the standard of DataBricks community</P> Thu, 01 May 2025 10:37:57 GMT https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-streaming-live-table-and-live/m-p/117365#M45483 bbp 2025-05-01T10:37:57Z