Which of the following are characteristics of Snowflake’s parameter hierarchy?

Which of the following are characteristics of Snowflake’s parameter hierarchy?
A . Session parameters override virtual warehouse parameters.
B . Virtual warehouse parameters override user parameters.
C . Table parameters override virtual warehouse parameters.
D . Schema parameters override account parameters.

View Answer

Answer: B

Explanation:

In Snowflake’s parameter hierarchy, virtual warehouse parameters take precedence over user parameters. This hierarchy is designed to ensure that settings at the virtual warehouse level, which typically reflect the requirements of a specific workload or set of queries, override the preferences set at the individual user level. This helps maintain consistent performance and resource utilization as specified by the administrators managing the virtual warehouses.

Reference: Snowflake documentation on parameter hierarchy, found in the SnowPro Advanced:

Architect learning materials.