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"
Navigate to the Warehouse page
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
Last updated
