Viewing the Dynamic Table Refresh Mode with the SHOW Command
Use SHOW DYNAMIC TABLE REFRESH HISTORY to check the refresh mode. In the output, the refresh_mode field indicates whether incremental refresh was used, and the stats field records the row counts for incremental refreshes.
Syntax
Parameters
WHERE <expr>: (Optional) Filters results based on the fields displayed by theSHOW JOBScommand. You can use an expression to narrow down the results and find the data you need more precisely.LIMIT num: (Optional) Limits the number of job records returned. Valid range: 1–10000.
Return Fields
| Field | Description |
|---|---|
| workspace_name | Workspace name |
| schema_name | Schema name |
| name | Dynamic table name |
| virtual_cluster | Compute cluster used |
| start_time | Refresh start time, timestamp type |
| end_time | Refresh end time, timestamp type |
| duration | Refresh duration, interval type |
| state | Job status |
| refresh_trigger | MANUAL (triggered manually by the user via a refresh call, including Studio scheduled refreshes) or SYSTEM_SCHEDULED (scheduled by Lakehouse) |
| suspended_reson | Reserved field, no special meaning |
| refresh_mode | NO_DATA, FULL, INCREMENTAL |
| error_message | Error message if the refresh failed |
| source_tables | Names of the base tables used by the dynamic table |
| stats | Incremental refresh row counts and related information |
| completion_target | Reserved field, no special meaning |
| job_id | Job ID; click the job ID to view the job profile |