Ready to get the most from your Amazon Redshift data? Get started by setting up a connection between Klipfolio Klips and your Redshift database and adding some data sources.
When you're finished adding Redshift data sources, you'll use them to power your custom Klips.
Note: Before connecting to your Redshift database, make sure you have Klipfolio's IP addresses set up in your DB security group.
This article includes:
Adding an Amazon Redshift data source
To add an Amazon Redshift data source:
- Click the + beside Data Sources in the left navigation sidebar.
Note: If you don’t see this option, go to the bottom of the left navigation sidebar and click your Account Name > Data Sources > Create a New Data Source instead. - On the Where is your data? page, select Amazon Redshift.
- On the Configure your connection page, fill in the following fields:
- Host: Enter the URL for the server that hosts your Amazon Redshift database.
- Port: Port 5439 is entered here by default. As per Amazon Redshift documentation, you can change to another port within the range of 5431-5455 or 8191-8215.
- Database: Enter the name of the database you want to connect to.
- Driver: Select PostgreSQL (Legacy) from the drop-down list.
- Username: Enter your Amazon Redshift user name.
- Password: Enter your Amazon Redshift password.
- SQL Query: Enter the desired SQL query, replacing the placeholder text <databaseTable> with your own database table name.
- Select whether to Include column headers.
- At Connection security, choose whether to use SSL/TLS.
- If the database is behind a firewall but accessible using an SSH tunnel, click Use an SSH tunnel and enter the required credentials.
(See below for an example of configuration settings for an Amazon Redshift data source).
- Click Get data.
- Ensure this is the data you’re looking for. Optionally select the checkbox to Model your data.
Learn more about modelling data sources. - Click Continue.
- Name, choose refresh settings, and, optionally, share your data source.
- Click Save.
The data source is added to your account and is ready to use for custom Klips. You can see all your data sources in your Data Source Library, accessed by clicking Data Sources in the left navigation sidebar.
Troubleshooting your connection
If you followed the instructions in the procedures above but still can’t connect to Klipfolio, consider the following:
- Have you added our Klipfolio IP addresses to your allow list? See the full list of allow list IP addresses.
- Is your database's external IP address publicly accessible and are you able to resolve the IP address to your database server? To test internally, ping or telnet your database's IP address. If unsuccessful, check your firewall configuration.
- Is the port open? Go to the Port forwarding tester to test your port's status. If the port is not open, it might be a bad route or the destination SQL device might not be properly configured to listen to that port.
- If you’re using an SSH tunnel, is the domain account valid?
Troubleshooting your query
Here are a few troubleshooting ideas you can try if you're having issues with your Amazon Redshift query:
- Confirm that the SQL connection is working by using a query of Select 1. This should return the result of 1.
- Make sure your query isn’t trying to bring in too much data. Klipfolio supports a maximum file size of 10 MB. If you’re returning more than 10 MB of data, your query may not work. To see if this is the issue, try adding a LIMIT to your query (e.g., LIMIT 1000) to reduce the amount of data being returned.
- Confirm that it isn't taking too long to bring in your data. Klipfolio includes a global setting of 80 seconds within which to bring in data. If you think this might be the issue, try reducing the amount of your data so you stay within this range.
Next steps
Great! You've connected to your Amazon Redshift data and created one (or more) data sources. Now you're ready to use those data sources in custom Klips. Up next - Build Klips and dashboards.