Creating your first project in data build tool (dbt) | Tutorial for beginners

❄️Want to SUPERCHARGE your career and become an EXPERT in Snowflake??❄️
Mastering Snowflake is accepting applications now to work with us in a small group. Serious inquiries only pls.

In our next video in the series we look at creating our first project in data build tool (dbt) on Snowflake.

We start by taking a standard bit of SQL code which generates the data for a customer dimension.

We bring this into dbt, and cover several key concepts such as materialisation, modularity and ref functions, creating documentation and viewing lineage diagrams.

For the SQL code used in the demo, head here:

For the modularity and ref functions code, head here:

In this series I'll be producing a series of short videos which are based are dbt's excellent, free training modules found here:

❄️Order my book: Mastering Snowflake Solutions HERE: ❄️

❄️Get my Free SnowPro core guide HERE: ❄️

❄️Become a student on my course: ❄️

❄️Connect with me on Linkedin:❄️

Contents:
00:00 - Models in dbt
01:06 - Preparing the data
02:00 - The initial SQL query
03:30 - Creating the dim_customer model
06:40 - Materializing data in dbt
07:47 - The -m switch
08:50 - Introducing modularity
12:00 - The ref function
14:40 - Generating documentation
15:15 - Data lineage

[Gayatrimva]

perfect Dbt videos in the youtube ever, very clearly explained Awesome videos thanks you very much for the Videos

[rahulsadawarte]

Thank you so much for this video. Very well explained.

[dataarq]

Hey Adam, I am waiting for the video about deployment of multiple models. Thanks again!!

[mvprasad]

Thanks for detailed video. Can you explain how did you PC_DBT_DB database in your snowflake; which was not there at the time of finishing the configuration.

Thanks in advance!

[JasonZhang-sejo]

Hey Adam, Awesome video and instruction, could you help to advise, when you are doing the modular sql statements. it is mandatory to do the 2 steps ( CTE of the with clause, select * from the CTE"). I assume it is because dbt only grab the return pf the sql statements. the select statement will contribute the return of the table, while CTE will not return a table

[dmy]

Great video! I assume (when you've selected option TABLE and not VIEW), the table is truncated first? Does dbt allow you to change this option?

[dishitachoudhary]

Can anyone provide the SQL queries, the link is not properly opening for me.

[arvindroy]

Awesome, Thanks a lot!
Is there any your course (DBT + Snowflake end to end) available in udemy?
please let me know.👍

[JasonZhang-sejo]

I am sorry that I just want to ask another question. In the second part of the video, you use the " ref" function to refer to the 2 tables in individual sql. you use the CTE first, I am just wondering that is it possible to save the CTE and use the "ref " directly in the main query

[NASHA]

if someone is not getting the output in dbt and it shows no data to show, change the warehouse to transforming from transformed

[priyankapawar]

Hey Adam, Thanks for making this video. I tried doing the handson as per your videos but I am not able to run the first model itself(dim_customer ) as if keeps giving me issue in connecting to snowflake. I am getting this error - "Database Error in rpc request (from remote system.sql) 002003 (02000): SQL compilation error: Database 'RAW' does not exist or not authorized."

I have also added the IP addresses in firewall settings but it is still giving me this error. Please note I created all objects in snowflake using sysadmin role and also granted all access as per dbt quick start guide. Also, while setting up dbt project and snowflake connection, I tested connection and it was successful.
Can you guide me how to resolve this error? Many thanks.

[my_name_is_raj]

Hi...
where i can get these .csv file @Adam Morton

[olicairns]

Nice video, why not write more concice staging queries like this

select
colA,
colB
from schema.table

rather than

with myTable as (
select
colA,
colB
from from schema.table
)
select * from myTable