dbt is a well-known data building tool that allows you to approach analytics more like playing with LEGO blocks and less like pulling teeth. However, even with dbt, there...
In today’s data-driven world, securely sharing data with external partners can enhance collaboration and value creation. At the same time, managing these data exchanges must be scalable and secure....
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 vergemakkelijken je werk
Je hebt je ruwe data in je database, maar nu wil je die gaan bewerken. In dbt wordt deze ruwe data ook wel ‘Source(s)’ genoemd. Een source is als...