Sync Table Metadata
Syncing table metadata within connections
By syncing table metadata, information about tables and columns is periodically saved to Codatum, ensuring up-to-date data records.
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.
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:
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.
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
Check the sync status and ensure there are no errors.
Verify the database and tables selected for syncing.
Ensure the connection credentials have the necessary permissions to reference the table.
Perform a manual sync if necessary.
Last updated
Was this helpful?