October 16, 2019

|

by: Travis Brannan

|

Categories: Code, Data, Redshift

The easy way Before I learned how to load only the columns I needed from DynamoDB into Redshift, I created an entire glue job to load a single table. I’d like to prevent you from making the same mistake. But to understand how much easier the easy way is, you will first need to understand how [...]

October 10, 2019

|

by: Kristi Smith

|

Categories: Analytics, Looker

Matches (Advanced) Filters I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive, once you get the hang of the syntax. As always, if you run into an issue or need more context, Looker’s documentation is a great place to start. Advanced filters allow you to specify an expression for [...]

October 7, 2019

|

by: Renee Miller

|

Categories: Events, Looker

Looker is at it again, bringing together the best data enthusiasts on the planet. Since we had such an absurdly enjoyable time at last year’s JOIN (read about it in our blog here), we were hyped for pre-conference celebration. Consider this our tailgating. Mike Jelen, representing Red Pill Analytics at Looker JOIN 18, takes home [...]

September 5, 2019

|

by: Renee Miller

|

Categories: Events, Red Pill Analytics

Let's Talk Oracle OpenWorld 2019…But first Before we get into OpenWorld, we have some exciting (actually… groundbreaking) news to share. Stewart Bryson, Red Pill’s CEO and Founder, was announced as a recipient of the Oracle Groundbreaker Ambassador Award. Now, what does that mean, exactly? Individuals are nominated based on their impact on the developer community [...]

August 7, 2019

|

by: Stewart Bryson

|

Categories: Analytics, Confluent, Gradle, Kafka, KSQL

This blog, Deploying Kafka Streams and KSQL with Gradle – Part 3: KSQL User-Defined Functions and Kafka Streams was originally posted on the Confluent Blog on July 10, 2019. See the original source here. Building off part 1 where we discussed an event streaming architecture that we implemented for a customer using Apache Kafka, KSQL, and Kafka Streams, and part 2 where we discussed how [...]

August 7, 2019

|

by: Stewart Bryson

|

Categories: Analytics, Data, Gradle, Kafka

This blog, Deploying Kafka Streams and KSQL with Gradle – Part 2: Managing KSQL Implementations, was originally posted on the Confluent Blog on May 29, 2019. See the original source here. In part 1, we discussed an event streaming architecture that we implemented for a customer using Apache Kafka®, KSQL from Confluent, and Kafka Streams. Now [...]

August 7, 2019

|

by: Stewart Bryson

|

Categories: Analytics, Gradle, Kafka

This blog, Deploying Kafka Streams and KSQL with Gradle – Part 1: Overview and Motivation, was originally posted on the Confluent Blog on May 15, 2019. See the original source here. Red Pill Analytics was recently engaged by a Fortune 500 e-commerce and wholesale company that is transforming the way they manage inventory. Traditionally, this [...]

June 19, 2019

|

by: Lauren Prezby

|

Categories: Analytics, Events, Oracle, Red Pill News

It’s that time of the year again. Kscope19, one of the best Oracle User Group conferences of the year, is merely weeks away. If you’re only going to one conference this year, definitely take this one into consideration. Why Kscope? If you are heading to Kscope, you're probably already an Oracle aficionado. This is where [...]

June 12, 2019

|

by: Mike Fuller

|

Categories: Analytics, Fivetran

  By offering an impressive and ever-growing library of connectors, Fivetran has become a leading choice for extracting data from source applications and loading it in a cloud data warehouse. With reusability as a primary requirement, Fivetran has taken on the challenge of building out source system connectivity and established a core pattern of applying […]