Uploaded March 2023 | Updated September 2026, 2 hours ago
The short video demonstrates the difference between having all privileges on a virtual warehouse and owning the warehouse. While having operate, usage, monitor, and modify grants allows for full control, ownership privileges are necessary to drop the warehouse or grant privileges to other roles. The short video provides an example of attempting to drop a warehouse with a public role that has all grants but no ownership, resulting in insufficient privileges. The conclusion is that ownership privileges are necessary to drop a warehouse
✏ Instagram: instagram.com/learn_dataengineering
✏ Twitter: twitter.com/de_simplified
✏ Facebook: fb.me/learndataengineering
✏ GitHub : github.com/TopperTips
✏ Website: toppertips.com
#shorts
#snowflaketutorial
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineeringsimplifed
#DESimplified
#toppertips
#dataengineering
#clouddatawarehouse
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.
The short video demonstrates the difference between having all privileges on a virtual warehouse and owning the warehouse. While having operate, usage, monitor, and modify grants allows for full control, ownership privileges are necessary to drop the warehouse or grant privileges to other roles. The short video provides an example of attempting to drop a warehouse with a public role that has all grants but no ownership, resulting in insufficient privileges. The conclusion is that ownership privileges are necessary to drop a warehouse
✏ Instagram: instagram.com/learn_dataengineering
✏ Twitter: twitter.com/de_simplified
✏ Facebook: fb.me/learndataengineering
✏ GitHub : github.com/TopperTips
✏ Website: toppertips.com
#shorts
#snowflaketutorial
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineeringsimplifed
#DESimplified
#toppertips
#dataengineering
#clouddatawarehouse
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.







![What is Snowflake Time Travel | Chapter-14 | Snowflake Hands-on Tutorial
Snowflakes Time Travel Feature is the most powerful and impactful utility, which, if used correctly and designed appropriately will save a lot of time and effort to simplify many complex data project operational activities. Time travel is not just limited to seeing the past state of your data, it brings a whole lot of new possibilities for the way design and operates data projects. This episode is a quick 30min introduction of time travel features and helps you to answer the following questions
1. What is time travel and how it works (conceptually)?
2. All editions of snowflake support time travel?
3. Time Travel and Fail-safe, both are the same?
4. How does time travel works for transient and temporary tables?
5. Does time travel cost a lot?
6. Time travel vs data retention parameters, are the same?
7. What is extended SQL for time travel?
8. Time Travel is applicable only for table or for DB as well as schema too?
So enjoy this video series and provide your valuable feedback.
🌐 Site: https://toppertips.com
🌐 SQL Scripts https://www.toppertips.com/snowflake-time-travel-feature
🚀 🚀 Chapters 🚀 🚀
➥ 00:00 What problem does time-travel solve?
➥ 01:08 Episode introduction
➥ 01:53 Course Tree Map
➥ 02:50 Why to subscribe to this channel
➥ 03:44 What is time travel?
➥ 08:15 Time travel vs Fails Safe?
➥ 07:59 Time Travel for Transitent & Temp Tables
➥ 12:01 Time Travel Hands-on - How to enable time travel
➥ 19:36 Time Travel Hands-on - Drop & Undrop Table, Database, Schema
➥ 22:56 Time Travel Hands-on - Clone (Create Table) with Time Travel
➥ 26:31 Time Travel Hands-on - Create Table As Select[CTAS with Time Tavel]
➥ 27:17 Time Travel Hands-on - Table Storage Cost for Time Travel
➥ 29:28 Time Travel Hands-on - Time Travel + SnowSight
➥ 30:40 Thank you note
🚀 🚀 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
➥ SnowPro Practice Test (60 Questions): https://bit.ly/2Ubernv
#timetravel #dropundrop #snowflakecomputing #snowflakeclustering #snowflakecompute #snowflaketimetravel #snowflakeedition What is Snowflake Time Travel | Chapter-14 | Snowflake Hands-on Tutorial](https://i.ytimg.com/vi/9k8ADXunhIk/mqdefault.jpg)


