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()

Returns

The data type of the returned value is VARCHAR.

Examples

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