Synchronized metadata

After you have registered and synchronized a data source, the following information is added to the Schema, Table, and Column assets.

Standard synchronized metadata

Synchronized metadata for Column assets

Column attribute Description From JDBC property (if provided by driver)
Column Name The column name in the registered table. COLUMN_NAME
Char octet Length The maximum length of binary and character-based columns. CHAR_OCTET_LENGTH
Column Position The index of the column in the table. ORDINAL_POSITION
Default Value

The default value of the column in the registered table.

COLUMN_DEF

Note Currently, this isn't supported by any CDATA driver.

Description from Source The description of the column in the registered table. REMARKS
Is Auto Incremented Indication whether the data in the column is auto-incremented or not. IS_AUTOINCREMENT
Is Generated Indication whether the data in the column is generated or not. IS_GENERATEDCOLUMN
Is Nullable

Indication whether the column can store NULL values or not.
The default value is: True.

IS_NULLABLE
Is Primary Key

Indication whether the column is a primary key or not.
The default value is: False.

True if the primary keys resultSet contains the COLUMN_NAME
Number Of Fractional Digits The number of decimal digits. DECIMAL_DIGITS
Primary Key Name The name of the primary key composed by the column. PK_NAME
Size The length in characters of the column or the numeric precision.

COLUMN_SIZE

Technical Data Type

The data type of the column in the data source. This value can differ from the Data Type value.

Tip 
  • You see the technical data type in the Technical Data Type field in the At a glance sidebar of the Column asset. If the At a glance sidebar is hidden, click Info icon.
  • For Amazon Athena and AWS Glue connections you can also see the structured technical data type, Array or Struct, if you have set the Other property to SupportNativeDataType=true.
    When you view the metadata synchronization results, click the hyperlink to see the structure of the data in a dialog box. In other locations, for example in Table assets, click the View Array or View Struct button to open the dialog box.
TYPE_NAME

Synchronized metadata for Table assets

Table attribute Description From JDBC property (if provided by driver)
Table Name The table name in the data source. TABLE_NAME
Description from Source The description of the table in the data source. REMARKS
URL

Uniform Resource Locator, also colloquially known as web address.

Note This attribute is registered only for AWS Glue data sources.

S3Path
Table Type The table type in the data source, such as TABLE or VIEW. TABLE_TYPE

Synchronized metadata for Schema assets

Schema attribute Description From JDBC (if provided by driver)
Data source type The type of the registered data source. DatabaseMetaData.getDatabaseProductName()
Source tags

The tags assigned to the asset in the source system.

Note Currently, the JDBC registration process can synchronize source tags only from Snowflake via this method.
For information on synchronizing the source tags from Databricks Unity Catalog, go to Add the Databricks Unity Catalog capability.

<database_name>.INFORMATION_SCHEMA.tag_
or
SNOWFLAKE.ACCOUNT_USAGE.tags

Conditionally synchronized metadata

For all Snowflake-specific synchronized metadata, go to Synchronized Snowflake data and characteristics mapping.

Related topics