I am new to Databricks and I would like to understand the differences between a Live Table, Streaming Live table and a Streaming Table, what difference do they have?
- Do the differences between them arise due to cost or the type of data which is ingested?
- If I am trying to ingest data from a cloud source, does it matter which type of table I am creating?
Streaming table creation
{ CREATE STREAMING TABLE [ IF NOT EXISTS ] }
table_name
[ table_specification ]
[ table_clauses ]
[ AS query ]
Streaming Live table
{ CREATE STREAMING LIVE TABLE [ IF NOT EXISTS ] }
table_name
[ table_specification ]
[ table_clauses ]
[ AS query ]
Could someone please explain the differences?