# Completing the Project Wizard

**URL:** <https://discourse.getdbt.com/t/completing-the-project-wizard/5504>\
**Category:** Help\
**Tags:** snowflake, dbt-cloud, getting-started\
**Created:** [December 7, 2022, 12:55am UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504 "2022-12-07T00:55:29Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![pudnik26354](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/pudnik26354/32/1421_2.png) [@pudnik26354](https://discourse.getdbt.com/u/pudnik26354)\
**Post date:** [December 7, 2022, 12:55am UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504/1 "2022-12-07T00:55:29Z")

</div>

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:

1. 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.
2. Note the special Snowflake connection parameter, for later use.
3. Create a dbt account
4. In the project creation wizard, put the connection parameter you noted in step 2 into the Account textbox.
5. put the name of the database you created in Snowflake in the database textbox.
6. put the word ‘Snowflake’ in the warehouse textbox.
7. put ACCOUNTADMIN in the role textbox
8. use the Snowflake credentials you created in step 1 in the Development Credentials Username and Password textboxes.
9. Click the ‘Test Connection’ button.

---

<div class="post-metadata">

**Author:** ![jeffsk](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/jeffsk/32/1250_2.png) [@jeffsk](https://discourse.getdbt.com/u/jeffsk)\
**Post date:** [December 8, 2022, 5:34pm UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504/2 "2022-12-08T17:34:27Z")

</div>

Hello @pudnik26354 , welcome to the dbt community!

Overall, see this link first.

> **[Quickstart for dbt Cloud and Snowflake | dbt Developer Hub](https://docs.getdbt.com/guides/snowflake)**
>
> Introduction

Specific notes on your steps:

> [@pudnik26354](#):
>
> 1. Note the special Snowflake connection parameter, for later use.

It should be in the form of: `my-account-id.my-region.my-cloud-provider` for example `ab138543.east-us-2.azure` or `zo234532.east-us-2.aws`

> [@pudnik26354](#):
>
> put the word ‘Snowflake’ in the warehouse textbox.

the warehouse is not “Snowflake”, it is the name of the [Virtual Warehouse](https://docs.snowflake.com/en/user-guide/warehouses.html) within snowflake.

> [@pudnik26354](#):
>
> put ACCOUNTADMIN in the role textbox

You can, but I would use a different role. See [here](https://www.getdbt.com/blog/how-we-configure-snowflake/) and [here](https://discourse.getdbt.com/t/setting-up-snowflake-the-exact-grant-statements-we-run/439)

---

<div class="post-metadata">

**Author:** ![pudnik26354](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/pudnik26354/32/1421_2.png) [@pudnik26354](https://discourse.getdbt.com/u/pudnik26354)\
**Post date:** [December 9, 2022, 1:19am UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504/3 "2022-12-09T01:19:04Z")

</div>

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?

Thanx for your help,

John

---

<div class="post-metadata">

**Author:** ![jeffsk](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/jeffsk/32/1250_2.png) [@jeffsk](https://discourse.getdbt.com/u/jeffsk)\
**Post date:** [December 9, 2022, 6:24pm UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504/4 "2022-12-09T18:24:46Z")

</div>

The first Warehouse text box should be greyed out since you have already selected “Snowflake” in step 1.

Let’s try with some screenshots:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/2X/0/04c082da90dc2db09446034928e126850aaabbd5.png)

Then…

 ![image](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/2X/d/d496dc2c85ce6f878c5bd6882e98159f6264f1d7.png)

---

<div class="post-metadata">

**Author:** ![pudnik26354](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/pudnik26354/32/1421_2.png) [@pudnik26354](https://discourse.getdbt.com/u/pudnik26354)\
**Post date:** [December 10, 2022, 9:12pm UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504/5 "2022-12-10T21:12:05Z")

</div>

…I think it worked! so now I just need a sample dbt script/model that will run a simple query on the default sample Snowflake database…

---

<div class="post-metadata">

**Author:** ![obar1](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/obar1/32/1221_2.png) [@obar1](https://discourse.getdbt.com/u/obar1)\
**Post date:** [December 11, 2022, 8:20am UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504/6 "2022-12-11T08:20:24Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/1X/a7a7ca1fe379aaf90952b0e13118a817babcd14f.png) [@system](https://discourse.getdbt.com/u/system)\
**Post date:** [December 18, 2022, 8:20am UTC](https://discourse.getdbt.com/t/completing-the-project-wizard/5504/7 "2022-12-18T08:20:36Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.