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