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
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).
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
charemski
Highly Voted 1 year agoanikl
Most Recent 8 months, 4 weeks agohillcat111
1 year agocallipso21
1 year, 3 months ago