Querying ACCOUNT_USAGE and INFORMATION_SCHEMA views for semantic view information¶

You can query the following views for information about semantic views:

• In the ACCOUNT_USAGE schema:

  • SEMANTIC_VIEWS view

  • SEMANTIC_TABLES view

  • SEMANTIC_RELATIONSHIPS view

  • SEMANTIC_FACTS view

  • SEMANTIC_DIMENSIONS view

  • SEMANTIC_METRICS view

• In the INFORMATION_SCHEMA schema:

  • SEMANTIC_VIEWS view

  • SEMANTIC_TABLES view

  • SEMANTIC_RELATIONSHIPS view

  • SEMANTIC_FACTS view

  • SEMANTIC_DIMENSIONS view

  • SEMANTIC_METRICS view