Blog Masonry

Spring Events with Red Pill Analytics

The sun is shining, and the data-driven community is coming out of hibernation to gather across the country. Check out where Red Pill Analytics will be in the coming months, and let us know if you will be attending. We’d love to connect in person! Kafka Summit 2019: April 2, 2019 New York, NY The [...]

April 1, 2019

Data Collecting for Snowflake

How to use the Snowflake Data Warehouse destination in StreamSets Data Collector to replicate an OLTP database StreamSets Data Collector offers incredible flexibility while creating data integration pipelines by allowing developers to either create a custom stage (an origin, processor, executor, or destination) completely from scratch, tailor a universal stage to a specific requirement, or use [...]

January 24, 2019

Managing Snowflake Data Warehouse Compute in Looker

In a recent blog titled Managing Snowflake Data Warehouse Compute in OBIEE, I explained how to assign application users and roles to use designated compute clusters (warehouses) in Snowflake. The idea of specifying a Snowflake warehouse on a per user (or groups of users) basis is not specific to OBIEE and can be achieved with [...]

December 19, 2018

Managing Snowflake Data Warehouse Compute in OBIEE

How to dynamically set a Snowflake virtual warehouse Congratulations! You just configured Oracle Business Intelligence Enterprise Edition (OBIEE) to connect to your freshly loaded Snowflake Data Warehouseinstance and you’re feeling pretty good. Maybe your OBIEE dashboards are finally meeting SLAs, you’re not sitting with a DBA trying to tune SQL statements, your data is finally all in one [...]

December 10, 2018

OAC Extending Dimensional Attributes by Blending Data

Blending Data in Oracle Analytics Cloud allows us to share additional dimensions or measures from one data set with those from another, without having to do complicated metadata modeling using RPD functionality. This is a great feature for user-sourced categorizations and can empower users to utilize Data Visualization instead of forcing them to export into […]

December 3, 2018

Hungry for a Day — Giving back at Thanksgiving

With Thanksgiving sneaking up on us, we’d like to share a charity befitting the turkey season, Hungry for a Day. H4AD was co-founded by one of Red Pill’s own, David Huey. Watch David’s short video on the program and the families they have helped: H4AD began seven years ago with the idea that life was [...]

November 14, 2018

Snowflake Data Warehouse and AWS Lambda

Serverless computing is here to stay, and while the term “serverless” is a bit of a misnomer, the concept offers many benefits. Most notably, serverless computing allows developers to focus on writing code and not concern themselves with provisioning, configuring, or maintaining servers. One such example of serverless computing is AWS Lambda. Although there are [...]

November 12, 2018

Looker Join 2018

As a vendor, it’s rare to leave a conference feeling totally energized and fulfilled; thankfully, Looker Join broke the mold for Red Pill Analytics. Spoiler alert: we’ll definitely be going back next year. Mike Jelen addressing the @LookerData Partner Summit on how @RedPillA provides Real-TimeBusiness Analytics to customers. The week kicked off at the Partner [...]

October 30, 2018

Teaching Girls to Code at U Girls Code — Year 2

October 27, 2017 was our second annual U Girls Code event at University of Utah. The idea for this event came from Tyra Crockett, from Oracle Academy, and I. We convinced University of Utah’s TEK Club to host the event as it is good exposure for their program to have the girls in a university [...]

October 4, 2018

Using Oracle’s Baseline Validation Tool with OBIEE — Part 4

This post is part 4 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). The previous posts are: Post 1: An intro to BVT Post 2: Setting up BVT Post 3: Running the Tests Interpreting the BVT Results As described in my third post in this series, here’s how to […]

June 29, 2018