by Alyssa Kunau Photo by todd kent on Unsplash Clutter- What is it? Where did it come from? In this guide, I’ll show you how to find and drop undead DBT-created tables to clear clutter. By “db clutter” I mean unnecessary, unused objects living in your database. There’s gonna be some word clutter here. In this post I’m […]
Clear the Clutter! Find and Drop Undead dbt-Created Tables Read More »
data cleaning, Databases, dbt
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
Managing Snowflake Data Warehouse Compute in Looker Read More »
Business Intelligence, Cloud Computing, Data Warehousing
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 Warehouse instance 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
Managing Snowflake Data Warehouse Compute in OBIEE Read More »
Business Intelligence, Cloud Computing, Data Warehousing, Looker, Snowflake
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
OAC Extending Dimensional Attributes by Blending Data Read More »
Business Intelligence, Cloud Solutions, Data Analytics
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
Snowflake Data Warehouse and AWS Lambda Read More »
AWS, Cloud Computing, Data Integration, Serverless Architecture, Snowflake, Snowflake Computing
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
Teaching Girls to Code at U Girls Code — Year 2 Read More »
Coding, Events, Oracle, Women In Tech, workshops
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
Using Oracle’s Baseline Validation Tool with OBIEE — Part 4 Read More »
Business Intelligence, Code, Data, OBIEE, Software Testing, Technical TutorialsODTUG Kscope has two new reasons for being the best conference in the Oracle community. This year, Red Pill Analytics Co-founder and CEO Stewart Bryson was recognized for his accomplishments twice — with the Innovation Award, and the Best Speaker Award in the Big Data & Data Warehousing Track. These kudos added to a week
Stewart Bryson for the Win Read More »
Analytics, awards, Industry Events, ODTUG, Oracle Development, Red Pill News
Do your summer plans include Orlando and Kscope18? Ours do! We are excited to be part of the amazing lineup at the Swan and Dolphin in Orlando, FL on June 10–14. We know it’s tough to decide which sessions to attend but make sure to add these Red Pill Analytics’ sessions to your schedule builder. Let
Summertime and The Presenting is Easy Read More »
Analytics, Cloud Computing, Events, Oracle Development, Red Pill News
As technology moves further into a service-oriented (read: Cloud) world, people and enterprises alike need to ensure that securing their assets is taken seriously. Security has always been one of the first of topics covered before purchasing a cloud service which is why good cloud vendors typically spend more time securing their products than any
Securing Network Access for Snowflake Data Warehouse and Amazon S3 Read More »
AWS, Code, Data Integration, Data Warehousing, Security, Snowflake