> For the complete documentation index, see [llms.txt](https://docs.snowddl.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.snowddl.com/basic/yaml-configs/account-parameter.md).

# ACCOUNT PARAMETER

Config path: `/account_params.yaml`

Example:

```yaml
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](https://docs.snowflake.com/en/sql-reference/parameters.html)
* [ALTER ACCOUNT SET](https://docs.snowflake.com/en/sql-reference/sql/alter-account.html)
* [SHOW PARAMETERS IN ACCOUNT](https://docs.snowflake.com/en/sql-reference/sql/show-parameters.html)
* [Parser & JSON Schema (GitHub)](https://github.com/littleK0i/snowddl/blob/master/snowddl/parser/account_params.py)