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 […]

January 24, 2019

|

by: Mike Fuller

|

Categories: Data, Snowflake, Snowflake Computing, StreamSets, Uncategorized

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 [...]

December 10, 2018

|

by: Mike Fuller

|

Categories: Analytics, Data, OBIEE, Snowflake

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 [...]

November 12, 2018

|

by: Mike Fuller

|

Categories: AWS, Snowflake, Snowflake Computing

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 [...]

January 6, 2018

|

by: Mike Fuller

|

Categories: Cloud, Cloud Computing, Red Pill News

Written by: Phil Goerdt and Mike Fuller Several years ago, I was working on an enterprise reporting project at a Fortune 15 company at about the same time that cloud-based services were really starting to catch on. During one of our meetings, a colleague of mine on the client side asked me to “explain what […]

November 27, 2017

|

by: Mike Fuller

|

Categories: Data, Git, Looker, Version Control

If you follow Red Pill Analytics at all, you know that we have our hands in a bit of everything when it comes to data and analytics; having the opportunity to work with various tools and technologies is one of the many benefits to working at RPA. One particular tool that we have found ourselves […]

November 17, 2017

|

by: Mike Fuller

|

Categories: AWS, Data, Snowflake Computing

Whether it’s an enterprise application, the automobile you drive, or your favorite tea kettle, seemingly everything in the world today produces data. This results in a need to transfer data to a place where people and technology can make sense of it. Typically, the faster data can be transferred and more data that can be […]

October 11, 2017

|

by: Mike Fuller

|

Categories: Red Pill Analytics' Tips, Snowflake, Tips

Snowflake Data Warehouse release 2.11 (September 7, 2017) included the addition of an OVERWRITE parameter for the INSERT command. INSERT OVERWRITE effectively consolidates two commands, TRUNCATE TABLE and INSERT, into one. INSERT OVERWRITE also deletes the file load history and retains access control privileges on the target table; both of which are not insignificant details. […]