🔴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.
54.84.138.60
54.84.66.109
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:
Database
Database to create new views and tables in
RASGO
Schema
Schema to create new views and tables in
PUBLIC
Host
Connection string
my-cluster.abc.us-east-2.redshift.amazonaws.com
User
Redshift username
RASGO_USER
Password
Redshift password
i<3rasgo
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