session_user function
Applies to: Databricks SQL
Databricks Runtime 14.1 and above
Returns the user connected to Databricks.
nota
The SQL standard differentiates between CURRENT_USER and SESSION_USER.
In Databricks SQL and Databricks Runtime 14.1 and above you should use SESSION_USER instead of CURRENT_USER or USER.
Syntax
session_user()
Arguments
This function takes no arguments.
Returns
A STRING.
The braces are optional.
Examples
SQL
> SELECT session_user();
user1
> SELECT session_user;
user1