Account & session DDL¶

The following DDL commands are used to view and manage account-level and session operations, including:

Viewing parameters at multiple levels in the system (account, session, object).
Setting parameters at the account-level and within a session.
Using a role, warehouse, database, or schema within a session.
Using multi-statement transactions within a session.
Setting and using SQL variables within a session.

Account parameters & functions¶

ALTER ACCOUNT	For setting parameters at the account-level; can only be performed by users with the ACCOUNTADMIN role.
SHOW FUNCTIONS	Displays system-defined functions, as well as any user-defined functions.
SHOW PARAMETERS	For viewing parameter settings for the account.

Accounts¶

CREATE ACCOUNT	Used to create accounts in an organization.
DROP ACCOUNT
SHOW ACCOUNTS	Lists the accounts in an organization.
SHOW ORGANIZATION ACCOUNTS	Use SHOW ACCOUNTS instead.
SHOW REGIONS
UNDROP ACCOUNT

Managed accounts¶

CREATE MANAGED ACCOUNT	Currently used to create reader accounts for providers who wish to share data with non-Snowflake customers.
DROP MANAGED ACCOUNT
SHOW MANAGED ACCOUNTS

Replication and failover/failback¶

ALTER CONNECTION
CREATE CONNECTION
DROP CONNECTION
SHOW CONNECTIONS
SHOW GLOBAL ACCOUNTS	Deprecated. Use SHOW REPLICATION ACCOUNTS instead.
SHOW REPLICATION ACCOUNTS
SHOW REPLICATION DATABASES

Session parameters¶

ALTER SESSION	For setting parameters within a session; can be performed by any user.
SHOW PARAMETERS	For viewing parameter settings for the session (or account); can also be used to view parameter settings for a specified object.

Session context¶

USE ROLE	Specifies the primary role to use in the session.
USE SECONDARY ROLES	Specifies the secondary roles to use in the session.
USE WAREHOUSE	Specifies the virtual warehouse to use in the session.
USE DATABASE	Specifies the database to use in the session.
USE SCHEMA	Specifies the schema to use in the session (specified schema must be in the current database for the session).

See also:: Context functions

Queries¶

DESCRIBE RESULT	Describes the columns in the results from a specified query (must have been executed within the last 24 hours).
SHOW LOCKS	For use with multi-statement transactions.

Session transactions¶

BEGIN	For use with multi-statement transactions.
COMMIT	For use with multi-statement transactions.
DESCRIBE TRANSACTION	Describes the state of the transaction (e.g. committed, rolled back, running), etc.
ROLLBACK	For use with multi-statement transactions.
SHOW TRANSACTIONS	Lists all running transactions.

SQL variables¶

SET	For defining SQL variables in the session.
SHOW VARIABLES	For showing SQL variables in the session.
UNSET	For dropping SQL variables in the session.