Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Step 6: Creating a Stitch User for a NEW Redshift Connection

JUMP TO

Important!
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.

Required Redshift Permissions

To successfully pipe your data to your Redshift data warehouse, the Stitch user needs permission to:

  • CREATE schemas, tables, and views
  • SELECT from 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 COMMENT and 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.

Creating the Stitch User

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 SELECT permissions:

grant select on all tables in schema information_schema to [stitch_username];

What do I do now?

After you've created the Stitch user, all that remains is connecting Stitch to your Redshift data warehouse.

Next: Connect Stitch to Redshift

Previous: Test the Connection

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!