Redshift

You can use Redshift in Etleap to:

• Ingest data into your Redshift data warehouse.
• Build data pipelines with Redshift as your source.
• Create models and materialized views with your Redshift tables. Check out this page here for an introduction into Etleap models.

This page focuses on the connection setup required when using Redshift as a warehouse, source, or both.

Connection Setup

Step 1. Create a Database User

Follow these steps to create a new Redshift user with the minimal permissions to read from the schema and tables you would like to access.

1. Create a user.

   CREATE USER <user> WITH PASSWORD '<password>';

2. Grant appropriate permissions for the user:
   1. If using the Source Only option, grant usage permissions on schema and select permissions on all tables in the schema.

      GRANT USAGE ON SCHEMA <schema_name> TO <user>;
      GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO <user>;

   2. Otherwise, grant all permissions on schema by running:

      GRANT ALL ON SCHEMA <schema_name> TO <user>;

Step 2. Whitelist Etleap’s IP Addresses

To whitelist Etleap’s IP Addresses please follow the allow Redshift inbound access guide.

Key Considerations

Default Schema

If no schema is specified, the connection will use the default schema defined by Search path .

Optimizations

If your Redshift cluster is in the same availability zone as the intermediate bucket, the extractions will use UNLOAD queries instead of SELECT queries.