DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
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
              1. SHOW REPLICATION ACCOUNTS
                • SHOW REPLICATION DATABASES
                  • SHOW REGIONS
                    • Replication
                    • CREATE REPLICATION GROUP
                      • ALTER REPLICATION GROUP
                        • DROP REPLICATION GROUP
                          • SHOW REPLICATION GROUPS
                            • SHOW DATABASES IN REPLICATION GROUP
                              • SHOW SHARES IN REPLICATION GROUP
                                • Failover/failback
                                • CREATE FAILOVER GROUP
                                  • ALTER FAILOVER GROUP
                                    • DROP FAILOVER GROUP
                                      • SHOW FAILOVER GROUPS
                                        • SHOW DATABASES IN FAILOVER GROUP
                                          • SHOW LISTINGS IN FAILOVER GROUP
                                            • SHOW SHARES IN FAILOVER GROUP
                                              • Client Redirect
                                              • CREATE CONNECTION
                                                • ALTER CONNECTION
                                                  • DROP CONNECTION
                                                    • SHOW CONNECTIONS
                                                      • Backups
                                                      • CREATE BACKUP SET
                                                        • ALTER BACKUP SET
                                                          • DROP BACKUP SET
                                                            • SHOW BACKUP SETS
                                                              • DESCRIBE BACKUP SET
                                                                • SHOW BACKUPS IN BACKUP SET
                                                                  • CREATE BACKUP POLICY
                                                                    • ALTER BACKUP POLICY
                                                                      • DROP BACKUP POLICY
                                                                        • SHOW BACKUP POLICIES
                                                                          • DESCRIBE BACKUP POLICY
                                                                            • Snapshots — Deprecated
                                                                            • CREATE SNAPSHOT POLICY — Deprecated
                                                                              • ALTER SNAPSHOT POLICY — Deprecated
                                                                                • DROP SNAPSHOT POLICY — Deprecated
                                                                                  • SHOW SNAPSHOT POLICIES — Deprecated
                                                                                    • DESCRIBE SNAPSHOT POLICY — Deprecated
                                                                                      • CREATE SNAPSHOT SET — Deprecated
                                                                                        • ALTER SNAPSHOT SET — Deprecated
                                                                                          • DROP SNAPSHOT SET — Deprecated
                                                                                            • SHOW SNAPSHOT SETS — Deprecated
                                                                                              • DESCRIBE SNAPSHOT SET — Deprecated
                                                                                                • SHOW SNAPSHOTS IN SNAPSHOT SET — Deprecated
                                                                                              • Sessions
                                                                                              • Transactions
                                                                                              • Virtual warehouses & resource monitors
                                                                                              • Databases, schemas, & shares
                                                                                              • Tables, views, sequences, and types
                                                                                              • Functions, procedures, & scripting
                                                                                              • Streams & tasks
                                                                                              • DCM Projects
                                                                                              • 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
                                                                                              • Snowflake Postgres
                                                                                          • Function and stored procedure reference
                                                                                          • Class reference
                                                                                          • Scripting reference
                                                                                          • General reference
                                                                                          • API reference
                                                                                            ReferenceSQL command referenceBusiness continuity & disaster recovery

                                                                                            Business continuity and disaster recovery commands¶

                                                                                            Business continuity and disaster recovery commands enable you to manage replication, failover, client redirect, and backups.

                                                                                            Failover¶

                                                                                            • CREATE FAILOVER GROUP

                                                                                            • ALTER FAILOVER GROUP

                                                                                            • DROP FAILOVER GROUP

                                                                                            • SHOW FAILOVER GROUPS

                                                                                            • SHOW DATABASES IN FAILOVER GROUP

                                                                                            Replication¶

                                                                                            • CREATE REPLICATION GROUP

                                                                                            • ALTER REPLICATION GROUP

                                                                                            • DROP REPLICATION GROUP

                                                                                            • SHOW REPLICATION GROUPS

                                                                                            • SHOW DATABASES IN REPLICATION GROUP

                                                                                            Backups¶

                                                                                            • CREATE BACKUP SET

                                                                                            • ALTER BACKUP SET

                                                                                            • DROP BACKUP SET

                                                                                            • SHOW BACKUP SETS

                                                                                            • DESCRIBE BACKUP SET

                                                                                            • SHOW BACKUPS IN BACKUP SET

                                                                                            • CREATE BACKUP POLICY

                                                                                            • ALTER BACKUP POLICY

                                                                                            • DROP BACKUP POLICY

                                                                                            • SHOW BACKUP POLICIES

                                                                                            • DESCRIBE BACKUP POLICY

                                                                                            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© 2026 Snowflake, Inc. All Rights Reserved.

                                                                                            Alternative interfaces

                                                                                            Snowflake Python APIs

                                                                                            Snowflake REST APIs

                                                                                            Snowflake CLI

                                                                                            1. Failover
                                                                                            2. Replication
                                                                                            3. Backups