Delta Live Tables frequently asked questions

Preview

This feature is in Public Preview. To sign up for access, see Request Access to Delta Live Tables.

Frequently asked questions (FAQ)

Can I query views in a pipeline from another cluster or SQL endpoint?

No, currently views are only available to other tables in the pipeline.

Does Delta Live Tables only support updating of Delta tables?

Yes, Delta Live Tables can only be used to update Delta tables.

Does Delta Live Tables perform maintenance tasks on my tables?

Yes, Delta Live Tables performs maintenance tasks on tables every 24 hours. Maintenance can improve query performance and reduce cost by removing old versions of tables. By default, the system performs a full OPTIMIZE operation followed by VACUUM. You can disable OPTIMIZE for a table by setting pipelines.autoOptimize.managed = false in the table properties for the table.

Can I query an older snapshot of a table?

By default, Delta tables created by a Delta Live Tables pipeline retain seven days of history, allowing you to query a snapshot of a table. You can modify the retention period using table properties if you require more than seven days of history.

Can I have multiple queries in a pipeline writing to the same target table?

No, each table must be defined once. You can Use UNION If you need to combine multiple inputs to create a table. Adding or removing UNION from an incremental table is a breaking operation that requires a full-refresh.