Snowflake Syntax: show parameters

The Snow Parameters command lists the current values for all parameters. The System Administrator (using ACCOUNTADMIN role) can set a default parameter at the Account level, which can be overridden by the User at the User and Session level. The parameters list the current and default value so it is possible to see which parameters have been modified.

Snowflake Documentation: Snowflake Show Parameters

show parameters

Lists the current value of all parameters.

--
-- Lists all parameters
--
show parameters;

show changed parameters

Lists all the parameters in the current session which are different to the default. These may have been overridden at either the Account, User or Session level.

--
-- Amend default parameters for entire ACCOUNT
--
use role ACCOUNTADMIN;
alter account set date_output_format = 'DD-MON-YYYY';                             -- Set default output date format
alter account set statement_timeout_in_seconds = 14400;                           -- Set query time-out to 4 hours
alter account set timestamp_output_format = 'DD-MON-YYYY HH24:MI:SS.FF3 TZHTZM';  -- Set default output format for timestamps
--
-- Show changed parameters 
--
show parameters;
select *
from table(result_scan(last_query_id()))
where "value" <> "default";

show parameters in database

--
-- Show parameters for current database
--
show parameters in database;

show parameters in schema

--
-- Show parameters for current schema
--
show parameters in schema;

show parameters in table

--
-- Lists all parameters for a given TABLE 
--
show parameters in table MY_TABLE;

show parameters for warehouse

--
-- Lists all WAREHOUSE parameters 
-- for the warehouse named DEFAULT_WH
--
show parameters for warehouse DEFAULT_WH;