#4 | Session, Statement, Roles & Names Context Functions | Snowflake SQL Tutorial

Published: 07 August 2021
on channel: Data Engineering Simplified

2,373

Episode #4 of Snowflake SQL Context Functions Part-4 demonstrates the power of context functions with real-life examples. This hands-on practice video series gives you in-depth knowledge about each current_client(), current_accocunt(), current_session() , current_statement() , current_user_names(), current_roles() general context function.

🌐 Your Snowflake Story: https://forms.gle/KT9BwZd9b3JJ8s3RA
🌐 SQL Scripts used in this video:- https://toppertips.com/snowflake-date...
🌐 Snowflake Documentation for Context Function:- https://bit.ly/3iPJz84

🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
00:42 ► What is covered in this chapter
00:59 ► Where can I find SQL Script
01:07 ► Where can I find Snowflake Docs
01:22 ► Context Function Definition as per Snowflake
04:24 ► Live Demo with 6 context functions
15:20 ► Thank you note

🚀 🚀 All Snowflake SQL Episodes 🚀🚀 Playlist https://bit.ly/3AH6kCq
--------------------------------------------------------------------------------------------------
➥ Episode #1 General context function 🌐    • Episode #1 | Snowflake SQL Context Functio...
➥ Episode #2 Date & Time SQL context function 🌐    • #2 | Date & Time Context Functions | Snowf...
➥ Episode #3 current IP Address context function 🌐    • #3 | Current IP Address Context Functions ...
➥ Episode #4 client(), accocunt(), session() etc context function 🌐    • #4 | Session, Statement, Roles & Names Con...
➥ Episode #5 Current IP Address context function 🌐    • #5 | Current & Last Transaction Context Fu...
➥ Episode #6 last_query_id context function 🌐 https://bit.ly/3xTcvBD
➥ Episode #8 invoker_role context function 🌐 https://bit.ly/3B2sn6E
➥ Episode #9 is_granted_to_invoker_role context function 🌐 https://bit.ly/3zkMJYl
➥ Episode #10 invoker_share context function 🌐    • #10 | Invoker Share Context Function | Sno...

🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
-------------------------------------------------------------------------------------------------
➥ Chapter-1 Snowflake Introduction & History 🌐 https://bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 https://bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 https://bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 https://bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐    • Snowsight - Snowflake Modern Web UI | Chap...
➥ Chapter-6 Snowflake Unique Features 🌐    • Snowflake Unique Features | Chapter-6 | Sn...
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐    • Snowflake Database/Schema/Table & Containe...
➥ Chapter-8 Snowflake Must Know Database Objects 🌐    • Snowflake Must Know New Objects  | Chapter...
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐    • Fast Data Loading & Bulk Ingestion in Snow...
➥ Chapter-10 Snowflake Continuous Data Loading 🌐    • Continuous Data Loading & Data Ingestion i...
➥ Chapter-11 Snowflake External Table 🌐    • How to work with external table in Snowfla...
➥ Chapter-12 Snowflake Virtual Warehouse 🌐    • How To Work With Snowflake Virtual Warehou...
➥ Chapter-13 Snowflake Micro Partition 🌐    • #13 | Micro Partitions & Data Clustering I...
➥ Chapter-14 Snowflake Time Travel 🌐    • What is Snowflake Time Travel | Chapter-14...
➥ Chapter-15 Snowflake Clone Feature 🌐    • Snowflake Zero Copy Clone | Chapter-15 | S...
➥ Chapter-16 Snowflake Secure Data Sharing 🌐    • Snowflake Data Sharing | Chapter-16 | Snow...
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐    • Snowflake Stream & Change Data Capture | C...
➥ Chapter-18 Snowflake Task & Task Tree 🌐    • Snowflake Tasks & Task Tree | Chapter-18 |...
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐    • ETL Workflow In Snowflake | Chapter-19 | S...
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐    • Role, Grants & Role Hierarchy In Snowflake...
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐    • Stored Procedure In Snowflake | Chapter-21...
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐   • User Defined Functions In Snowflake | Chap...
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐    • What are views in Snowflake  | Chapter-21....
➥ Chapter-22 Snowflake Information Schema 🌐    • What Is Information Schema In Snowflake  |...
➥ Chapter-23 Snowflake Resource Monitor 🌐    • What Is Resource Monitor In Snowflake  | C...
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐    • How to Use Snowflake Java JDBC Driver  | C...
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐    • Microsoft Excel & Snowflake ODBC Driver | ...
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 coming-soon
➥ Chapter-25 coming-soon

#snowflaketutorial
#snowflakeSQL
#snowflakecomputing
#snowflakecontextfunction

On this page of the site you can watch the video online #4 | Session, Statement, Roles & Names Context Functions | Snowflake SQL Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Data Engineering Simplified 07 August 2021, share the link with friends and acquaintances, this video has already been watched 2,373 times on youtube and it was liked by 39 viewers. Enjoy your viewing!

38,835

566