ACCOUNT POLICY

Config path: /account_policy.yaml

Example:

authentication_policy: my_db.my_schema.my_auth_policy
network_policy: my_network_policy

Schema

• authentication_policy (ident) - assign AUTHENTICATION POLICY to ACCOUNT

• network_policy (ident) - assign NETWORK POLICY to ACCOUNT

Usage notes

1. It is highly recommended to apply ACCOUNT-level policies manually. SnowDDL will only suggest SQL by default. If you want to apply ACCOUNT-level policies automatically, please use --apply-account-policy CLI option. Additional privileges for SnowDDL admin user might be required.

2. ACCOUNT-level policies are ignored when SnowDDL runs with env_prefix.

Links

• ALTER ACCOUNT SET

• Parser & JSON Schema (GitHub)