#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 🌐 • Episode #1 | Snowflake SQL Context Fu...
➥ Episode #2 Date & Time SQL context function 🌐 • #2 | Date & Time Context Functions | ...
➥ Episode #3 current IP Address context function 🌐 • #3 | Current IP Address Context Funct...
➥ Episode #4 client(), accocunt(), session() etc context function 🌐 • #4 | Session, Statement, Roles & Name...
➥ Episode #5 Current IP Address context function 🌐 • #5 | Current & Last Transaction Conte...
➥ 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 ...
🚀 🚀 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 |...
➥ Chapter-6 Snowflake Unique Features 🌐 • Snowflake Unique Features | Chapter-6...
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 • Snowflake Database/Schema/Table & Con...
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 • Snowflake Must Know New Objects | Ch...
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 • Fast Data Loading & Bulk Ingestion in...
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 • Continuous Data Loading & Data Ingest...
➥ Chapter-11 Snowflake External Table 🌐 • How to work with external table in Sn...
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 • How To Work With Snowflake Virtual Wa...
➥ Chapter-13 Snowflake Micro Partition 🌐 • #13 | Micro Partitions & Data Cluster...
➥ Chapter-14 Snowflake Time Travel 🌐 • What is Snowflake Time Travel | Chapt...
➥ Chapter-15 Snowflake Clone Feature 🌐 • Snowflake Zero Copy Clone | Chapter-1...
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 • Snowflake Data Sharing | Chapter-16 |...
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 • Snowflake Stream & Change Data Captur...
➥ Chapter-18 Snowflake Task & Task Tree 🌐 • Snowflake Tasks & Task Tree | Chapter...
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 • ETL Workflow In Snowflake | Chapter-1...
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 • Role, Grants & Role Hierarchy In Snow...
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 • Stored Procedure In Snowflake | Chapt...
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐 • User Defined Functions In Snowflake |...
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 • What are views in Snowflake | Chapte...
➥ Chapter-22 Snowflake Information Schema 🌐 • What Is Information Schema In Snowfla...
➥ Chapter-23 Snowflake Resource Monitor 🌐 • What Is Resource Monitor In Snowflake...
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 • How to Use Snowflake Java JDBC Driver...
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 • Microsoft Excel & Snowflake ODBC Driv...
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 coming-soon
➥ Chapter-25 coming-soon
#snowflaketutorial
#snowflakeSQL
#snowflakecomputing
#snowflakecontextfunction
Auf dieser Seite können Sie das Online-Video #2 | Date & Time Context Functions | Snowflake SQL Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Data Engineering Simplified 27 Juli 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 7,153 Mal angesehen und es wurde von 105 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
