BLOG MASONRY

We have a small project with four layers.  When we added relationship tests between project layers, we started getting false test failures. The raw layer is a bit like dbt’s stage layer, we do renaming and some very simple changes here and have validation for duplicates and nulls. The validation layer we build dims and […]

May 1, 2023

Anyone who has worked with dbt knows that one of the most powerful features is packages. Packages allow you to reuse code across multiple projects in an organization. Packages can be installed from other projects in your organization, or by using the dbt hub you can install packages from the open-source community and Fishtown Analytics. [...]

January 12, 2021

If there’s one thing we’re tired of this year, it’s canned marketing campaigns filled with false sentiment. We know what they really mean: “We’re in This Together”  Please continue to buy our stuff. "Now, more than ever.. " What we’re selling is still important. And the worst offender: “In these unprecedented times..” I will get [...]

December 15, 2020

OAC has a nice button for a person to unsubscribe within an Agent itself. But this required a person to navigate to the catalog to find the agent and look inside the details of the agent.  Seems like a lot of steps to me. But what if you want to enable this capability for an [...]

October 19, 2020

Are you considering a cloud-native data warehouse? Our experts debate the differences between Snowflake, Redshift, and BigQuery. Prefer to listen? Watch the Stump The Experts webinar on our Youtube channel. We are new to cloud data warehousing. We are considering Snowflake, Redshift, and BigQuery. What are some things to consider? Neal Achord Red Pill Consultant [...]

September 28, 2020