SEMANTIC_TABLES view¶

This Information Schema view displays a row for each logical table in a semantic view in the specified (or current) database.

Columns¶

Column name	Data type	Description
`semantic_view_catalog`	VARCHAR	Database to which the semantic view belongs.
`semantic_view_schema`	VARCHAR	Schema to which the semantic view belongs.
`semantic_view_name`	VARCHAR	Name of the semantic view.
`name`	VARCHAR	Name of the semantic table.
`base_table_catalog`	VARCHAR	Database to which the base table belongs.
`base_table_schema`	VARCHAR	Schema to which the base table belongs.
`base_table_name`	VARCHAR	Name of the base table.
`primary_keys`	ARRAY(VARCHAR)	List of the primary key columns of the table.
`synonyms`	ARRAY(VARCHAR)	List of the synonyms for the table.
`comment`	VARCHAR	Description of the semantic table.