From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 24,600 courses taught by industry experts.
Permanent, transient, and temporary tables - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Permanent, transient, and temporary tables
- In the last video, we talked about time travel and we mentioned that each table has a retention period. Time travel also applies to databases and schemas, as you can probably guess from the fact that you can undrop databases and schemas. But we chose to focus on tables. We haven't discussed this yet, but Snowflake also provides an additional seven day fail safe period after the retention period has elapsed during which Snowflake staff can help you recover historical data. But to use fail safe, you have to contact the Snowflake team directly and get their help. It's a last resort. It turns out that understanding retention periods and the fail safe period is key to what we'll discuss next. The differences between three of the main table types in Snowflake, permanent tables, transient tables, and temporary tables. This is useful but not complicated, so we'll move through this quickly. Let's dig in by quickly creating a table of each of these types using our tasty bytes data, and then…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.