ContextQMD
Back to Graphql Engine

Get Started with Hasura Cloud and Amazon Redshift

docs/docs/databases/redshift/getting-started/cloud.mdx

2.49.43.6 KB
Original Source

import Thumbnail from '@site/src/components/Thumbnail';

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.

<Thumbnail src="/img/databases/data-connector/create-project.png" alt="Connect new or existing database" width="1000px" />

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.

:::info Make sure your Amazon Redshift service is reachable by Hasura Cloud:

  1. 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!
  2. 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:

<Thumbnail src="/img/databases/redshift/redshift-add-agent.png" alt="Adding the Amazon Redshift agent" width="1000px" />

Now we need to connect to Redshift by clicking Connect Database:

<Thumbnail src="/img/databases/data-connector/manage-databases.png" alt="Manage databases" width="1000px" />

Next, choose the redshift (Beta) driver:

<Thumbnail src="/img/databases/redshift/redshift-add-service1.png" alt="Adding the Amazon Redshift service" width="1000px" />

Finally, enter your Amazon Redshift database URL and database schema and click Connect Database:

<Thumbnail src="/img/databases/redshift/redshift-add-service2.png" alt="Setting the Amazon Redshift connection details." width="1000px" />

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.

<Thumbnail src="/img/databases/redshift/redshift-tracking-tables1.png" alt="Tracking tables." width="1000px" />

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:

<Thumbnail src="/img/databases/redshift/redshift-tracking-tables2.png" alt="Tracking tables selected." width="1000px" />

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.

<Thumbnail src="/img/databases/redshift/make-graphql-query.png" alt="Try a GraphQL query" width="1000px" />

Keep up to date

:::info Note

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!