Security functions

GoogleSQL for BigQuery supports the following security functions.

Function list

Name Summary
SESSION_USER Get the email address or principal identifier of the user that's running the query.

SESSION_USER

SESSION_USER()

Description

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

Return Data Type

STRING

Example

SELECTSESSION_USER()asuser;
/*----------------------+
 | user |
 +----------------------+
 | jdoe@example.com |
 +----------------------*/

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025年12月09日 UTC.