DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Status
  1. Overview
    • Snowflake Horizon Catalog
    • Applications and tools for connecting to Snowflake
    • Virtual warehouses
    • Databases, Tables, & Views
        1. Table Structures
        2. Temporary And Transient Tables
          • External Tables
          • Hybrid Tables
          • Working with tables in Snowsight
            • Search optimization service
            • Views
            • Views
              • Secure Views
                • Materialized Views
                  • Semantic Views
                      1. Using SQL to create a view
                        • Example of using SQL to create a view
                          • Using Cortex Analyst Semantic View Generator
                            • Validation rules
                              • Querying semantic views
                                • ACCOUNT_USAGE and INFORMATION_SCHEMA views
                              • Working with Views in Snowsight
                                • Considerations
                                • Views, Materialized Views, and Dynamic Tables
                                  • Table Design
                                    • Cloning
                                      • Data Storage
                                    • Data types
                                      • Data Integration
                                        1. Snowflake Openflow
                                        2. Apache Iceberg™
                                          1. Apache Iceberg™ Tables
                                          2. Snowflake Open Catalog
                                      • Data Engineering
                                        1. Data Loading
                                        2. Dynamic Tables
                                        3. Streams and Tasks
                                        4. dbt Projects on Snowflake
                                        5. Data Unloading
                                      • Migrations
                                      • Queries
                                      • Listings
                                      • Collaboration
                                      • Snowflake AI & ML
                                      • Alerts & Notifications
                                      • Security
                                      • Data Governance
                                      • Privacy
                                      • Organizations & Accounts
                                      • Business continuity & data recovery
                                      • Performance Optimization
                                      • Cost & Billing
                                      GuidesDatabases, Tables, & ViewsSemantic ViewsACCOUNT_USAGE and INFORMATION_SCHEMA views

                                      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

                                      Was this page helpful?

                                      Visit Snowflake
                                      Join the conversation
                                      Develop with Snowflake
                                      Share your feedback
                                      Read the latest on our blog
                                      Get your own certification
                                      Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
                                      1. CREATE SEMANTIC VIEW
                                      Language: English
                                      • English
                                      • Français
                                      • Deutsch
                                      • 日本語
                                      • 한국어
                                      • Português