Database "raw" does not exist or is not authorized

I get the error message: “Database ‘RAW’ does not exist or not authorized.”

I’m trying to follow step 1 of Quickstart for dbt Cloud and Snowflake | dbt Developer Hub

I’m totally new to this so I have no idea what to try to fix.

This is the code I pasted on the worksheet per instruction:

create warehouse transforming;
create database raw;
create database analytics;
create schema raw.jaffle_shop;
create schema raw.stripe;

Thanks in advance for your help!

2 Likes

Do you know which user dbt is using?

Does this user have access to the database/schema?

I’m having the same problem… trying to go through the dbt Cloud and Snowflake quickstart. I only have one user, which is my email address, and is listed as a developer which I think means I have access to everything.

Added the following permissions:
grant all on database RAW to pc_dbt_role;
grant all on schema RAW.JAFFLE_SHOP to pc_dbt_role;
grant all on table RAW.JAFFLE_SHOP.CUSTOMERS to role pc_dbt_role;
grant all on table RAW.JAFFLE_SHOP.ORDERS to role pc_dbt_role;