# Sync Table Metadata

By syncing table metadata, information about tables and columns is periodically saved to Codatum, ensuring up-to-date data records.

{% hint style="info" %}
Scheduled updates run weekly. For immediate updates, please execute manual sync.
{% endhint %}

The results of the query execution are output independently of table metadata sync status. If the execution results are not updated, cached results may be displayed. For details, please check [(Appendix) Query Execution and Cache](/data-exploration/appendix-cache.md).

## Key Features

* Aggregate table metadata:
  * Table structures including:
    * Dataset names
    * Schema names
    * Table names
  * Table descriptions
  * Row count
  * Table size (bytes)
  * Table creation and update date
  * Column names, types, and descriptions
* Automatically run sync jobs:
  * Interval: Weekly
* Manual sync:
  * Trigger syncing manually from admin panel
* Real-time sync status tracking:
  * Monitor the sync status in real-time with statuses such as:
    * QUEUED
    * PROCESSING
    * SUCCESS
    * WARNING
    * FAILED

## Where Table Metadata is Displayed

Synced table metadata is utilized in the following features:

* [Catalog](/connect-and-manage-data/catalog.md)
* [SQL Block](/data-exploration/notebook/sql-block.md)
  * Auto-completion
* Column information displayed in table overviews across various features

## Permissions

* Access to synced table metadata is limited to users who have read permissions for the connections associated with those tables.
* If multiple connections reference the same table, they are treated as a single table metadata entry. If read permissions are granted to any of the connections, the table metadata can be accessed.

## Limitation

* The number of tables: depends on the plan.
  * <https://codatum.com/pricing>
* Tables that can be synced per schema: Up to 1000.
* Columns that can be synced per table: Up to 1000.

## Troubleshooting: Can not find the table in our data warehouses

1. Check the sync status and ensure there are no errors.
2. Verify the database and tables selected for syncing.
3. Ensure the connection credentials have the necessary permissions to reference the table.
4. Perform a manual sync if necessary.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.codatum.com/connect-and-manage-data/connection/sync-table-metadata.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.