Get Started with Hasura Cloud and Amazon Redshift
Introduction
Step 1: Create an account on Hasura Cloud and create a new Hasura Project
Navigate to cloud.hasura.io, and create a new Hasura Cloud account.
Once you create a project on Hasura Cloud, hit the "Launch Console" button to open the Hasura Console for your project.
Step 2: Add your Amazon Redshift database as a source to Hasura
Head to the Data > Manage databases section on the Console to add your Amazon Redshift database as a source to Hasura.
- Allow public connections or allowlist the Hasura Cloud IP on your Amazon Redshift firewall: This is good for testing and will allow you to quickly try Hasura out with your database!
- VPC peering: VPC peering and private network access is available on Hasura Cloud paid tiers: Recommended for production. Get in touch with us if you'd like to try this out against your existing databases!
First, we need to add the redshift agent:
Now we need to connect to Redshift by clicking Connect Database:
Next, choose the redshift (Beta) driver:
Finally, enter your Amazon Redshift database URL and
database schema and click Connect Database:
Once you add the Amazon Redshift service, you'll see it listed as an available database on the sidebar.
Step 3: Track existing tables
To query against your Amazon Redshift service using Hasura, you'll need to have existing tables to select. Those tables will appear under the database as shown.
Track tables selectively or all so that Hasura can introspect the tables and create the corresponding GraphQL schema.
Once you've selected the tables you'd like to track, click Track Selected to finish setup:
Step 4: Try out a GraphQL query
Head to the API tab in the Console and try running a GraphQL query! Use the explorer sidebar on GraphQL to get help in
creating a GraphQL query.
Keep up to date
Currently, Hasura supports read-only queries, subscriptions, relationships, and permissions on Amazon Redshift.
If you'd like to stay informed about the status of Amazon Redshift support, subscribe to our newsletter and join our discord!
