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
          • Replication & failover
          • Sessions
          • 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
              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
                                                          • 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 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 TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.

                                                        Alternative interfaces

                                                        Snowflake Python APIs

                                                        Snowflake REST APIs

                                                        Snowflake CLI

                                                        1. Stage
                                                        2. File format
                                                        3. External volume
                                                        4. Pipe
                                                        5. Loading and unloading data
                                                        Language: English
                                                        • English
                                                        • Français
                                                        • Deutsch
                                                        • 日本語
                                                        • 한국어
                                                        • Português