Skip to main content

Redshift setup

We recommend creating a separate user for Modelbit's queries.

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;

Now that your warehouse is connected to Modelbit, configure Redshift to call your deployments.