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!
Sure, if you invoke your dbt trial via Snowflake's partner connect portal then it will automatically create a role, warehouse and database for you. The default name of this database is PC_DBT_DB, although it is possible to change it as part of the setup. Hope this helps
Thank you! In this case it does yes. You can control the behaviour depending on the your use case, check out my video on advanced materialisation in dbt for more info!
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
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
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.
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
perfect Dbt videos in the youtube ever ,very clearly explained Awesome videos thanks you very much for the Videos
Glad you like them!
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!
Sure, if you invoke your dbt trial via Snowflake's partner connect portal then it will automatically create a role, warehouse and database for you. The default name of this database is PC_DBT_DB, although it is possible to change it as part of the setup.
Hope this helps
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?
Thank you! In this case it does yes. You can control the behaviour depending on the your use case, check out my video on advanced materialisation in dbt for more info!
Can anyone provide the SQL queries, the link is not properly opening for me.
Awesome, Thanks a lot!
Is there any your course (DBT + Snowflake end to end) available in udemy?
please let me know.👍
We're working on a Intro to dbt with Snowflake course. Available in May 2024!
@@mastering_snowflake Thanks for the info.👍
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
Yep this is correct. You need to select some data as this is what dbt will use to populate the target object
Thank you so much for this video. Very well explained.
Hey Adam, I am waiting for the video about deployment of multiple models. Thanks again!!
I’ll add it to the list cheers!
You can get it for free at courses.getdbt.com/collections. He is just copying the content from the videos..!!
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
Any valid sql should work just fine without the cte.
Awesome, Thanks a ton!
Hi...
where i can get these .csv file @Adam Morton
Does DBT support Materialised Views?
Great question!
This should help explain stackoverflow.com/questions/64489772/materialized-view-vs-table-using-dbt/64490072#64490072
if someone is not getting the output in dbt and it shows no data to show, change the warehouse to transforming from transformed
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.
please speak loudly
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