ACCOUNT PARAMETER

Config path: /account_params.yaml

Example:

ABORT_DETACHED_QUERY: true
CLIENT_TIMESTAMP_TYPE_MAPPING: "TIMESTAMP_NTZ"
ENABLE_UNREDACTED_QUERY_SYNTAX_ERROR: true
ERROR_ON_NONDETERMINISTIC_MERGE: true
ERROR_ON_NONDETERMINISTIC_UPDATE: true
JDBC_TREAT_TIMESTAMP_NTZ_AS_UTC: true
LOCK_TIMEOUT: 3600
PREVENT_UNLOAD_TO_INLINE_URL: true
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION: true
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION: true
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS: 10800
STATEMENT_TIMEOUT_IN_SECONDS: 10800
TIMESTAMP_NTZ_OUTPUT_FORMAT: "YYYY-MM-DD HH24:MI:SS"
TIMESTAMP_OUTPUT_FORMAT: "YYYY-MM-DD HH24:MI:SS TZHTZM"
TIMESTAMP_TYPE_MAPPING: "TIMESTAMP_NTZ"
TIMEZONE: "Etc/UTC"
TRANSACTION_ABORT_ON_ERROR: true
UNSUPPORTED_DDL_ACTION: "FAIL"
WEEK_START: "1"
ALLOW_CLIENT_MFA_CACHING: true
ALLOW_ID_TOKEN: true

Schema

• {key} (ident) - parameter name

• {value} (bool, float, int, str) - parameter value

Usage notes

1. Data type of parameter value is important! Correct data type for each parameter can be obtained from output of SHOW PARAMETERS IN ACCOUNT.

Links

• Parameters
• ALTER ACCOUNT SET
• SHOW PARAMETERS IN ACCOUNT
• Parser & JSON Schema (GitHub)