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.