🔜Redshift (Coming Soon)

How does Rasgo work with Redshift?

Rasgo is a metadata-only product, meaning all of your actual rows and columns stay in your data warehouse and Rasgo interacts with your data via dynamically generating SQL.

Rasgo performs both reads and writes to Redshift:

  • Rasgo catalogs tables and views in any database it has access to

  • Rasgo dynamically generates and executes SQL on behalf of the user to transform and analyze data

  • Rasgo can publish new tables and views into a single Redshift database

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 account user credentials to authenticate to and execute SQL queries in your account.

When connecting Rasgo to your Redshift account, you'll need to provide this info:

FieldDescriptionExample

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