Databricks Differences between Streaming Tables vs Live Tables vs Streaming Live Tables

191 views Asked by At

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?

  1. Do the differences between them arise due to cost or the type of data which is ingested?
  2. 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?

0

There are 0 answers