Data Catalog

Synchronized Data Tables and Views

After connecting to a data source, users can view and manage synchronized tables in the "Data Catalog" module.

• Only tables checked in the data source are displayed;

• Supports viewing each table's table name, business description, field names, and field descriptions;

• Displays the relationships between the table and other tables, including related tables, related fields, and relationship types (e.g., primary-foreign key);

• Supports one-click triggering of "Intelligent Data Knowledge Supplement," where the system automatically generates business aliases and descriptions for tables and fields based on AI and Schema;

• Supports the "Data Table Synchronization" feature to reload updated table structures.

Data Catalog Synchronization Notes

• Unsynchronized tables or views cannot be used

  • Only tables and views synchronized in the data catalog can be referenced or used to build business domains in AI Central's Data module.

  • If new data exists in the database but is not synchronized in the data catalog, the system will not recognize or use it.

• Database structure updates require re-synchronization

  • When table structures or field information in the external database change (e.g., new fields added, field type adjustments, table renaming, etc.),

  • Users need to perform the "Synchronize" operation in the data catalog to ensure the data structure remains consistent with the source system.

  • Otherwise, data within AI Central will continue to operate based on the old structure, which may cause subsequent data mapping errors or missing fields.

• Common causes and troubleshooting for synchronization failures

  • Data source connection invalid: This may be due to data source password changes, database service interruptions, or network issues. Please retest the connection in "Data Source Management."

  • Insufficient table permissions: Some database accounts have read-only permissions or lack metadata access rights. Contact the database administrator to grant the necessary permissions.

  • Field or table names contain special characters: Some databases have field or table names with spaces, symbols, or reserved words. It is recommended to rename them in the database or exclude them before synchronization.

  • Schema mismatch: When database structures change frequently or multiple schemas are used, it is recommended to confirm the schema configuration is correct before synchronization.