How to structure your 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.
forms.gle/WBqa...
In our next video in this dbt series we look at re-organising our project in data build tool (dbt) on Snowflake.
We create folders for our staging and mart models before moving our configuration blocks into our project yml file. This allows us to apply configurations at a folder level to all models within it.
Additionally, we bring in another staging table from a new schema in Snowflake before adding a fact table to our project. This sets us up for our next lesson.
In this series I'll be producing a series of short videos which are based are dbt's excellent, free training modules found here:
courses.getdbt...
❄️Order my book: Mastering Snowflake Solutions HERE: ❄️
Amazon UK - www.amazon.co....
Amazon US - www.amazon.com...
Amazon AUS - www.amazon.com...
Amazon IND - www.amazon.in/...
stg_payment code:
with payments as (
select
id as payment_id,
orderid,
paymentmethod,
status,
amount,
created
from raw.stripe.payment
)
select * from payments
fct_orders code:
with orders as (
select * from {{ ref('stg_orders')}}
),
payments as (
select * from {{ ref('stg_payment')}}
),
fct_orders as (
select order_id,
payment_id,
amount
from orders o
left join payments p on o.order_id = p.orderid
)
select * from fct_orders
❄️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. Book a call with us here:
apply.masterin...
❄️Get my Free SnowPro core guide HERE: ❄️
program.master...
❄️Become a student on my course: ❄️
Snowflake Practice Questions - SnowPro Core Certified Udemy Course www.udemy.com/...
❄️Connect with me on Linkedin:❄️
/ adammorton121

[@dataarq945]

Thanks Adam !

[@ranju184]

awesome 🙂

[@masoudghodrati3770]

awesome vid, thanks! seems you're not committing quite frequently ;)

[@knowtechwithaman7254]

what to do if in an environment, I am not able to see "models" folder only. How to create it

[@martindominikus8825]

Hi Adam, good video! I have a little question, at 5:18, why "staging" and "core" are in the same level? Does staging need to be in the same level as "marts" instead?

[@mastering_snowflake]

Great question! Yes, I would say staging and marts would work well at the same level. This link also provides some useful guidance docs.getdbt.com/guides/best-practices/how-we-structure/1-guide-overview

[@rodrigoschammass5205]

Hi Adam. Could you please share the tables scripts ? thanks in advance

[@mastering_snowflake]

If you join the mastering snowflake program you get access to all my scripts and a lot more!