SEMANTIC_DIMENSIONS view¶

This Information Schema view displays a row for each dimension 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.
`table_name`	VARCHAR	Name of the semantic table the dimension belongs to.
`name`	VARCHAR	Name of the dimension.
`data_type`	VARCHAR	Data type of the dimension expression.
`expression`	VARCHAR	The SQL expression used to calculate the dimension.
`synonyms`	ARRAY(VARCHAR)	List of the synonyms for the dimension.
`comment`	VARCHAR	Description of the dimension.