SEMANTIC_FACTS view

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

See also:

SEMANTIC_FACTS view (Account Usage)

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.

Access control requirements

Private facts are included only if you are using a role that has been granted the REFERENCES or OWNERSHIP privilege on the semantic view.

Otherwise, the view lists only the public facts.

Language: English