#3 | Current IP Address Context Functions | Snowflake SQL Tutorial
Episode #3 of Snowflake SQL Context Functions Part-3 demonstrates the power of context functions with real-life examples. This hands-on practice video series gives you in-depth knowledge about current_ip_address() general context function. π Your Snowflake Story: https://forms.gle/KT9BwZd9b3JJ8s3RA π SQL Scripts used in this video:- https://bit.ly/3BVFk3B π Snowflake Documentation for Context Function:- https://bit.ly/3iPJz84 π π Chapters π π ----------------------------------------- 00:59 βΊ What is covered in this chapter 01:34 βΊ Where can I find SQL Script 01:51 βΊ Where can I find Snowflake Docs 02:04 βΊ The list of context functions 02:26 βΊ What does current_ip_address() context function do 05:19 βΊ Live Demo with current_ip_address() 14:34 βΊ Observation 1 - IP Address not recorded when you switch network 16:12 βΊ Observation 2 - How IP address works with task 18:38 βΊ Thank you note π π All Snowflake SQL Episodes ππ Playlist https://bit.ly/3AH6kCq -------------------------------------------------------------------------------------------------- β₯ Episode #1 General context function π https://youtu.be/VkIRKGHdg6c β₯ Episode #2 Date & Time SQL context function π https://youtu.be/7cLSzb3HD7w β₯ Episode #3 current IP Address context function π https://youtu.be/2OkykRh4tDA β₯ Episode #4 client(), accocunt(), session() etc context function π https://youtu.be/ou_FwiiJis4 β₯ Episode #5 Current IP Address context function π https://youtu.be/vW5vScTJfbw β₯ 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 π https://youtu.be/S24IKc2eOig π π 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 π https://youtu.be/T-l_LN_505Q β₯ Chapter-6 Snowflake Unique Features π https://youtu.be/-MZrCpoAUs0 β₯ Chapter-7 Snowflake DB/Schema/Table & Data Loading π https://youtu.be/Pi3z1NyBd-Y β₯ Chapter-8 Snowflake Must Know Database Objects π https://youtu.be/S5NwU2o2Exg β₯ Chapter-9 Snowflake Fast Data Loading/Ingestion π https://youtu.be/lI5OQPjuj-8 β₯ Chapter-10 Snowflake Continuous Data Loading π https://youtu.be/PNK49SJvXjE β₯ Chapter-11 Snowflake External Table π https://youtu.be/w9BQsOlJc5s β₯ Chapter-12 Snowflake Virtual Warehouse π https://youtu.be/NE07Jx6V4UA β₯ Chapter-13 Snowflake Micro Partition π https://youtu.be/UNBysn1M9Vg β₯ Chapter-14 Snowflake Time Travel π https://youtu.be/9k8ADXunhIk β₯ Chapter-15 Snowflake Clone Feature π https://youtu.be/cAyM-Nj9WOc β₯ Chapter-16 Snowflake Secure Data Sharing π https://youtu.be/2d6d-zZMXtA β₯ Chapter-17 Snowflake Streams & Change Data Capture π https://youtu.be/DXI0GDSwE_E β₯ Chapter-18 Snowflake Task & Task Tree π https://youtu.be/165hXZ_o4Vk β₯ Chapter-19 ETL (Data Pipeline) in Snowflake π https://youtu.be/9FejjGVZrPg β₯ Chapter-20 Role, Grants & Role Hierarchy in Snowflake π https://youtu.be/pZQXK7qO0iY β₯ Chapter-21 (Part-1) Stored Procedure in Snowflake π https://youtu.be/CsH2sB6gwlw β₯ Chapter-21 (Part-2) User Defined Function in Snowflake πhttps://youtu.be/xnjCbgu0Qj4 β₯ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) π https://youtu.be/2soTybOZkXY β₯ Chapter-22 Snowflake Information Schema π https://youtu.be/kqZRXoFcKo0 β₯ Chapter-23 Snowflake Resource Monitor π https://youtu.be/2msEUDzp-uU β₯ Chapter-24 (Part-1) Snowflake JDBC Driver π https://youtu.be/tzbqj2y_cbw β₯ Chapter-24 (Part-2) Snowflake ODBC Driver π https://youtu.be/X4uXkGS0dUQ β₯ Chapter-24 (Part-3) Snowflake Python Connector π coming-soon β₯ Chapter-25 coming-soon #snowflaketutorial #snowflakeSQL #snowflakecomputing #snowflakecontextfunction
Download
1 formatsVideo Formats
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.