Security functions

Stay organized with collections Save and categorize content based on your preferences.

Google Standard SQL for BigQuery supports the following security functions.

SESSION_USER

SESSION_USER()

Description

For first-party users, returns the email address of the user that is running the query. For third-party users, returns the principal identifier of the user that is running the query. For more information about identities, see Principals.

Return Data Type

STRING

Example

SELECT SESSION_USER() as user;

+----------------------+
| user                 |
+----------------------+
| jdoe@example.com     |
+----------------------+