DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
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
            • Apache Iceberg™ 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
                                          1. About Openflow
                                            • Understanding Openflow costs
                                              • Set up Openflow
                                                • Connect your data sources using Openflow connectors
                                                  1. About Openflow connectors
                                                    • Openflow Connector for Amazon Ads
                                                      1. About the connector
                                                        • Set up the connector
                                                        • Openflow Connector for Box
                                                          1. About the connector
                                                            • Set up the connector
                                                            • Openflow Connector for Google Ads
                                                              1. About the connector
                                                                • Set up the connector
                                                                • Openflow Connector for Google Drive
                                                                  1. About the connector
                                                                    • Set up the connector
                                                                    • Openflow Connector for Google Sheets
                                                                      1. About the connector
                                                                        • Set up the connector
                                                                        • Openflow Connector for HubSpot
                                                                          1. About the connector
                                                                            • Set up the connector
                                                                            • Openflow Connector for Jira Cloud
                                                                              1. About the connector
                                                                                • Set up the connector
                                                                                • Openflow Connector for Kafka
                                                                                  1. About the connector
                                                                                    • Set up the connector (core)
                                                                                    • Performance tuning
                                                                                    • Openflow Connector for Kinesis
                                                                                      1. About the connector
                                                                                        • Set up the connector
                                                                                        • Openflow Connector for LinkedIn Ads
                                                                                          1. About the connector
                                                                                            • Set up the connector
                                                                                            • Openflow Connector for Meta Ads
                                                                                              1. About the connector
                                                                                                • Set up the connector
                                                                                                • Openflow Connector for Microsoft Dataverse
                                                                                                  1. About the connector
                                                                                                    • Set up the connector
                                                                                                    • Openflow Connector for MySQL
                                                                                                      1. About the connector
                                                                                                        • Set up the connector
                                                                                                        • Openflow Connector for PostgreSQL
                                                                                                          1. About the connector
                                                                                                            • Set up the connector
                                                                                                            • Openflow Connector for SharePoint
                                                                                                              1. About the connector
                                                                                                                • Set up the connector
                                                                                                                • Openflow Connector for Slack
                                                                                                                  1. About the connector
                                                                                                                    • Set up the connector
                                                                                                                    • Openflow Connector for Snowflake to Kafka
                                                                                                                      1. About the connector
                                                                                                                        • Set up the connector
                                                                                                                        • Openflow Connector for SQL Server
                                                                                                                          1. About the connector
                                                                                                                            • Set up the connector
                                                                                                                            • Openflow Connector for Workday
                                                                                                                              1. About the connector
                                                                                                                                • Set up the connector
                                                                                                                              2. Manage Openflow
                                                                                                                                • Monitor Openflow
                                                                                                                                  • Troubleshoot Openflow
                                                                                                                                    • Processors
                                                                                                                                      • Controllers
                                                                                                                                    • 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 Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                                                                                                                    1. CREATE SEMANTIC VIEW
                                                                                                                                    Language: English
                                                                                                                                    • English
                                                                                                                                    • Français
                                                                                                                                    • Deutsch
                                                                                                                                    • 日本語
                                                                                                                                    • 한국어
                                                                                                                                    • PortuguĂŞs