#2 | Date & Time Context Functions | Snowflake SQL Tutorial смотреть онлайн

Episode #2 of Snowflake SQL Context Functions Part-2 demonstrates the power of date and time context functions with real-life examples. This hands-on practice video series gives you in-depth knowledge about each Snowflake SQL function.



Share you Snowflake Story: https://forms.gle/KT9BwZd9b3JJ8s3RA

? ? Chapters ? ?
-----------------------------------------
01:00 What is covered in this chapter
01:38 Where can I find SQL Script
01:56 Where can I find Snowflake Docs
02:28 What is context function are discussed
02:40 Snowflake Definition
04:11 sysdate() vs current_timestamp()
05:12 Live Demo - general behaviour
09:33 Live Demo - Column with default value
13:38 Live Demo - Timezone & Date/Time Context Functions
16:28 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