Using dbt And Snowflake To Develop And Deploy Analytics Code

Using dbt And Snowflake To Develop And Deploy Analytics Code | LAB

Рет қаралды 26,217

Жыл бұрын

dbt is a SQL-first transformation workflow that lets data teams quickly and collaboratively deploy analytics code following software engineering best practices such as modularity, portability, CI/CD, and documentation. It allows anyone on a data team to safely contribute to production-grade data pipelines. In this hands-on Quickstart workshop, Bobby Birstock and Hope Watson of dbt Labs guides participants through the process of building a fully functioning dbt project while making use of such best practices as data quality tests and code promotion between environments.
Follow along with the full Demo: developers.snowflake.com/demo...
To learn more about Snowflake, enroll in Snowflake's Coursera course: www.coursera.org/learn/snowfl...
Learn more about dbt Labs:
Website: www.getdbt.com
Twitter: @getdbt
LinkedIn: www.linkedin.com/company/dbtlabs
Connect with the presenters:
Bobby Birstock, Partner Engineer, dbt Labs
LinkedIn: www.linkedin.com/in/bobby-birstock
Hope Watson, Partner Engineer, dbt Labs
LinkedIn: www.linkedin.com/in/hopewatson
Learn how to build your application on Snowflake:
developers.snowflake.com
Continue the conversation by joining the Snowflake Community:
community.snowflake.com
❄Join our KZfaq community❄ bit.ly/3lzfeeB"

Пікірлер: 27

@aidankelly8409 Жыл бұрын

For anyone doing this project, when you create the dbt_project.yml file, you need to use the name model-paths instead of source-paths, source-paths is deprecated.

@mayabeaty324 Жыл бұрын

very nice and useful tutorial for the beginners.

@MrTeslaX 3 ай бұрын

With name like Hope Watson, I am 100% sure she is destined for greatness!

@sergiodiazdeleon7465 11 ай бұрын

Great job explaining the details in this project. I love it.

@snowflakedevelopers 11 ай бұрын

Glad you liked it!

@ramramaraju2221 10 ай бұрын

Great session

@user-co6dr4bu6r 7 ай бұрын

pretty well explained with step by steps mechanism, helping me to get on DBT test model so quickly.

@snowflakedevelopers 7 ай бұрын

Glad it was helpful!

@rohitagrawal769 8 ай бұрын

Very nice and informative!!!!

@snowflakedevelopers 8 ай бұрын

Glad it was helpful!

@rameshsiddharthareddy8304 7 ай бұрын

thank you so much, its really helpfull.

@snowflakedevelopers 7 ай бұрын

Glad it was helpful!

@JMrtnzNinja 5 ай бұрын

im a data boss now hell yeah

@damasberto1758 Жыл бұрын

Is it posible to create empty table on big query with yml file in dbt?

@tiya1745 24 күн бұрын

Hi @Hope & Team, please let me know the DBT Script you have used in this demo, from where we can get the file for practice?

@Ultimatebros202 Жыл бұрын

where is the copy of this document from where you are copying queries? Please share links to download

@maryam4071 4 ай бұрын

I am not sure why but I am not getting the same structure you shows in the video. i am only getting table as part of the file structure and i don't see any model in view. Do you know how can I solve it?

@nilkanthkakade9065 21 сағат бұрын

hooks i need to understand

@roberbonox 10 ай бұрын

Hi, how can i use streams already created in snowflake in DBT? i need to call them as tables in sources or what?? Thanks

@snowflakedevelopers 9 ай бұрын

This discussion on dbt's forums may be helpful: discourse.getdbt.com/t/snowflake-streams-with-dbt/8314/3

@sampyism 2 ай бұрын

I can't find partner connect under the "Admin" option in the left sidebar panel. The role I am using is "ACCOUNTADMIN". I have looked everywhere for it. What am I doing wrong?

@snowflakedevelopers 2 ай бұрын

The Snowsight UI was recently updated. Look under "Data Products" for "Partner Connect". I hope that helps!

@sampyism 2 ай бұрын

@@snowflakedevelopers Thank you!! That worked. :)

@sandraoriji8351 10 ай бұрын

I am seeing a different snowflake UI here.

@snowflakedevelopers 10 ай бұрын

Hi there! You might be on the Classic UI. The UI shown in the video is Snowflake Snowsight, which you can enable via your Snowflake Classic UI. Thanks for your comment!