When unloading to a stage, which of the following is a recommended practice or approach?

Question

Options

• ASet SINGLE: = true for larger files
• BUse OBJECT_CONSTRUCT ( * ) when using Parquet
• CAvoid the use of the CAST function
• DDefine an individual file format

• A
  2% (1)
• B
  2% (1)
• C
  6% (3)
• D
  91% (48)

Explanation

Defining an explicit file format (option D) is a recommended best practice when unloading data to a stage in Snowflake. By specifying a named file format object or inline FORMAT_NAME, you ensure consistent, reproducible formatting (delimiters, compression, encoding, null handling) for the exported files. Option A is incorrect because SINGLE = TRUE produces one large file, which is inefficient for large datasets; the recommended approach for large unloads is to use the default multiple-file output. Option B (OBJECT_CONSTRUCT(*) with Parquet) is a valid technique for Parquet unloads but is not a universal best practice. Option C has no basis - there is no guidance to avoid the CAST function during unloading.

No community discussion yet for this question.