I am a complete dbt newbie. I’m guessing that the process for creating a new project is as follows. Please correct or add anything I got wrong or missed:
Create a Snowflake account, login, create a sample database, create a table, and fill it with sample data. Note the account credentials for later use.
Note the special Snowflake connection parameter, for later use.
Create a dbt account
In the project creation wizard, put the connection parameter you noted in step 2 into the Account textbox.
put the name of the database you created in Snowflake in the database textbox.
put the word ‘Snowflake’ in the warehouse textbox.
put ACCOUNTADMIN in the role textbox
use the Snowflake credentials you created in step 1 in the Development Credentials Username and Password textboxes.
Ok, but there are TWO ‘warehouse’ textboxes on the new project form. The first one appears under the pick-the-vendor area, and the second one appears in the snowflake account area.
In snowflake, if one clicks on the area in the lower lefthand corner to the right of the snowflake icon, one can get all the info needed to properly format the ‘Account’ parameter for the dbt new project form. That I get.
But what does one put in the first ‘warehouse’ textbox?
The little issue is for the ones using snowflake trail … in the new ui, there no partner connect item in the menu as reported in the image in the guide… but it works using a more manual entry as above
