Homepage
Open in app
Sign in
Get started
Red Pill Analytics
Red Pill Analytics is a unique Analytics and Business Intelligence Delivery firm, combining the best elements of cloud, Agile development, continuous integration, as-a-service, and outsourcing into a service called Capacity Analytics.
Analytics/BI
Code
Cloud
Data
News
Archive
Red Pill Analytics
Follow
Following
Clear the clutter! Find + drop undead dbt-created tables
Clear the clutter! Find + drop undead dbt-created tables
Use a macro to automatically drop objects from dbt managed schemas that are not associated with a dbt model, seed or snapshot
Aly K
Jan 2
Processing Fixed Width Data Using dbt
Processing Fixed Width Data Using dbt
Sometimes you’re stuck loading a fixed width file into your warehouse. We’ll use a dbt macro and seed to make processing the data easy…
Aly K
Nov 3, 2023
Behind the Error Message
Behind the Error Message
Solving row_count package bug in dbt
Tatum Brannan
Sep 28, 2023
Data Monitoring: using dbt and SnowFlake’s time-travel to track your KPIs
Data Monitoring: using dbt and SnowFlake’s time-travel to track your KPIs
Analysts, Data Engineers and all data crew are always eager to offer the best set of analytical tools, qualified data, a good performance…
André Deroide
Jun 21, 2023
dbt tests: Solving false test failures from greedy selection with Tags.
dbt tests: Solving false test failures from greedy selection with Tags.
We have a small project with 4 layers: 1. Raw — incoming raw data 2. Validation —Relationship and data validations. Transformations into…
Aly K
May 1, 2023
Detecting Data Anomalies via an Inspection Layer using dbt Core
Detecting Data Anomalies via an Inspection Layer using dbt Core
At Red Pill Analytics we are enthusiastic about working with data and we routinely recommend dbt as a transformation tool of choice. We had…
John Rensberger
Nov 28, 2022
Snowpark
Snowpark
Main features and its support for Python
Gabriel Lobão Barroso de Souza
Aug 17, 2022
I Didn’t Come Here to Tell You How This is Going to End
I Didn’t Come Here to Tell You How This is Going to End
I Came Here to Tell You How it’s Going to Begin
Stewart Bryson
Feb 4, 2022
Obiee
Managing Snowflake Data Warehouse Compute in OBIEE
Managing Snowflake Data Warehouse Compute in OBIEE
How to dynamically set a Snowflake virtual warehouse
Mike Fuller
Dec 10, 2018
Using Oracle’s Baseline Validation Tool with OBIEE — Part 4
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:
Michelle Hardwick
Jun 29, 2018
Using Oracle’s Baseline Validation Tool with OBIEE — Part 1
Using Oracle’s Baseline Validation Tool with OBIEE — Part 1
This post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE).
Michelle Hardwick
Oct 19, 2017
Checkmate for OBI is Now Free
Checkmate for OBI is Now Free
For those of you in the Oracle Business Intelligence space, you have likely heard us or some one else talk about Checkmate in the past. We…
Stewart Bryson
Aug 1, 2017
Finding an Open Slip
Finding an Open Slip
Changing Ports in OBIEE 12c
Phil Goerdt
Mar 22, 2017
Which Version Was It Again?
Which Version Was It Again?
Finding Your OBIEE Version
Phil Goerdt
Mar 7, 2017
Bring the Noise
Bring the Noise
Using Outlier Detection in OBIEE 12c
Phil Goerdt
Jan 11, 2017
About Red Pill Analytics
Latest Stories
Archive
About Medium
Terms
Privacy
Teams