Question

A data engineer needs to unload a large fact table from Snowflake to an external S3 stage. Downstream systems require the output to be plain, uncompressed CSV files (no GZIP), and the team wants each file kept under 100 MB to parallelize downstream reads. Which COPY INTO <location> configuration meets these requirements?

Accepted Answer

COPY INTO @s3_stage FROM fact_table FILE_FORMAT = (TYPE = CSV COMPRESSION = NONE) MAX_FILE_SIZE = 100000000;

Answer

COPY INTO @s3_stage FROM fact_table FILE_FORMAT = (TYPE = CSV COMPRESSION = GZIP) SINGLE = TRUE;

Answer

COPY INTO @s3_stage FROM fact_table FILE_FORMAT = (TYPE = CSV) MAX_FILE_SIZE = 100;

Answer

COPY INTO @s3_stage FROM fact_table FILE_FORMAT = (TYPE = PARQUET COMPRESSION = NONE) MAX_FILE_SIZE = 100000000;