How to create a query in Dataslayer for Amazon RedShift

In this article, we will explain everything you need to know to create a query in AWS RedShift with Dataslayer. Just follow these simple steps.

1.  Log in to our website.

2.  Click on Open under the Amazon RedShift Destination.

3.  You will see the index of your queries, click on New Transfer.

1.  Select the email you want to connect with.

• If you are already logged in to the Hub, select the email and click Confirm.
• If you are not logged in, click Manage Hub Accounts and follow the steps to add a new account.

2.  Select the data you want to include in your query.

• You will need to select a date range.
• The metrics and dimensions you want to add.
• Filters and options if needed.

Save as a Template

1.  Select the Cluster you want to connect with.

• If you are already logged in to a cluster, select the link on the drop-down and click Transfer Data.
• If you are not logged in, click on Connect with AWS and follow the steps to add a new cluster.

2. Fill in all the fields.

• Transfer Name: This will be the name of the transfer in Dataslayer. This name is only visible to you and is not transferred to AWS.
• Time zone: Select your time zone.
• Table: In the drop-down, you can select an already created table or create a new table.
• Table name: If you have selected the "Create new table" option on the previous field, set here the name of your new table.
• Write mode: Select the write mode you want.

3. Select the Sync Frequency of your transfer.

4. Done! Finally, save your transfer.

• Click on Save to only save your transfer in Dataslayer. 
• Click on Save & Refresh Now to save the transfer and insert the data on RedShift.

 

Preview

If you want to see what the table you have created will look like, you can click on the Preview button to see it.

This way you can make modifications, if you have detected any errors or if you want to change the order of the columns, before uploading the table into AWS.

Preview

As always, please do not hesitate to contact us via our live chat on our website or via e-mail if you still have doubts or questions. We are happy to help!