In Snowflake, does referencing a previous query's results via RESULT_SCAN incur compute credits?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

In Snowflake, does referencing a previous query's results via RESULT_SCAN incur compute credits?

Explanation:
Result_SCAN points you to a cached snapshot of a prior query’s results. Accessing that snapshot doesn’t cause the warehouse to re-execute any computations, so it doesn’t incur compute credits for the fetch. The only charges involved are storage costs for keeping the cached results, not compute. The size of the result or a specific time window doesn’t change the compute cost here, since you’re not re-running work—you’re reading an existing, precomputed result.

Result_SCAN points you to a cached snapshot of a prior query’s results. Accessing that snapshot doesn’t cause the warehouse to re-execute any computations, so it doesn’t incur compute credits for the fetch. The only charges involved are storage costs for keeping the cached results, not compute. The size of the result or a specific time window doesn’t change the compute cost here, since you’re not re-running work—you’re reading an existing, precomputed result.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy