#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
На этой странице сайта вы можете посмотреть видео онлайн #2 | Date & Time Context Functions | Snowflake SQL Tutorial длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Data Engineering Simplified 27 Июль 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 7,153 раз и оно понравилось 105 зрителям. Приятного просмотра!
