Another integration that DataCamp Workspace supports is a connection to Amazon Redshift clusters. Using environment variables, you can connect your own workspace to data stored in a Redshift cluster. Make sure to understand how to set up and connect integrations securely to you workspace, as explained in this article.
Once you are familiar with the concept of environment variables, you can insert your Redshift credentials as follows. Pay attention to the names chosen for the environment variables. These should be consistent with the ones you use in your workspace itself.
The value of these environment variables will now get securely saved. You can use them in your workspace and connect them to your cluster. Check out the following code sample to set up a connection using the pre-installed
conn = redshift_connector.connect(
Sample database: online ticket sales
We also provide you with a sample database about online ticket sales for events such as sporting events, shows, and concerts (source). If you want to connect to the Amazon Redshift cluster that hosts these files, there are only two things you will need to do.
Next, connect the following set of credentials to your workspace. These will give you read access to the sample database.
REDSHIFT_DB_NAME = online_ticket_sales
REDSHIFT_HOST = workspace-redshift-cluster-demo-prod.ceh21gkfoxgb.us-east-1.redshift.amazonaws.com
REDSHIFT_PASSWORD = Workspace1
REDSHIFT_USER = workspace