Je kijkt naar een dashboard en je ziet de kolom customer_address. Iets klopt niet met die kolom, maar je hebt geen enkele idee welke tabel het vandaan komt, en...
In the realm of data analytics and data warehousing, documentation is the unsung hero that guides data teams on their journey from raw data to actionable insights. It's not...
In today's fast-paced business environment, data is a critical asset that can make or break an organization's success. To get the most value out of data, companies need to...
When dbt creates table or a view in a database, it creates it as: {{ database }}.{{ schema }}.{{ identifier }}, e.g. analytics.finance.payments. Schema and database are defined in the profiles.yml...
Dynamic Data Masking is a Column-level Snowflake Security feature that uses masking policies to selectively mask data in table and view columns at query time. Currently, Snowflake supports Dynamic...
dbt packages facilitate your work
You have your raw data in your database, but now you want to edit it. In dbt, this raw data is also called "Source(s)". A source is like a...
Standard way to execute all dbt models In dbt, you can conceptually build and design your models as you wish, and then execute them as a final product....
Now that we have started looking deeper into dbt, we are coming across more and more toys that we are excited about. We are all used to the fact that a...