Which of the following are characteristics of Snowflake’s parameter hierarchy?
Which of the following are characteristics of Snowflake’s parameter hierarchy?
Schema parameters override account parameters because Snowflake's parameter hierarchy works as follows: Account parameters affect the entire account, but can be overridden by more granular parameters. Schema parameters being at the schema level have precedence over broader account parameters, meaning their settings will apply over the default account settings.
Session parameters not always override Virtual Warehouse parameters, see i.e. here: https://docs.snowflake.com/sql-reference/parameters#statement-timeout-in-seconds Only account->database->schema->table always keeps hierarchy of parameters
When the parameter like STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set for both a warehouse and a session, the lowest non-zero value is enforced therefore A is not correct. D is my answer
Answer is A and is validated
https://docs.snowflake.com/en/user-guide/admin-account-management Snowflake provides three types of parameters that can be set for your account: - Account parameters that affect your entire account. - Session parameters that default to users and their sessions. - Object parameters that default to objects (warehouses, databases, schemas, and tables).