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

Moving your data warehouse from on-prem to the cloud? Our experts discuss data lake and data warehouse building in AWS. Prefer to listen? Watch the Stump The Experts webinar on our Youtube channel. Our data warehouse is on-prem at the moment, but we are starting to evaluate moving it to the cloud. We are already [...]

July 29, 2020

Yeah. Yep. Big hero moment. (Captain Marvel 59:58) Good news is hard to come by these days, so it's nice when we have something to celebrate. The world, despite the doom, does go on. So when we got the news that Stewart Bryson (CEO of Red Pill Analytics) had been given the title of Data [...]

April 23, 2020

Here we have created a Dynamic Visualization based on the Dimensional Hierarchies of Country -> State -> City. When Country is selected in the Filter, the Visualization shows the States for the specified Country. When State is selected in the Filter, the Visualization shows the Cities for the specified State. Here is how it works. [...]

April 9, 2020

COVID-19 has created an anxiety-ridden week. With the chaos of preparing to quarantine over (hopefully), what’s next? If you’re looking for a way to be productive at home, we have an answer - we’ve taken our canceled and postponed live events and converted them to online educational opportunities. With a worldwide pandemic at our heels, [...]

March 26, 2020