LogoLogo
codatum.comSign InStart for free
  • Introduction
  • Getting Started
    • Quick Start
    • Concept (Further reading)
      • Why did we a choose Block Editor over Cell-based Editor?
  • Connect and Manage Data
    • Connection
      • Sync Table Metadata
    • Supported Warehouses
      • BigQuery
      • Snowflake
      • Other Warehouses
    • Catalog
    • Search
  • Data Exploration
    • Data Exploration Overview
    • Notebook
      • Doc Page
      • Grid Page
      • SQL Block
      • Version
      • Notebook FAQ
    • Chart
    • Explorer
    • Parameter
    • (Appendix) Cache
  • AI Assist
    • SQL Assistant
  • Sharing
    • Sharing Overview
    • Teamspace
    • Shared Notebook
    • Report
    • Public Link
    • Signed Embed
      • How to Set Up Signed Embed
  • Account Management
    • Account
    • Account Settings
  • Workspace & User Management
    • Workspace
  • User Management
    • Invitation
    • Group
  • Security
    • Security Overview
  • Audit logs
  • IP Access Control
  • Access control
    • Access Control Overview
    • Access Control for Workspace
    • Access Control for Resources
      • Access Control for Group
      • Access Control for Teamspace
      • Access Control for Notebook
      • Access Control for Connection
      • Access Control for Report
  • [Under Construction] Plan and Billing
    • Limit and usage
    • Downgrade and cancel
  • Best Practices
    • Advanced Control Structures in SQL
  • Other considerations
    • System requirements
Powered by GitBook

Reference

  • Privacy policy
  • Terms of service
  • JP Docs Site
On this page
  • Key Features
  • Permissions
  • Limitation
  • Troubleshooting: Can not find the table in our data warehouses

Was this helpful?

  1. Connect and Manage Data
  2. Connection

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.

  • 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.

PreviousConnectionNextSupported Warehouses

Last updated 7 months ago

Was this helpful?

https://codatum.com/pricing