What Is Information Schema In Snowflake | Chapter-22 | Snowflake Hands-on Tutorial

If you want to build a solid understanding about Snowflake Information Schema (What is information schema and How to get information schema in snowflake), then this chapter is for you. The power of Snowflake Information Schema is not well known and the usefulness it brings to data developers and data ops engineers are not discussed anywhere. This episode is a comprehensive & practical guide with hands-on excercise on snowflake information schema. It explains all the views available under information including table functions and will help you to answer the following questions 1. 🙋 Does Information Schema hold account level objects? 2. 🙋 Can I get load history data from Information Schema? 3. 🙋 Information Schema views are secure views or standard views? 4. 🙋 Does querying Information Schema cost a lot? 5. 🙋 Can I build snowsight dashboard using Information Schema? 6. 🙋 How can I list table functions exist inside Information Schema? 7. 🙋 What is the difference between Information Schema and account usage schema? So enjoy this video series and provide your valuable feedback. 🌐 Site: https://toppertips.com 🌐 SQL Scripts https://toppertips.com/what-is-information-schema-in-snowflake 🚀 🚀 Chapters 🚀 🚀 ----------------------------------------- ➥ 00:00 What Is Information Schema In Snowflake? ➥ 01:53 Episode-22 Introduction ➥ 02:51 Why to subscribe to this channel ➥ 03:54 How do I get information schema ➥ 07:07 Database, Schema ➥ 11:57 Table, Columns, Constraints ➥ 16:02 External Table ➥ 17:25 UDFs, Procedures & Views ➥ 19:44 File Format, Sequences & Stages ➥ 23:49 Role, Object Privileges & Usage Privileges ➥ 30:48 Packages & Replication Database Views ➥ 33:12 Snowsight Dashboard Using Snowflake Information Schema ➥ 35:00 Information Schema Table Functions ➥ 36:28 Difference between Information Schema vs Account Usage ➥ 38:45 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 2022 Syllabus: https://youtu.be/jhNoKeB0CVY ➥ SnowPro Guide: https://bit.ly/35S7Rcb #InformationSchema #snowflakecomputing