Table: snowflake_account_parameter - Query Snowflake Account Parameters using SQL

Snowflake Account Parameters are a collection of settings and defaults that govern the behavior of Snowflake accounts. These parameters include settings related to data storage, query processing, security, and other operational aspects of Snowflake accounts. They provide a way to customize and tune the behavior of Snowflake accounts to meet specific requirements or preferences.

Table Usage Guide

The snowflake_account_parameter table provides insights into the settings and defaults of Snowflake Account Parameters. As a Database Administrator or Data Engineer, explore parameter-specific details through this table, including names, values, and descriptions. Utilize it to uncover information about parameters, such as their current settings, default values, and the impact of these parameters on the operation of Snowflake accounts.

Examples

Basic info

Explore which account parameters are set in your Snowflake account to understand and manage your account configurations better. This can be particularly useful when auditing your account settings or troubleshooting issues related to account parameters.

select
  key,
  value,
  level,
  description
from
  snowflake_account_parameter;

select
  key,
  value,
  level,
  description
from
  snowflake_account_parameter;

Check whether account allows MFA caching

Assess the elements within your account to understand if multi-factor authentication (MFA) caching is permitted. This is useful for enhancing security measures by managing how user authentication data is stored.

select
  key,
  value,
  level,
  description
from
  snowflake_account_parameter
where
  key = 'ALLOW_CLIENT_MFA_CACHING';

select
  key,
  value,
  level,
  description
from
  snowflake_account_parameter
where
  key = 'ALLOW_CLIENT_MFA_CACHING';

Get number of days Snowflake retains historical data for performing Time Travel actions (SELECT, CLONE, UNDROP) on the object

Analyze the settings to understand the duration for which Snowflake preserves historical data, which can be crucial for executing actions such as Time Travel on objects. This can be beneficial for data recovery and auditing purposes.

select
  key,
  value,
  level,
  description
from
  snowflake_account_parameter
where
  key = 'DATA_RETENTION_TIME_IN_DAYS';

select
  key,
  value,
  level,
  description
from
  snowflake_account_parameter
where
  key = 'DATA_RETENTION_TIME_IN_DAYS';

Control examples

Schema for snowflake_account_parameter

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account	text	=, !=, ~~, ~~, !~~, !~~	The Snowflake account ID.
default	text		Default value of the parameter.
description	text		Description for the parameter.
key	text		Name of the account parameter.
level	text		Level of the parameter. Can be SYSTEM or ACCOUNT.
region	text		The Snowflake region in which the account is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
type	text		Data type of the parameter value.
value	text		Current value of the parameter.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- snowflake

You can pass the configuration to the command with the --config argument:

steampipe_export_snowflake --config '<your_config>' snowflake_account_parameter