Back to Browse

Snowflake - Scalar Functions - Context Functions - Part 3

197 views
Jul 7, 2021
11:05

GitHub Code - https://github.com/sardetushar/Snowflake/tree/main/SnowflakeFunctions This video covers following Snowflake Context Functions 1. General Context CURRENT_CLIENT CURRENT_DATE CURRENT_IP_ADDRESS CURRENT_REGION CURRENT_TIME CURRENT_TIMESTAMP CURRENT_VERSION LOCALTIME - CURRENT_TIME. LOCALTIMESTAMP - CURRENT_TIMESTAMP. SYSDATE 2. Session Context ALL_USER_NAMES CURRENT_ACCOUNT CURRENT_ROLE CURRENT_AVAILABLE_ROLES CURRENT_SESSION CURRENT_STATEMENT CURRENT_TRANSACTION CURRENT_USER LAST_QUERY_ID LAST_TRANSACTION 3. Session Object Context CURRENT_DATABASE CURRENT_SCHEMA CURRENT_SCHEMAS CURRENT_WAREHOUSE INVOKER_ROLE INVOKER_SHARE IS_GRANTED_TO_INVOKER_ROLE IS_ROLE_IN_SESSION /************************************************************************************ REF - https://docs.snowflake.com/en/sql-reference/functions-context.html ************************************************************************************/

Download

0 formats

No download links available.

Snowflake - Scalar Functions - Context Functions - Part 3 | NatokHD