What is the maximum batch size for responses from external functions?

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

What is the maximum batch size for responses from external functions?

Explanation:
When using external functions, Snowflake restricts how much data can be returned in a single response. The maximum size allowed for one batch of results is 10 MB. This cap keeps latency and resource usage predictable, preventing oversized payloads from impacting other queries. If your function would return more than 10 MB, you need to split the results into multiple calls or implement paging/streaming on the external side so each response stays at or below 10 MB.

When using external functions, Snowflake restricts how much data can be returned in a single response. The maximum size allowed for one batch of results is 10 MB. This cap keeps latency and resource usage predictable, preventing oversized payloads from impacting other queries. If your function would return more than 10 MB, you need to split the results into multiple calls or implement paging/streaming on the external side so each response stays at or below 10 MB.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy