Alberto_Umana
Databricks Employee
Databricks Employee

Hi @guiferviz,

To determine the type of refresh used, you can query the Delta Live Tables event log. Look for the event_type called planning_information to see the technique used for the refresh. The techniques include:

 

  • FULL_RECOMPUTE: Indicates a full refresh.
  • ROW_BASED or PARTITION_OVERWRITE: Indicates an incremental refresh.

You can use the following SQL query to check the refresh type

 

SELECT timestamp, message

FROM event_log(TABLE(<fully-qualified-table-name>))

WHERE event_type = 'planning_information'

ORDER BY timestamp DESC;

 

Replace <fully-qualified-table-name> with the fully qualified name of your materialized view, including the catalog and schema.

View solution in original post