dbt data build tool date dimension example смотреть онлайн

link to materials:
https://www.skillfic.com/dbt-data-build-tool-course-installs

link to the coupon:
https://courses.skillfic.com/p/dbt-build-data-tool-online-course?coupon_code=DBTCOUPON30OFF

The second example of a hello world will be the dim date in data warehouses. We usually have a dimension of date. This dimension help us to filter everything that connects to date. For example, if it's a weekend or if it's a first day of the month quarter, we can create this demo dimension date with SQL.

The example I will give you here is I created a URL webpage. That will be the DBT DATA BUILT TOOL MATERIALIZE database tool, cost links to install also to install Python and installation of DBT DATA BUILT TOOL MATERIALIZE. Of course, I am using a example about the date dimension and the SQL for it is in this link. We have a website. If we go to a 10. Here at link and it just for help, because if you know, SQL, you can build this dimension by yourself also.

And what you can see here that he created a table called the date, and then after he created the tremor or the date, he actually created an insert into this table using a select. Every column here is that part of the select here that he did from 1970 and with a series and ed the sequence basically created a day dimension with all sorts of columns.

And so what I did you have in the materials and the secret itself, it will just copy it from here. And as you understand, from the first example, all we need, you know, that they mentioned, oh, another table and your table in our target is a select query with our results. You know, it's either the show disclaimer, before I'm going to the actual lecture.

I want it to say. This lecture is a part of an online course about DBT DATA BUILT TOOL MATERIALIZE, the course called learn to master DBT DATA BUILT TOOL MATERIALIZE that appealed to an online course. So if I will go now to the beaver and I will run the same sequence. I will have a table, as you can see here, I have the damn deem ID and the date key and the day of the week and here the quarter name, if it's the first and second and what is the year actual.

And of course, if it's a weekend, indicate all everything made by sequel. I will take this code. This is the secret code and I go to.

And in the models where you have the folder of the example, we will create a new file. We will call it the sequence. And here we'll just paste the code of the secret, the result of the select created table with the name, deemed date, save it. And now I will go to. Good bash under the project and I will do a DBT DATA BUILT TOOL MATERIALIZE.

And as you can see, we found four models. It was only three. And you can see here that the table model DW H DM date. Created, let's go to the beaver and the fresh, the DWH day bill. Yep. And we have the Dean date. If I click on it, I can see that they have a dimension for the date. In the second example of the Dean date, you start to understand that every select that we have with the outcome of columns.

Will you be created in the target? The DBT DATA BUILT TOOL MATERIALIZE will materialized it in our case now is a table. And in the next lesson, we will learn of other materialization that we can use. But for now, this is the second example of the lower world, and I will meet you in the next.