Redshift setup

We recommend creating a separate user for Modelbit.

Creating a user for Modelbit

In your Redshift warehouse, run the create user command:

create user modelbit_user password '<choose a password>';

Grant usage on your schema, and select on any tables you want to use with Modelbit:

grant usage on schema SCHEMA_NAME to modelbit_user;
grant select on table SCHEMA_NAME.TABLE_NAME to modelbit_user;

Create the connection

To add a Redshift warehouse to Modelbit, click Add a Warehouse within Settings, choose Redshift and name the connection. Then supply the warehouse information and user credentials to complete the connection.