Context Functions

​

all_user_names

Supported Signatures

function all_user_names() returns array

🔗 Official Documentation

​

current_account

Supported Signatures

function current_account() returns string

🔗 Official Documentation

​

current_account_name

Supported Signatures

function current_account_name() returns string

🔗 Official Documentation

​

current_available_roles

Supported Signatures

function current_available_roles() returns string

🔗 Official Documentation

​

current_client

Returns the current client version. Supported Signatures

function current_client() returns varchar

🔗 Official Documentation

​

current_database

Returns the current database. Supported Signatures

function current_database() returns varchar

🔗 Official Documentation

​

current_date

Returns the current date. Supported Signatures

function current_date() returns date

🔗 Official Documentation

​

current_ip_address

Returns the Client Internet Protocol address (IP address) of the current request. Supported Signatures

function current_ip_address() returns varchar

🔗 Official Documentation

​

current_organization_name

Returns the name of the organization the current account belongs to. Supported Signatures

function current_organization_name() returns varchar

🔗 Official Documentation

​

current_region

Returns the current region name. Supported Signatures

function current_region() returns varchar

🔗 Official Documentation

​

current_role

Returns the currently active role name. Supported Signatures

function current_role() returns varchar

🔗 Official Documentation

​

current_role_type

Returns if the current role is of type account or database Supported Signatures

function current_role_type() returns varchar

🔗 Official Documentation

​

current_schema

Returns the current schema. Supported Signatures

function current_schema() returns varchar

🔗 Official Documentation

​

current_schemas

Returns active search path schemas Supported Signatures

function current_schemas() returns varchar

🔗 Official Documentation

​

current_secondary_roles

Returns the currently active secondary roles’ names. Supported Signatures

function current_secondary_roles() returns varchar

🔗 Official Documentation

​

current_session

Returns the current session. Supported Signatures

function current_session() returns varchar

🔗 Official Documentation

​

current_statement

Returns the text of the currently executing statement. Supported Signatures

function current_statement() returns varchar

🔗 Official Documentation

​

current_time

Returns the current time. Supported Signatures

function current_time() returns time
function current_time(decimal(38, 0)) returns time

🔗 Official Documentation

​

current_timestamp

Returns the current timestamp. Supported Signatures

function current_timestamp() returns timestamp
function current_timestamp(decimal(38, 0)) returns timestamp

🔗 Official Documentation

​

current_transaction

Returns the transaction id of an open transaction in the current session or scope. Supported Signatures

function current_transaction() returns decimal(38, 0)

🔗 Official Documentation

​

current_user

Returns the current user name. Supported Signatures

function current_user() returns varchar

🔗 Official Documentation

​

current_version

Returns the current software version (major.minor.patch). Supported Signatures

function current_version() returns varchar

🔗 Official Documentation

​

current_warehouse

Returns the warehouse currently in use. Supported Signatures

function current_warehouse() returns varchar

🔗 Official Documentation

​

getdate

Returns the current timestamp Supported Signatures

function getdate() returns timestamp

🔗 Official Documentation

​

getvariable

Supported Signatures

function getvariable(string) returns string

🔗 Official Documentation

​

invoker_role

Returns the invoker role Supported Signatures

function invoker_role() returns varchar

🔗 Official Documentation

​

invoker_share

Returns the invoker role Supported Signatures

function invoker_share() returns varchar

🔗 Official Documentation

​

is_database_role_in_session

Return true if the db role is in current role hierarchy Supported Signatures

function is_database_role_in_session(varchar) returns boolean

🔗 Official Documentation

​

is_granted_to_invoker_role

Returns true if the arg is in invoker_role’s hierarchy Supported Signatures

function is_granted_to_invoker_role(varchar) returns boolean

🔗 Official Documentation

​

is_role_in_session

Return true if in current hierarchy Supported Signatures

function is_role_in_session(varchar) returns boolean

🔗 Official Documentation

​

last_query_id

Returns the id of the last executed statement in the current session. Supported Signatures

function last_query_id() returns varchar
function last_query_id(decimal(38, 0)) returns varchar

🔗 Official Documentation

​

last_transaction

Returns the transaction id of the last committed or rolled back transaction in the current session. Supported Signatures

function last_transaction() returns decimal(38, 0)

🔗 Official Documentation

​

localtime

Returns the current time. Supported Signatures

function localtime() returns time
function localtime(decimal(38, 0)) returns time

🔗 Official Documentation

​

localtimestamp

Returns the current timestamp. Supported Signatures

function localtimestamp() returns timestamp
function localtimestamp(decimal(38, 0)) returns timestamp

🔗 Official Documentation

​

sysdate

Returns the current timestamp in the UTC time zone Supported Signatures

function sysdate() returns timestamp

🔗 Official Documentation

​

systimestamp

Returns the current timestamp Supported Signatures

function systimestamp() returns timestamp

🔗 Official Documentation