Context Functions

This family of functions allows for the gathering of information about the context in which the statement is executed. These functions are evaluated at most once per statement.

List of Functions

Sub-category

Function

Notes

General Context

CURRENT_CLIENT

CURRENT_DATE

CURRENT_IP_ADDRESS

CURRENT_REGION

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_VERSION

GETDATE

Alias for CURRENT_TIMESTAMP.

LOCALTIME

Alias for CURRENT_TIME.

LOCALTIMESTAMP

Alias for CURRENT_TIMESTAMP.

SYSDATE

SYSTIMESTAMP

Session Context

ALL_USER_NAMES

CURRENT_ACCOUNT

Returns account locator.

CURRENT_ACCOUNT_NAME

Returns account name.

CURRENT_ORGANIZATION_NAME

CURRENT_ROLE

CURRENT_AVAILABLE_ROLES

CURRENT_SECONDARY_ROLES

CURRENT_SESSION

CURRENT_STATEMENT

CURRENT_TRANSACTION

CURRENT_USER

GETVARIABLE

LAST_QUERY_ID

LAST_TRANSACTION

Session Object Context

CURRENT_DATABASE

CURRENT_ROLE_TYPE

CURRENT_SCHEMA

CURRENT_SCHEMAS

CURRENT_WAREHOUSE

INVOKER_ROLE

INVOKER_SHARE

IS_DATABASE_ROLE_IN_SESSION

IS_GRANTED_TO_INVOKER_ROLE

IS_INSTANCE_ROLE_IN_SESSION

IS_ROLE_IN_SESSION

POLICY_CONTEXT

Alert Context

GET_CONDITION_QUERY_UUID

Usage Notes

  • Context functions generally do not require arguments.

  • To comply with ANSI standards, the following context functions can be called without parentheses:

    • CURRENT_DATE

    • CURRENT_TIME

    • CURRENT_TIMESTAMP

    • CURRENT_USER

    • LOCALTIME

    • LOCALTIMESTAMP

Examples

Display the current warehouse, database, and schema for the session:

SELECT CURRENT_WAREHOUSE(), CURRENT_DATABASE(), CURRENT_SCHEMA();

---------------------+--------------------+------------------+
 CURRENT_WAREHOUSE() | CURRENT_DATABASE() | CURRENT_SCHEMA() |
---------------------+--------------------+------------------+
 MY_WAREHOUSE        | MY_DB              | PUBLIC           |
---------------------+--------------------+------------------+
Copy

Display the current date, time, and timestamp (note that parentheses are not required to call these functions):

SELECT CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP;

--------------+--------------+---------------------------------+
 CURRENT_DATE | CURRENT_TIME |        CURRENT_TIMESTAMP        |
--------------+--------------+---------------------------------+
 2015-04-28   | 17:43:46     | Tue, 28 Apr 2015 17:43:46 -0700 |
--------------+--------------+---------------------------------+
Copy