Daasity Knowledge Base
Ask or search…
K

Create a Redshift Test Warehouse

This page outlines the steps you need to take to create a test warehouse when you are using Redshift

Overview

The test warehouse feature allows you to follow good software development practices by enabling you to test your code in a non-production environment before merging your changes into production. Follow these steps to create your test warehouse
In AWS:
In the Daasity App:

Creating a snapshot in Redshift

Login into your AWS Redshift Console
Click on your cluster
Navigate to Actions
Click "Create Snapshot"
Give the snapshot a name and select the retention period for the backup. We recommend a the shortest amount of time as we only need this snapshot to provision a test warehouse

Restore the snapshot

Once the snapshot has been created, find the snapshot by clicking on the cluster you backed up and navigate to the snapshot screen
From the "Restore Snapshot" dropdown select "Restore to provisioned cluster"
Give the cluster a name, select "Production" and make sure to choose the appropriate Node type and number of nodes
You should select the same Node type and Number of nodes as the original cluster that you are copying
In the "Cluster permissions" make sure to add the correct IAM roles
You will not be able to access the Test Warehouse within Daasity if you do not add the correct IAM roles

Make the cluster publicly accessible

Click on the test cluster from the main page
Click on "Properties"
And set the permissions to "Publicly Accessible"
In the Daasity App navigate to the Warehouse page

Enter warehouse nformation

You will need to enter connection information for your Redshift Cluster
You can get this information from AWS
And enter into the Daasity App
Make sure to delete all the information after the .com that was copied over
Will become
You can copy the Port Number, Database Name, User Name and User Password from your production warehouse as these will be the same

Test the connection

Once the information has been added test the connection by clicking on "Test Connection"
Once the test passes click on "Provision Test Warehouse" to complete setup

Destroy test warehouse

Your test warehouse is a one-time snapshot of your production warehouse and thus you should destroy the test warehouse once your testing is complete. In order to destroy the test warehouse you will need to delete the cluster in Redshift and then destroy the test warehouse in the Daasity App