Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2024 03:03 PM
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.