To Show Warehouse Parameters:
SHOW PARAMETERS LIKE '%statement%' IN WAREHOUSE tasty_test_wh;
Adjusting Warehouse Statement Timeout Parameters:
ALTER WAREHOUSE tasty_test_wh SET statement_timeout_in_seconds = 1800;
STATEMENT_TIMEOUT_IN_SECONDS: Timeout in seconds for statements. Statements are automatically canceled if they run for longer; if set to zero, max value (604800) is enforced.
Adjusting Warehouse Statement Queued Timeout Parameter:
ALTER WAREHOUSE tasty_test_wh SET statement_queued_timeout_in_seconds = 600;
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS: Timeout in seconds for queued statements. Statements will automatically be canceled if they are queued on a warehouse for longer than this amount of time; disabled if set to zero.
Adjusting the Account Timeout Parameter:
ALTER ACCOUNT SET statement_timeout_in_seconds = 18000;
STATEMENT_TIMEOUT_IN_SECONDS: Timeout in seconds for statements. Statements are automatically canceled if they run for longer; if set to zero, max value (604800) is enforced.
Adjusting the Account Statement Queued Timeout Parameter
ALTER ACCOUNT SET statement_queued_timeout_in_seconds = 3600;
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS: Timeout in seconds for queued statements. Statements will automatically be canceled if they are queued on a warehouse for longer than this amount of time; disabled if set to zero.