Skip to main content

Snowflake setup

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

Start by creating a new role:

create role modelbit_role;

Create a user and assign it the new role:

create user modelbit_user
password='<choose a password>'
default_role = modelbit_role
must_change_password = false;

grant role modelbit_role to user modelbit_user;

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

grant usage on warehouse WAREHOUSE_NAME to role modelbit_role;
grant usage on database DB_NAME to role modelbit_role;
grant usage on schema SCHEMA_NAME to role modelbit_role;
grant select on table TABLE_NAME to role modelbit_role;

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