Connect Amazon Redshift
Last updated
Last updated
Connecting Airbook to Redshift allows you to harness the power of your Redshift data for robust analysis and insights. Follow these steps to set up your Redshift connector in Airbook and start querying your data.
Prepare Your Redshift Database:
Ensure that your Redshift database is accessible from outside your VPC network. This is crucial for allowing Airbook to query your data.
Retrieve Endpoint Information:
Open your Redshift application and copy the endpoint URL.
Navigate to Airbook Connections:
Switch over to your Airbook workspace and click on the "Connections" tab located on the sidebar.
Select Redshift Connector:
From the list of available data sources, select "Redshift."
Enter Connection Details:
In the connection setup screen, paste your Redshift endpoint URL.
Remove everything after the colon (:) in the URL as this part represents the port number. The default port number for Redshift is 5439, so you will likely use this value.
Enter the name of your Redshift database. For this example, we'll use dev.
Provide Authentication Credentials:
Enter your AWS username and password associated with the Redshift database.
Whitelist Our IP Address:
To ensure seamless connectivity and the ability to query your database without interruptions, please whitelist our IP address: 34.122.205.142. This step is crucial for establishing a secure and stable connection between your database and Airbook, allowing us to retrieve and analyze your data effectively.
Test Connection:
Click the "Test Connection" button to ensure Airbook can connect to your Redshift database. If the test is successful, you'll see a success message. Otherwise, you'll be prompted to make the required corrections to your database credentials.
Save and Connect:
Once the connection test is successful, save your configuration. You’ll be prompted to give the connection a schema name. Enter a descriptive name and save it.
Wait for Ingestion:
Your Redshift data will start ingesting into Airbook. This process may take a while depending on the volume of data. If your Redshift data doesn’t show up immediately, give it a few minutes. You will receive an email notification once the data ingestion is complete.
Now that your Redshift account is connected, querying data is simple:
Go to the Query Section:
Navigate to the query section in your Airbook workspace.
Run a Query:
Enter your SQL query to fetch data from Redshift and hit the "Run Query" button.
View Results:
Your query results will be displayed, showing how easy it is to access and analyze data from Redshift within Airbook.