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 multi-statement transactions within a session.
  • Setting and using SQL variables within a session.
  • Using a role, warehouse, database, or schema within a session.

Account DDL

Command Notes
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 and UDFs.
SHOW PARAMETERS For viewing parameter settings for the account.

Session DDL

Command Notes
ALTER SESSION For setting parameters within a session; can be performed by any user.
BEGIN For multi-statement transactions.
COMMIT For multi-statement transactions.
DESC RESULT  
ROLLBACK For multi-statement transactions.
SET For SQL variables.
SHOW LOCKS For multi-statement transactions.
SHOW PARAMETERS For viewing parameter settings for the account or session; can also be used to view parameter settings for a specified object.
SHOW TRANSACTIONS  
SHOW VARIABLES  
UNSET For SQL variables.
USE ROLE  
USE WAREHOUSE  
USE DATABASE  
USE SCHEMA