DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
For AI agents: documentation index at /llms.txt — fetch to discover all Snowflake documentation pages. Markdown version of this page: /en/ja/sql-reference/commands-data-loading.md
  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
                          • Business continuity & disaster recovery
                            • 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
                                                        • Second generation Openflow (gen 2)
                                                          • Organization profiles
                                                            • Security
                                                              • Data Governance
                                                                • Privacy
                                                                  • Data loading & unloading
                                                                      1. Stage
                                                                      2. CREATE STAGE
                                                                        • ALTER STAGE
                                                                          • DROP STAGE
                                                                            • UNDROP 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
                                                                                                                              • Snowflake App Runtime
                                                                                                                                • Streamlit
                                                                                                                                  • Notebook
                                                                                                                                    • Snowpark Container Services
                                                                                                                                      • Snowflake Postgres
                                                                                                                                    • 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
                                                                                                                                              • UNDROP 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© 2026 Snowflake, Inc. All Rights Reserved.

                                                                                                                                              Alternative interfaces

                                                                                                                                              Snowflake Python APIsSnowflake REST APIsSnowflake CLI
                                                                                                                                              1. Stage
                                                                                                                                              2. File format
                                                                                                                                              3. External volume
                                                                                                                                              4. Pipe
                                                                                                                                              5. Loading and unloading data