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