All Connectors
Redshift Native Data Connector
Redshift Native Data Connector
Redshift Native Data Connector
The Redshift Native Data Connector allows for connecting to a Redshift instance giving you an instant GraphQL API on top of your Redshift data.
About
Version
Released
December 2, 2024
Last Updated
December 3, 2024
GitHub Repo

Redshift Connector

Docs

With this connector, Hasura allows you to instantly create a real-time GraphQL API on top of your data models in Amazon Redshift Database. This connector supports Redshift's functionalities listed in the table below, allowing for efficient and scalable data operations. Additionally, users benefit from all the powerful features of Hasura’s Data Delivery Network (DDN) platform, including query pushdown capabilities that delegate query operations to the database, thereby enhancing query optimization and performance.

This connector implements the Data Connector Spec.

Features

Below, you'll find a matrix of all supported features for the Redshift connector:

FeatureSupportedNotes
Native Queries + Logical Models
Native Mutations
Simple Object Query
Filter / Search
Simple Aggregation
Sort
Paginate
Table Relationships
Views
Remote Relationships
Custom Fields
Mutations
Distinct
Enums
Naming Conventions
Default Values
User-defined Functions

Prerequisites

  1. Create a Hasura Cloud account
  2. Please ensure you have the DDN CLI and Docker installed
  3. Create a supergraph
  4. Create a subgraph

Using the Redshift connector

With the context set for an existing subgraph, initialize the connector:

ddn connector init -i

When the wizard runs, you'll be prompted to enter the following env vars necessary for your connector to function:

NameDescriptionRequired
REDSHIFT_JDBC_URLJDBC URL of your Redshift DBYes
REDSHIFT_USERNAMEUsername of your Redshift DBYes
REDSHIFT_PASSWORDPassword of your Redshift DBYes

After the CLI initializes the connector, you'll need to:

License

The Hasura Redshift connector is available under the Apache License 2.0.

2024 Edition

The GraphQL Handbook

A GraphQL Handbook for developers and architects to help plan your GraphQL adoption journey.
The GraphQL Handbook

Ship a rock-solid API on your data – in minutes!