dbt Mach Speed: Getting Started Demo
3 mins
A fun experiment in how fast it is to get started with dbt + duckdb!
View Comments and ReplyTranscript
Show Transcript
Hey folks, this is song Speaking here and I'm about to show you how to get started with D B T in less than a minute.
So step one, I'm already navigated to, uh, the get repo for this, but instead of coding it manually, copying, pasting things, what, three or four times instead, I'm gonna go straight down here, copy and paste this and my terminal, and let's see what happens from there.
Step by step, I'll explain what each of these commands are doing. So I'm cleaning my repo. I am navigating to the directory.
Where my get repo is I'm creating a virtual environment. I'm activating it. I'm upgrading PIP just to make sure that there are no kind of like pip kind of, uh, old version conflicts.
Here I'm installing everything in the requirements folder, which includes duct DB and also, uh, DBT core. I'm running and testing everything.
I am generating the dogs and I'm serving them within the browser. And then once I see the browser, I know everything has worked successfully.
Okay, These PIP cells are taking longer than I thought. I hope I still get under a minute. And shaza, I got, sorry, with D B T less than a minute.
Now, the next thing you're probably wondering, like, what if this is all smoke and mirrors song and you just generate a script that prints out pretty logs?
Well, that's where we have this single liner where we query the duct DB database directly to actually get a row of data that's meaningful to us.
So we know for a fact that this d built command created a table that I could query from You also, notice here, this is all single threaded, And we still ran all of these operations, 28 operations and 1.64 seconds.
Now, that's pretty darn impressive in my book, so I hope Next's time, you think about how hard it is to get started with D B T, whether it's for you or for someone around you, you get to say, Listen, in less than a minute, copy and paste this.
Move on with your life. All right? That's it. See ya.
Transcript
Show Transcript
Hey folks, this is song Speaking here and I'm about to show you how to get started with D B T in less than a minute.
So step one, I'm already navigated to, uh, the get repo for this, but instead of coding it manually, copying, pasting things, what, three or four times instead, I'm gonna go straight down here, copy and paste this and my terminal, and let's see what happens from there.
Step by step, I'll explain what each of these commands are doing. So I'm cleaning my repo. I am navigating to the directory.
Where my get repo is I'm creating a virtual environment. I'm activating it. I'm upgrading PIP just to make sure that there are no kind of like pip kind of, uh, old version conflicts.
Here I'm installing everything in the requirements folder, which includes duct DB and also, uh, DBT core. I'm running and testing everything.
I am generating the dogs and I'm serving them within the browser. And then once I see the browser, I know everything has worked successfully.
Okay, These PIP cells are taking longer than I thought. I hope I still get under a minute. And shaza, I got, sorry, with D B T less than a minute.
Now, the next thing you're probably wondering, like, what if this is all smoke and mirrors song and you just generate a script that prints out pretty logs?
Well, that's where we have this single liner where we query the duct DB database directly to actually get a row of data that's meaningful to us.
So we know for a fact that this d built command created a table that I could query from You also, notice here, this is all single threaded, And we still ran all of these operations, 28 operations and 1.64 seconds.
Now, that's pretty darn impressive in my book, so I hope Next's time, you think about how hard it is to get started with D B T, whether it's for you or for someone around you, you get to say, Listen, in less than a minute, copy and paste this.
Move on with your life. All right? That's it. See ya.
More than 21 million people across 200,000 companies choose Loom
For Mac, Windows, iOS, and Android
My teammates and I love using Loom! It has saved us hundreds of hours by creating informative video tutorials instead of long emails or 1-on-1 trainings with customers.

Erica GoodellCustomer Success, Pearson
Loom creates an ongoing visual and audible experience across our business and enables our employees to feel part of a unified culture and company.

Tyson QuickCEO, Postclick
My new daily email habit. Begin writing an email. Get to the second paragraph and think 'what a time suck.' Record a Loom instead. Feel like π.

Kieran FlanaganVP of Marketing, HubSpot
Loom amplifies my communication with the team like nothing else has. It's a communication tool that should be in every executive's toolbox.

David OkuinevCo-CEO, Typeform
My teammates and I love using Loom! It has saved us hundreds of hours by creating informative video tutorials instead of long emails or 1-on-1 trainings with customers.

Erica GoodellCustomer Success, Pearson
Loom creates an ongoing visual and audible experience across our business and enables our employees to feel part of a unified culture and company.

Tyson QuickCEO, Postclick