SEMANTIC_FACTS view¶

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