From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers

Unlock this course with a free trial

Join today to access over 25,100 courses taught by industry experts.

Snowpipe: Part 2

Snowpipe: Part 2 - Snowflake Tutorial

From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers

Start my 1-month free trial Buy for my team

Snowpipe: Part 2

“

- We've learned how to create an access policy in AWS, how to create a role associated with that policy, how to create an integration in Snowflake and make it aware of our AWS role, and how to edit the AWS role to make it aware of our Snowflake integration. In this video, we'll actually create a Snow Pipe and see it in action. Let's do it. First, let's create a new database and a table in that database and let's make sure we're using the public schema in our new database. Create or replace database S3 DB. Create or replace table S3 table. And we'll have a food column that's a string and a taste column that's an int. And then we'll use the public schema within S3 DB. Okay, now we're back to our old friend, the stage, we set the URL to our S3 bucket, and instead of putting a password or something like that in there, we pass our integration object to the stage. Remember that object is trusted by AWS. So the stage should be all set with the permissions it needs to pull data from S3. So…

Contents