DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
        1. Query syntax
        2. Query operators
        3. General DDL
        4. General DML
        5. All commands (alphabetical)
          • Accounts
          • Users, roles, & privileges
          • Integrations
          • Business continuity & disaster recovery
          • Sessions
              1. Parameters
              2. ALTER SESSION
                • SHOW PARAMETERS
                  • Context
                  • USE ROLE
                    • USE SECONDARY ROLES
                      • USE WAREHOUSE
                        • USE DATABASE
                          • USE SCHEMA
                            • Variables
                            • SET
                              • UNSET
                                • SHOW VARIABLES
                                  • Queries
                                  • EXPLAIN
                                    • DESCRIBE RESULT
                                  • Transactions
                                  • Virtual warehouses & resource monitors
                                  • Databases, schemas, & shares
                                  • Tables, views, & sequences
                                  • Functions, procedures, & scripting
                                  • Streams & tasks
                                  • dbt Projects on Snowflake
                                  • Classes & instances
                                  • Machine learning
                                  • Cortex
                                  • Listings
                                  • Openflow data plane integration
                                  • Organization profiles
                                  • Security
                                  • Data Governance
                                  • Privacy
                                  • Data loading & unloading
                                  • File staging
                                  • Storage lifecycle policies
                                  • Git
                                  • Alerts
                                  • Native Apps Framework
                                  • Streamlit
                                  • Notebook
                                  • Snowpark Container Services
                              • Function and stored procedure reference
                              • Class reference
                              • Scripting reference
                              • General reference
                              • API reference
                                ReferenceSQL command referenceSessions

                                Session commands¶

                                Session commands enable you to manage your session.

                                Parameters¶

                                • ALTER SESSION

                                • SHOW PARAMETERS

                                Context¶

                                • USE ROLE

                                • USE SECONDARY ROLES

                                • USE WAREHOUSE

                                • USE DATABASE

                                • USE SCHEMA

                                SQL variables¶

                                • SET

                                • UNSET

                                • SHOW VARIABLES

                                Queries¶

                                • EXPLAIN

                                • DESCRIBE RESULT

                                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.

                                Alternative interfaces

                                Snowflake Python APIs

                                Snowflake REST APIs

                                Snowflake CLI

                                1. Parameters
                                2. Context
                                3. SQL variables
                                4. Queries
                                Language: English
                                • English
                                • Français
                                • Deutsch
                                • 日本語
                                • 한국어
                                • Português