What are views in Snowflake | Chapter-21.3 | Snowflake Hands-on Tutorial

Snowflake views allows data developer to wrap their complex SQL logic (join, filter, group by etc) and bring simplicity & modularity to their data retrival process to their SQL expressions. This episode is a comprehensive & practical guide with hands-on excercise on snowflake views (Standard, Secure & Materialized). It covers basics of snowflake views, limitations and best practices. This guide will help you to answer the following questions 1. 🙋 What are standard, secure & materiazlied views in snowflake ? 2. 🙋 How to interact with views in snowflake? 3. 🙋 Difference between standard and secure views in snowflake? 4. 🙋 What are the limitation of views in snowflake? 5. 🙋 Can views be created on stream objects? 6. 🙋 Can views be ccreated on temporary and transient snowflake tables? 7. 🙋 What are snowflake views best practice? So enjoy this video series and provide your valuable feedback. 🌐 Site: https://toppertips.com 🌐 SQL Scripts https://toppertips.com/introduction-to-snowflake-views-with-examples 🚀 🚀 Chapters 🚀 🚀 ----------------------------------------- ➥ 00:00 Whare are views in Snowflake? ➥ 03:00 Episode-21 (part-3) Introduction ➥ 03:46 Why to subscribe to this channel ➥ 04:50 Create Standard View in snowflake ➥ 09:12 Create Secure View in Snowflake ➥ 12:45 Understand View's SQL Construct ➥ 14:14 What Happens to View when underlying table deleted or altered ➥ 16:40 Interact with Snowflake Views ➥ 23:09 Snowflake Materialized View ➥ 26:14 Snowflake Views And Snowsight/Legacy WebUI ➥ 30:01 Snowflake Materialized View SQL Construct ➥ 31:17 Snowflake Recursive View ➥ 33:45 Snowflake Recursive View SQL Construct ➥ 34:09 Snowflake Views On Transient & Temporary Tables ➥ 36:28 Snowflake Views On Stream Object ➥ 42:17 Snowsight Dashboard for Snowflake Views ➥ 43:40 Snowflake Views Best Practice & Limitations ➥ 46:24 Snowflake Materialized Views Best Practice & Limitations ➥ 47:00 Thank you note & Disclaimer 🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀 --------------------------------------------------------------------------------------------------- ➥ Chapter 1-to-25 "Complete Playlist" 🌐 https://bit.ly/3iNTVGI ➥ 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 🌐 https://youtu.be/ZrhTYKuGFbo ➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon ➥ Chapter-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon 🚀 🚀 Snowflake Certification Complete Guide & Question Dump 🚀 🚀 ----------------------------------------------------------------------------------------------------------------- ➥ Revised Sep 2020 Syllabus: https://youtu.be/jhNoKeB0CVY ➥ SnowPro Guide: https://bit.ly/35S7Rcb #SnowflakeViews #DatabaseViews #MaterializedViews #snowflakecomputing