Getting started with Stitch using Amazon Redshift

Hi, my name is Anthony and I’m going to show you how to get started using Stitch. The whole process only takes a few minutes, but works best if you have all of your credentials ready to go. To make the setup process easier you can add a team member from within your Stitch account. You’ll need full access to an AWS account to follow along with this video. More information, check out the Stitch docs, and Amazon’s documentation on getting started with Redshift. So let’s get started. From our destination page, I’ll click on Redshift. And here’s a look at some of the fields we’ll need to fill out. There’s a bit of setup involved, and so I’ll go to our Stitch docs to walk me through that. There are a few things you’ll need first. Full permissions to an AWS account and up and running Redshift instance, which I’m going to start up in a second. If you need to get a teammate involved, you can invite them from the configuration page we were just on. I’ll be using a direct connection in this video, but there’s also a section that covers an SSH tunnel. This section guides you through the setup steps, but first we’ll need to log into our AWS account. In a new tab I’ll navigate to, and click my account and then AWS management console. I’ll sign it with my email and password. From the homepage, I’ll go to services and then under databases, go to Amazon Redshift. In this page, I’ll go to clusters and then I’ll click on create cluster. For this demo, I’ll use dc2.large, but you can learn more about the other options on the AWS website. I’ll use the default username and create a password. I won’t be using an IAM role, but you can learn more about this on the AWS site. For this quick demo, I’ll be using all the default settings so I can just click create cluster. It can take a few minutes for the cluster to get created, so I’m going to speed things up here. And once that’s available, you can go into your cluster and go to the properties. Here’s your end point, which we’ll need later. And we’ll also need the database name, the port number, and the username. But first we need to make a few changes so that this can all work with Stitch. First thing I’ll do is make it publicly accessible. This can take a few moments as well, but once it’s done, you can go back to properties and see that it now says yes. The next thing we’ll need to do, which is outlined in the docs is white list the necessary IP addresses. I’ll click on this link under VPC security group to open it in a new tab. From here, I’ll click on create security group and then refer back to the docs to walk me through what I need to do. So we just got through create security group and now we need to give it a name, description and check the VPC. I’ll just put Stitch and Stitch and check that the VPC matches the one for our cluster. And now we can start adding rules. I’ll go back to our docs to help me out here. I need to choose custom TCP rule and port 5439. And I’ll copy the first IP address and paste it under source. And I’m just going to go ahead and do this for the rest of the IP addresses. All the IP addresses are listed in our Stitch docs. Now, once I’m done, I’ll just check to make sure it was created and now we can see it here. And now check back with our Stitch docs. So we wrapped up this part and now we need to create a Redshift user. Before I do that though, I’ll just add the security group we just created. I’ll click edit and then add the security group called Stitch. And once that’s done, we can go back to the properties and see that both security groups are now there. And now we can move on to creating a Stitch database user. To do this, I’ll go to the query editor and log in using the database name and master username for our Redshift cluster, which were found on the properties page. In the query editor, I’ll run a few statements, which are all found in our docs. Some of these queries take a few seconds to run, and so you’ll notice that I’ll speed things up in the video a bit. The first statement is to create a user called Stitch, and you’ll just need to fill in a secure password. Once that’s done, I’ll comment it out and get the next statement from our docs. This next one here is to give the Stitch user create permissions, and we just need to fill in the database name here. And then we can run it. And finally we just need a grant select permissions with these two last statements here. And now it’s time to start filling out destination form. So we’ll need this end point here, just be sure to delete the port number and the database name, which has everything including an after the colon. We’ll need the master username and password, and our database name. And we took care of this part earlier so we can just check and save. Once this is done, we’ll be ready to move our first of data. I hope this video is helpful and I hope you’re feeling ready to get started using Stitch.

Leave a Reply

Your email address will not be published. Required fields are marked *