BLOG MASONRY

OAC – A Better Way to Unsubscribe from Agents

OAC – A Better Way to Unsubscribe from Agents

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

Comparing Snowflake, Redshift, and BigQuery

Comparing Snowflake, Redshift, and BigQuery

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

Building a Data Lake and Data Warehouse in AWS

Building a Data Lake and Data Warehouse in AWS

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

Coming from your Friendly Neighborhood Snowflake Data Hero

Coming from your Friendly Neighborhood Snowflake Data Hero

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

Dynamic Looker Visualization based on Dimensional Hierarchies

Dynamic Looker Visualization based on Dimensional Hierarchies

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

Bored in Quarantine? Our Events are now Free Webinars!

Bored in Quarantine? Our Events are now Free Webinars!

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

Oracle Analytics Desktop Doesn’t Connect To Snowflake?!?!

Oracle Analytics Desktop Doesn’t Connect To Snowflake?!?!

I recently downloaded Oracle Analytics Desktop (OAD)12.2.5.4 to check in on what's new. The last time I used Oracle's desktop tool, it was called Data Visualization Desktop; I figured they must have made some updates over the last few years. I was not terribly impressed with the original application (at least early versions of it), [...]

March 10, 2020

How DBT was used to convert from Google BigQuery Scheduled Queries

How DBT was used to convert from Google BigQuery Scheduled Queries

Google BigQuery has neat functionality that allows users to schedule queries in standard SQL, DDL or DML statements. Additionally, you can set them to run on a recurring basis. This can be great for light transformations; however, if more comprehensive transformation and automated regression testing is needed dbt (data build tool) is an affordable solution. [...]

March 4, 2020

How To Dynamically Format Selected Measures via Liquid Parameters in Looker

How To Dynamically Format Selected Measures via Liquid Parameters in Looker

Looker gives users the ability to swap between dimensions or measures in a visualization by the use of Liquid Parameters. To learn more, explore Looker’s documentation on Liquid Parameters here.  Currently, when a user selects measure from the parameter filter, it does not pass through the value format given for that measurement. In the following [...]

February 11, 2020

1Page 2 of 17345»