Categories:

Context functions (Session)

CURRENT_SESSION

Returns a unique system identifier for the Snowflake session corresponding to the present connection. This will generally be a system-generated alphanumeric string. It is NOT derived from the user name or user account.

Syntax

CURRENT_SESSION() 
Copy

Returns

The data type of the returned value is VARCHAR.

Examples

SELECT CURRENT_SESSION(); -------------------+ CURRENT_SESSION() | -------------------+ 34359980038 | -------------------+ 
Copy