Snowflake COPY INTO <table> SQL Reference (2026)

Official Snowflake SQL reference for the COPY INTO command.

Key facts surfaced (2026-05-19):

• Loads data from staged files (internal stage, external stage, or cloud storage) into an existing table.
• Supported formats: CSV, JSON, Avro, ORC, Parquet, XML.
• ON_ERROR options: CONTINUE, SKIP_FILE, ABORT_STATEMENT.
• MATCH_BY_COLUMN_NAME for case-sensitive or case-insensitive column matching.
• Supports SELECT transformations during load for in-flight data shaping.
• PURGE = TRUE auto-removes successfully loaded files from staging.
• Curriculum reference: composable CDP equivalent of AEP batch source connector for batch ingestion (Module 2).