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_ERRORoptions: CONTINUE, SKIP_FILE, ABORT_STATEMENT.MATCH_BY_COLUMN_NAMEfor case-sensitive or case-insensitive column matching.- Supports SELECT transformations during load for in-flight data shaping.
PURGE = TRUEauto-removes successfully loaded files from staging.- Curriculum reference: composable CDP equivalent of AEP batch source connector for batch ingestion (Module 2).