Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2025 07:03 PM
Hi,
i see from the following databricks documentaion - https://docs.databricks.com/aws/en/dlt/limitations
it states the following which kind of giving an impression that you can define identity column to a steaming table
- Identity columns might be recomputed during updates to a materialized views. Because of this, Databricks recommends using identity columns in Lakeflow Declarative Pipelines only with streaming tables.
however streaming table syntax has no mention of identity column. and in the limitations section, it states that identity columns are not supported
https://docs.databricks.com/aws/en/dlt-ref/dlt-sql-ref-create-streaming-table#limitations
i guess either one if the documentation needs to be fixed to avoid confusion for starters like me