Get Started

RPA Blog

Dive into the world of data analytics with expert insights and practical guides.

The reflection of the sky in the image of a glass building

Master dbt Testing: How to Avoid False Negatives when Testing Between Project Layers

We have a small project with four layers:   1. Raw — incoming raw data2. Validation —Relationship and data validations. Transformations into facts and dims3. Reporting — joining facts and dims to meet presentation requirements4. Business Application — presentation layer. Views, with security where needed, of the reporting objects When we added relationship tests between project […]

Master dbt Testing: How to Avoid False Negatives when Testing Between Project Layers Read More »

Business Intelligence, Data Engineering, dbt

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 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
A close up photograph of a mix of blue paint colors blends together.

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

OAC Extending Dimensional Attributes by Blending Data Read More »

Business Intelligence, Cloud Solutions, Data Analytics

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

Snowflake Data Warehouse and AWS Lambda Read More »

AWS, Cloud Computing, Data Integration, Serverless Architecture, Snowflake, Snowflake Computing
An abstract image of hexagonal purple and blue gradient

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

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

Business Intelligence, Code, Data, OBIEE, Software Testing, Technical Tutorials
Abstract image of lasers criss-crossing above internal computer hardware.

Securing Network Access for Snowflake Data Warehouse and Amazon S3

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
Scroll to Top