No, currently views are only available to other tables in the pipeline.
Yes, Delta Live Tables can only be used to update Delta 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.
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.
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.