Hi @vroste, Based on the information provided, it is impossible to directly change the frequency of the automatic maintenance tasks performed by Delta Live Tables (DLT) from every 24 hours to once a week. The system is designed to perform maintenance tasks within 24 hours of a table being updated to improve query performance and reduce costs by removing old versions of tables.
However, you might consider a few indirect approaches:
โข You could control the frequency of table updates, as maintenance tasks are performed only if a pipeline update has run 24 hours before the maintenance tasks are scheduled. The maintenance tasks will also run less frequently if the table is updated less frequently.
โข You can turn off the OPTIMIZE operation for a table by setting pipelines.autoOptimize.managed = false in the table properties for the table. This might reduce the cost of maintenance operations, although it could also affect query performance. Remember to apply the necessary security configurations to both the default and maintenance clusters to ensure the maintenance cluster has the required storage location access.
Sources:
- [Docs: index](https://docs.databricks.com/delta-live-tables/index.html
