When using AUTO compression detection for CSV, Brotli cannot be auto-detected; what should you do?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

When using AUTO compression detection for CSV, Brotli cannot be auto-detected; what should you do?

Explanation:
Auto compression detection can identify common formats, but Brotli isn’t detectable in this scenario. Because of that, you must tell Snowflake exactly which compression was used. Explicitly specify BROTLI in the file format (or in the COPY command’s FILE_FORMAT) so Snowflake uses the Brotli decompressor and reads the data correctly. Leaving it as AUTO would lead to incorrect decompression or a failed load, since Brotli isn’t auto-detected.

Auto compression detection can identify common formats, but Brotli isn’t detectable in this scenario. Because of that, you must tell Snowflake exactly which compression was used. Explicitly specify BROTLI in the file format (or in the COPY command’s FILE_FORMAT) so Snowflake uses the Brotli decompressor and reads the data correctly. Leaving it as AUTO would lead to incorrect decompression or a failed load, since Brotli isn’t auto-detected.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy