From the course: Learning SnowflakeDB
Join today to access over 23,200 courses taught by industry experts.
Learn the Snowflake data life cycle - Snowflake Tutorial
From the course: Learning SnowflakeDB
Learn the Snowflake data life cycle
- [Instructor] As we think about patterns and integrations, I am pulling again from the Snowflake documentation here. This is a great graphic showing the data lifecycle, and that's really what we organize our services around. So you can see that we start with organizing data by creating databases, schemas, and tables, and then we store data, we insert into our tables, then we query, and then we're going to work with our data, update, merge or delete. And we might be cloning our tables, schemas and databases. And then we could be removing data. In some scenarios data's never removed, it's just marked as not current or active, but if we need to remove it, truncate table, drop table, drop schema, or drop database. When we think about this, this can be accomplished in as simple as using anti-SQL commands, or we can use some of the tools available in Snowflake, or in some of our hosting cloud partners. Now, to show you some example…
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.