From the course: Amazon Web Services: Data Services

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Connect to AWS Redshift with AWS query editor

Connect to AWS Redshift with AWS query editor - Amazon Web Services (AWS) Tutorial

From the course: Amazon Web Services: Data Services

Start my 1-month free trial

Connect to AWS Redshift with AWS query editor

- [Instructor] So to use the integrated editor, as I mentioned, you have to have an IAM role associated if you're going to be pulling in data out of an external store. In my case, it was S3 and I did make that mistake when I set that up so I just want to call that out. You have to have that IAM role associated. So once you have that, then you go into the editor. And, I actually just executed a series of queries based on Amazon blog posts that I referenced in the GitHub information. So, I created this schema called myinternalschema. And then, to that, I created a table called the Event table and with the following columns, you can see in lines three through eight with data types associated. And then this was the key point. It took a little bit of time to get this to work properly, so I'm just going to point out the aspects that I thought were tricky. In line one, you're pulling data out of a public bucket on S3. In line 2…

Contents