Categories:
Account & Session DDL

SET

Initializes the value of a session variable to the result of a SQL expression.

See also:
SHOW VARIABLES , UNSET

Syntax

SET <var> = <expr>

SET ( <var> [ , <var> ... ] )  = ( <expr> [ , <expr> ... ] )

Parameters

var
Specifies the identifier for the variable to initialize.
expr
Specifies the SQL expression for the variable.

Usage Notes

  • The command supports setting multiple variables in the same statement.
  • If the command executing complex expressions, it might require a running virtual warehouse in the session.
  • The number of expressions must match the number of variables to initialize.
  • The size of string or binary variables is limited to 256 bytes.
  • The identifier (i.e. name) for a SQL variable is limited to 256 characters.
  • Variable names such as CURRENT or PUBLIC are reserved for future use by Snowflake and cannot be used.

Examples

SET V1 = 10;

SET V2 = 'example';

SET (V1, V2) = (10, 'example');