Back to Browse

#3 | Current IP Address Context Functions | Snowflake SQL Tutorial

3.3K views
Aug 2, 2021
18:57

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 formats

Video Formats

360pmp426.5 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

#3 | Current IP Address Context Functions | Snowflake SQL Tutorial | NatokHD