DESCRIBE_SETTING

Stored procedure DESCRIBE_SETTING is a Snowflake SQL stored procedure that fetches value of Snowflake configuration parameter.

This procedure is defined in the database OPSCENTER (database where Snowflake NativeApp is installed) schema ADMIN. ACCOUNTADMIN privilege is required to run this stored procedure.

See also:: UPDATE_SETTING

Syntax

DESCRIBE_SETTING(<name>)

Arguments

<name>: display Snowflake setting.

Supported settings are:

compute_credit_cost
serverless_credit_cost
storage_cost
default_timezone

Setting names are case sensitive.

Returns

value: value snowflake setting is set to.
<error>: error message string in the case of failure to retrieve setting.

Example:

vicky#COMPUTE_WH@OPSCENTER.ADMIN>call DESCRIBE_SETTING('storage_cost');
+------------------+                                                            
| DESCRIBE_SETTING |
|------------------|
| 40               |
+------------------+
1 Row(s) produced.