thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

COPY INTO

The command that bulk-loads staged files into a table (COPY INTO <table>) or unloads query results to a stage (COPY INTO <location>).

Definition

COPY tracks load metadata for 64 days to skip files already loaded, supports ON_ERROR options (CONTINUE, SKIP_FILE, ABORT_STATEMENT), VALIDATION_MODE for dry runs and transformations during load. Snowflake recommends compressed files of roughly 100-250 MB for parallel loading. Databricks also has a COPY INTO command for idempotent loads into Delta tables.

Example

COPY INTO orders FROM @my_stage FILE_FORMAT = (TYPE = 'CSV' SKIP_HEADER = 1) ON_ERROR = 'CONTINUE';

Exam tip

Load metadata expires after 64 days; use FORCE = TRUE to reload files deliberately.

Related terms