DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • SQL data types reference
      • SQL command reference
          1. Query syntax
            • Query operators
              • General DDL
                • General DML
                  • 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
                                                                                                            • COPY INTO
                                                                                                              • 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

                                                                                                                                    • COPY INTO

                                                                                                                                      • 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