Categories:

Context functions (Session)

CURRENT_USER¶

Returns the name of the user currently logged into the system.

Syntax¶

CURRENT_USER()

CURRENT_USER
Copy

Arguments¶

None.

Returns¶

This function returns a value of type VARCHAR.

Usage notes¶

  • To comply with the ANSI standard, this function can be called without parentheses in SQL statements.

    However, if you are setting a Snowflake Scripting variable to an expression that calls the function (for example, my_var := CURRENT_USER();), you must include the parentheses. For more information, see the usage notes for context functions.

  • Granting access on a secure UDF or secure view that contains this function to a share is allowed. When the secure UDF or secure view is accessed from the data sharing consumer account, this function always returns a NULL value.

  • Snowflake returns a NULL value if this function is used in a masking policy or row access policy that is assigned to a shared table or view.

Examples¶

This example calls the CURRENT_USER function:

SELECT CURRENT_USER();
Copy
+----------------+
| CURRENT_USER() |
|----------------|
| TSMITH         |
+----------------+