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.

Scheduled updates run weekly. For immediate updates, please execute manual sync.

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:

  • SQL Block

    • 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

  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.

Last updated

Was this helpful?