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.

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

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.