Returns the per-day access counts for a table from the access audit log, answering when and how often a table was accessed.
SHOW TABLE USAGE [FOR] <zone.schema.table>## Overview SHOW TABLE USAGE returns one row per day in the recent window (last 30 days) with the number of distinct query executions that read from or wrote to the table. It is the SQL surface over DeltaForge's table access audit log (`table_access_log`), the same source that backs the **Usage** tab in the desktop GUI and the VS Code extension. ## Behavior - Result columns are `day` (YYYY-MM-DD) and `accesses` (distinct executions that touched the table that day), ordered ascending by day. - The data comes from the control plane, which records every read/write table reference captured by the unified executor at plan time. A compute node never reads the audit log directly; the command is served through the control plane API. - Days with no accesses are omitted; an empty result means the table was not accessed in the window. - The richer breakdown (frequent users, frequent queries, frequent joined tables) is available in the GUI / VS Code table Usage tab, which reads the same source. ## Access Control Reads the usage of the named table; intended for users with READ on the table. ## Compatibility DeltaForge extension. Loosely analogous to the Databricks Catalog Explorer table usage panel.
| Name | Type | Description |
|---|---|---|
qualified_name | The table to report on. May be a bare table name or a fully qualified zone.schema.table reference; matching is on the table name. |
-- When was this table accessed, and how often, per day?
SHOW TABLE USAGE sales.public.orders;-- The optional FOR keyword reads the same
SHOW TABLE USAGE FOR orders;