The info in this doc is only applicable to NEW Redshift connections.
If you HAVE previously replicated data from Stitch to Redshift, click here.
As we mentioned when you created the cluster, the credentials used to launch the cluster belong to the master user, or admin, for the cluster. If you want to control the permission settings, you'll need to create an additional database user for Stitch.
While you can create a Redshift user for us at any time, we highly recommend doing so before any data is replicated into your data warehouse. The process for creating a user for us after replication has taken place is considerably lengthier than what's required for a new connection.
Creating a Redshift user requires superuser permissions. If you’re not a Redshift superuser or you’re not sure what this means, please contact someone on your technical team before proceeding.
To successfully pipe your data to your Redshift data warehouse, the Stitch user needs permission to:
CREATEschemas, tables, and views
SELECTfrom systems tables
Additionally, the Stitch user must be the owner of all integration schemas and the tables they contain. This is because our user will occasionally need to run
ALTER TABLE commands to properly insert your data.
Restricting the Stitch user to a single schema or revoking public access to tables in the information schema will prevent Stitch from functioning properly. If you'd like guidance or more info on why we need these permissions, please reach out to us.
For reference, you can find the full list of Redshift permissions here.
You must be a superuser to create a Redshift user. Please contact your technical team if you're not sure what this means or how to proceed.
Note that the instructions below were tested using a Redshift instance with the default configuration.
First, connect to your Redshift instance using your SQL client. If you did the connection test in the last step, you may already be connected. Note that anything inside square brackets -
[like this] - is something you need to define when running the commands yourself.
After connecting, run this command to create the user:
create user [stitch_username] with password '[password]';
Next, you'll assign the
CREATE permissions to the user. For
[database name], enter the name of the database you created when you launched the cluster:
grant create on database [database_name] to [stitch_username];
If you restricted access to the information schema on your cluster, you'll also need to run this command to grant the Stitch user
grant select on all tables in schema information_schema to [stitch_username];
After you've created the Stitch user, all that remains is connecting Stitch to your Redshift data warehouse.