When developing Delta Live Tables, is there a way to see the query history?

User16826992666
Databricks Employee
Databricks Employee

‎06-25-2021 12:20 PM

I am not sure where I can look currently to see how my DLT queries are performing. How can I investigate the query plan for past DLT runs?

Priyanka_Biswas
Databricks Employee
Databricks Employee

‎01-31-2023 07:25 PM

Hello @Trevor Bishop​ 

You can check the query plan in the Spark UI , SQL tab. You would need to select the past run from dropdown and click on SparkUI

Additionally an event log is created and maintained for every Delta Live Tables pipeline. The event log contains all information related to the pipeline, including audit logs, data quality checks, pipeline progress, and data lineage. You can use the event log to track, understand, and monitor the state of your data pipelines.

Ref:https://docs.databricks.com/workflows/delta-live-tables/delta-live-tables-event-log.html