> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-fbfa8bee.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about metadata files read from Delta Lake tables. Each entry represents a root metadata JSON file.

# system.delta_lake_metadata_log

<Info>
  **Querying in ClickHouse Cloud**

  The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the `clusterAllReplicas` function. See [here](/reference/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.
</Info>

<h2 id="purpose">
  Description
</h2>

The `system.delta_lake_metadata_log` table records metadata access and parsing events for Delta Lake tables read by ClickHouse. It provides detailed information about each metadata file, which is useful for debugging, auditing, and understanding Delta table structure evolution.

This table logs every metadata file read from Delta Lake tables. It helps users trace how ClickHouse interprets Delta table metadata and diagnose issues related to schema evolution, snapshot resolution, or query planning.

<Note>
  This table is primarily intended for debugging purposes.
</Note>

<h3 id="controlling-log-verbosity">
  Controlling log verbosity
</h3>

You can control which metadata events are logged using the [`delta_lake_log_metadata`](/reference/settings/session-settings#delta_lake_log_metadata) setting.

To log all metadata used in the current query:

```sql theme={null}
SELECT * FROM my_delta_table SETTINGS delta_lake_log_metadata = 1;

SYSTEM FLUSH LOGS delta_lake_metadata_log;

SELECT *
FROM system.delta_lake_metadata_log
WHERE query_id = '{previous_query_id}';
```

<h2 id="columns">
  Columns
</h2>

* `hostname` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — Hostname of the server executing the query.
* `event_date` ([Date](/reference/data-types/date)) — Date of the entry.
* `event_time` ([DateTime](/reference/data-types/datetime)) — Event time.
* `query_id` ([String](/reference/data-types/string)) — Query id.
* `table_path` ([String](/reference/data-types/string)) — Table path.
* `file_path` ([String](/reference/data-types/string)) — File path.
* `content` ([String](/reference/data-types/string)) — Content in a JSON format.