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 Excel
                                                              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 Loading
                                                                                                                                        • Dynamic Tables
                                                                                                                                        • Streams and Tasks
                                                                                                                                        • 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