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....
You're looking at a dashboard and you see the column customer_address. Something is not right with that column, but you have no idea which table it came from, and...
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...