🔴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.

IP Address
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:

Field	Description	Example
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.