From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 24,800 courses taught by industry experts.
Tables: Part 2 - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Tables: Part 2
- Earlier we tried querying the table we created, but we were sort of foiled because the table was empty. But now we're going to insert some data. So by the end of this video we'll be able to cackle with victory and say, oh, how the tables have turned. Anyway, let's insert some data into our table so we can drop it, undrop it, and more. (transition whooshing) So let's insert one row as a test, insert into test database, test schema, test table values, and then put these values. For now, we'll put null for the variant and geography types since those are a little more involved. If we query the table now, select star from, test database, test schema dot test table. We see the data we inserted. Let's drop and undrop our table as we did in the previous video with databases and schemas. It's simple, just drop table, followed by the fully qualified table name, which is the table name with the database and schema specified. So drop table, test database, test schema, test table. Now let's run…
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.