Guide: Using Amazon Redshift with Databox

HOW TO

    AWS Redshift connections are available in Plus and Business Accounts. Agency Basic Accounts have the ability to use AWS Redshift in the Agency Account only.

How to prepare your AWS Redshift Cluster

1
 Login to AWS Console, then navigate to Services / Redshift 
2
  Click on Launch Cluster and fill-in the Cluster details:

add_user_popup@2x

3
 Next, we'll choose the Node Configuration. For our example, we'll use the weakest node type  dc1.large and  Single Node Cluster Type

add_user_popup@2x

3
 Next, we'll be directed to the Additional Configuration screen. Screen settings will depend on your network setup. For our example, the default settings will work. 

4
 After reviewing our configuration, we'll click Launch Cluster. A new cluster will take some time to build. When it’s ready, click on Cluster Name and the cluster overview will be shown. 
4
 The hostname to connect to will also be visible from the endpoint string. In our example, the hostname is   redshift1.cssy86qcwxay.eu-central-1.redshift.amazonaws.com.

Our server should now be successfully set up to accept requests from Databox's IP (  52.4.198.118) to our Amazon Redshift cluster database, using our selected user name and password. 

How to connect AWS Redshift to Databox

Once our Database is properly prepared, we'll connect it to Databox.

To connect AWS Redshift to Databox, go to Data Sources > + New connection. Type AmazonRedshift in the search bar and click on the green Connect button. 

This will open the  Activation window, which is where you will be prompted to enter your connection data and authorize the Databox app. 

add_user_popup@2x

Click the green Activate button to complete the connection process. If AWS Redshift was successfully connected, the Activation window will close shortly and you'll see a Connected notice. 

If you see a notice that says Wrong Credentials, doublecheck your user data before re-entering them in the Activation window. 

If you have difficulty connecting, be sure the IP or hostname entered is publicly available or access is granted to Databox's public IP (52.4.198.118). 

How to use the Query Builder for AWS Redshift

The Query Builder for AWS Redshift allows you to create Custom Metrics using data from your Database to use in Databoards, Alerts, Goals, etc. Learn more about the Query Builder for AWS Redshift here

Additional Information

  • Query results are limited to 1000 rows. If you expect your query to return over 1000 rows or if you're not sure how many rows will be returned, be sure to LIMIT the query
  • The query must contain a column named "Date." If you need to, use AS in your SELECT statement to satisfy this requirement
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us