Auditing semantic views with ACCOUNT_USAGE and INFORMATION_SCHEMA¶

To audit the semantic views in your account, query the following views for metadata about them:

• 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