INFORMATION_SCHEMA
schema. These views allow users to inspect and query the Data Catalog using familiar SQL syntax.
WHERE TABLE_SCHEMA = '<integration_name>'
.
INFORMATION_SCHEMA.META_TABLES
TABLE_NAME
(string): Name of the table.TABLE_TYPE
(string, optional): Type of table (e.g., BASE TABLE
, VIEW
).TABLE_SCHEMA
(string, optional): Schema name or integration name.TABLE_DESCRIPTION
(string, optional): Description of the table.ROW_COUNT
(integer, optional): Estimated row count.INFORMATION_SCHEMA.META_COLUMNS
TABLE_NAME
(string): Name of the table.COLUMN_NAME
(string): Column name.DATA_TYPE
(string): Data type of the column.COLUMN_DESCRIPTION
(string, optional): Description of the column.IS_NULLABLE
(boolean, optional): Whether nulls are allowed.COLUMN_DEFAULT
(string, optional): Default value, if any.INFORMATION_SCHEMA.META_COLUMN_STATISTICS
TABLE_NAME
(string): Name of the table.COLUMN_NAME
(string): Column name.MOST_COMMON_VALUES
(array of strings, optional)MOST_COMMON_FREQUENCIES
(array of integers, optional)NULL_PERCENTAGE
(float, optional)MINIMUM_VALUE
(string, optional)MAXIMUM_VALUE
(string, optional)DISTINCT_VALUES_COUNT
(integer, optional)INFORMATION_SCHEMA.META_KEY_COLUMN_USAGE
TABLE_NAME
(string): Name of the table.COLUMN_NAME
(string): Column name.ORDINAL_POSITION
(integer, optional)CONSTRAINT_NAME
(string, optional)INFORMATION_SCHEMA.META_TABLE_CONSTRAINTS
TABLE_NAME
(string): Name of the table.CONSTRAINT_NAME
(string, optional)CONSTRAINT_TYPE
(string): e.g., PRIMARY KEY, FOREIGN KEYINFORMATION_SCHEMA.META_HANDLER_INFO
HANDLER_INFO
(string): Description.