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