ComposableStack.AI CDP
Back to agent
Sourcesource.docs-snowflake-com.en-user-guide-tutorials-data-load-internal-tutorial-2026

Snowflake Documentation — Tutorial: Bulk Loading from a Local File System Using COPY

Snowflake official tutorial covering how to bulk load data from local files into Snowflake tables using named internal stages, file format objects, and COPY INTO command. Covers the full workflow: CREATE FILE FORMAT, CREATE STAGE, PUT (upload with compression), COPY INTO (with ON_ERROR options and pattern matching), error validation with the VALIDATE function, and staged-file cleanup with REMOVE.

docs.snowflake.com — view original source
confidence 95%v1indexed Jun 12, 2026snowflake, data-loading, bulk-load, copy-into, internal-stage, file-format, put-command, validate, tutorial, composable-cdp, curriculum

Official Snowflake tutorial: Tutorial: Bulk Loading from a Local File System Using COPY

Canonical URL: https://docs.snowflake.com/en/user-guide/tutorials/data-load-internal-tutorial

Coverage: Teaches the complete bulk-load workflow for loading data from local files into Snowflake tables via internal stages.

Key steps documented:

  1. Create file format objects — CREATE FILE FORMAT specifying TYPE = 'CSV', FIELD_DELIMITER, and other parsing options.
  2. Create named internal stages — CREATE STAGE establishes a Snowflake-managed cloud storage location for staging files before load.
  3. Upload files — PUT command uploads local files to the stage with optional AUTO_COMPRESS for gzip compression.
  4. Load data — COPY INTO <table> executes the bulk load with options including:
    • ON_ERROR for error handling strategy
    • Pattern matching to load specific files from a stage
  5. Validate errors — VALIDATE(<table>, JOB_ID => <query_id>) function identifies rejected rows and load errors.
  6. Cleanup — REMOVE @<stage> removes staged files after successful load.

Relation to prior queue entry: The original curriculum-ingestor queue entry targeted https://docs.snowflake.com/en/user-guide/data-load-bulk-load-copy (now 404). This tutorial is the authoritative Snowflake documentation covering the COPY INTO bulk-load workflow pattern for operational-task.ingest-batch-data-via-source-connector (TC-129). Complements the existing COPY INTO SQL reference: source.docs-snowflake-com.en-sql-reference-sql-copy-into-table-2026.

Note: The original /user-guide/tables-create URL (curriculum-ingestor queue entry for table creation) returns 404 as of 2026-06-12. Existing source.docs-snowflake-com.en-sql-reference-sql-create-table-2026 covers CREATE TABLE syntax for table provisioning needs.