COF-C03 - Data Loading, Unloading, and Connectivity - Section 3.2
Use COPY INTO to bulk load data, including load validation, error handling, and transformations during load.
Use the COPY INTO table command to bulk load staged files: validate before loading with VALIDATION_MODE, control bad records with ON_ERROR, and apply simple transformations (column reordering, casts, and omissions) during the load. Recognise that load metadata prevents the same file being loaded twice within the load-history window.
COPY INTO tablebulk loadingVALIDATION_MODEON_ERRORload metadatatransformations during load
More in this domain
Back to all Data Loading, Unloading, and Connectivity objectives, or the COF-C03 cert hub.
Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.