🔴Redshift
How does Rasgo work with Redshift?
Rasgo is a metadata-only product, meaning all of your actual data stay in your data warehouse and Rasgo queries it there via dynamically generating SQL.
Rasgo performs reads-only operations in your Redshift env:
Rasgo reads the information schema for tables and columns it has access to
Rasgo dynamically generates and executes SQL on behalf of the user to analyze data
Connecting to Redshift
IP Restrictions
Rasgo will always connect to your account from these IP addresses. Make sure to whitelist them if you have networking restrictions enabled in AWS.
Credentials
Rasgo needs service credentials to authenticate and execute SQL queries in your account.
When connecting Rasgo to your Redshift account, you'll need to provide this info:
Running Asynchronously
Rasgo connects to your Redshift account using AWS's python connector. This limits the response time of individual queries to 30 seconds. If a query does not return results in under 30 seconds, the connection will be terminated and Rasgo will return an error message to the end user.
If your use case requires queries that take longer than 30 seconds, you can configure Rasgo to connect to your Data API to run queries asynchronously. This will require enabling the API in your AWS account and providing an API key in addition to the above service credentials.
Success!
Configuration is complete! You're ready to start using Rasgo.
Last updated