DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
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
          • Replication & failover
          • Sessions
          • Transactions
          • Virtual warehouses & resource monitors
          • Databases, schemas, & shares
          • Tables, views, & sequences
          • Functions, procedures, & scripting
          • Streams & tasks
          • Classes & instances
          • Machine learning
          • Cortex Search Service
          • Listings
          • Organization profiles
          • Security
          • Data Governance
          • Privacy
          • Data loading & unloading
              1. Stage
              2. CREATE STAGE
                • ALTER STAGE
                  • DROP STAGE
                    • DESCRIBE STAGE
                      • SHOW STAGES
                        • File format
                        • ALTER FILE FORMAT
                          • CREATE FILE FORMAT
                            • DESCRIBE FILE FORMAT
                              • SHOW FILE FORMATS
                                • DROP FILE FORMAT
                                  • External volume
                                  • CREATE EXTERNAL VOLUME
                                    • ALTER EXTERNAL VOLUME
                                      • DROP EXTERNAL VOLUME
                                        • UNDROP EXTERNAL VOLUME
                                          • SHOW EXTERNAL VOLUMES
                                            • DESCRIBE EXTERNAL VOLUME
                                              • Pipe
                                              • ALTER PIPE
                                                • CREATE PIPE
                                                  • DESCRIBE PIPE
                                                    • SHOW PIPE
                                                      • DROP PIPE
                                                        • Snowpipe Streaming
                                                        • SHOW CHANNELS
                                                          • Loading and unloading
                                                          • COPY INTO <table>
                                                            • COPY INTO <location>
                                                          • File staging
                                                          • Alerts
                                                          • Native Apps Framework
                                                          • Streamlit
                                                          • Notebook
                                                          • Snowpark Container Services
                                                      • Function and stored procedure reference
                                                      • Class reference
                                                      • Scripting reference
                                                      • General reference
                                                      • API reference
                                                        ReferenceSQL command referenceData loading & unloading

                                                        Data loading and unloading commands¶

                                                        Data loading and unloading commands enable you to manage data loading and unloading.

                                                        Stage¶

                                                        • CREATE STAGE

                                                        • ALTER STAGE

                                                        • DESCRIBE STAGE

                                                        • DROP STAGE

                                                        • SHOW STAGES

                                                        File format¶

                                                        • CREATE FILE FORMAT

                                                        • ALTER FILE FORMAT

                                                        • DESCRIBE FILE FORMAT

                                                        • DROP FILE FORMAT

                                                        • SHOW FILE FORMATS

                                                        External volume¶

                                                        • CREATE EXTERNAL VOLUME

                                                        • ALTER EXTERNAL VOLUME

                                                        • DROP EXTERNAL VOLUME

                                                        • UNDROP EXTERNAL VOLUME

                                                        • SHOW EXTERNAL VOLUMES

                                                        • DESCRIBE EXTERNAL VOLUME

                                                        Pipe¶

                                                        • CREATE PIPE

                                                        • ALTER PIPE

                                                        • DESCRIBE PIPE

                                                        • DROP PIPE

                                                        • SHOW PIPES

                                                        Loading and unloading data¶

                                                        • COPY INTO <table>

                                                        • COPY INTO <location>

                                                        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. Stage
                                                        2. File format
                                                        3. External volume
                                                        4. Pipe
                                                        5. Loading and unloading data
                                                        Language: English
                                                        • English
                                                        • Français
                                                        • Deutsch
                                                        • 日本語
                                                        • 한국어
                                                        • Português