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.

In this Topic:

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

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 user role 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

Session Transactions, SQL Variables, and Queries

BEGIN For use with multi-statement transactions.
COMMIT For use with multi-statement transactions.
DESCRIBE RESULT Describes the columns in the results from a specified query (must have been executed within the last 24 hours).
ROLLBACK For use with multi-statement transactions.
SET For defining SQL variables in the session.
SHOW LOCKS For use with multi-statement transactions.
SHOW TRANSACTIONS  
SHOW VARIABLES For showing SQL variables in the session.
UNSET For dropping SQL variables in the session.