Get Started

RPA Blog

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

Abstract geometric pattern symbolizing query profile changes in Snowflake. Detect query profile changes easily with Prismafy for better SQL query optimization.

How to Detect Query Profile Changes in Snowflake: Quick & Easy Method

By Deiby Gómez  In this article, we’ll explore how to quickly detect when Snowflake changes the way it executes your SQL statements. We’ll use the Prismafy tool for Snowflake, which generates detailed reports, allowing you to identify within minutes when a query profile changes. Prismafy is a free, open-source tool that supports external authentication, including […]

How to Detect Query Profile Changes in Snowflake: Quick & Easy Method Read More »

Databases, Snowflake, SQL
A sleek, modern image showcasing a geometric prism illuminated by blue and red light, representing the precision and efficiency of data warehousing platforms like Snowflake. This visual highlights the importance of optimizing query performance, an essential step for consultants using tools such as Prismafy to diagnose and resolve performance bottlenecks.

The Definitive Guide to Analyzing Queries in Snowflake

By Deiby Gómez Snowflake is a top choice for data warehousing and cloud analytics, thanks to its exceptional scalability and performance. However, like any complex system, it isn’t immune to challenges. Performance issues, such as slow queries or overloaded warehouses, can disrupt data operations. The key to maintaining optimal performance is addressing these issues quickly.

The Definitive Guide to Analyzing Queries in Snowflake Read More »

Data Warehousing, Prismafy, Snowflake, SQL, Uncategorized
eamwork in data project management, like rowers in sync, is crucial for success. Discover strategies to keep your data projects on track.

7 Key Strategies I Learned from 5 Years in Data Project Management

By Kristi Smith Effective data project management is key to the success of any data project. Over the past five years of managing these projects at Red Pill Analytics, I’ve learned that having the right strategies in place makes all the difference. Here’s what I’ve found works best: 1. Define Clear Objectives Start with a

7 Key Strategies I Learned from 5 Years in Data Project Management Read More »

Data Analytics, Elastic Delivery, project management, Team Collaboration
Person walking through a labyrinth, symbolizing the complexity of solving the dbt row_count package bug

Behind the Error Message: Solving row_count package bug in dbt

By Tatum Brannan Photo by Photo by Ashley Batz on Unsplash Exploring dbt Test Features Struggling with the dbt row_count package bug? Follow our step-by-step guide to quickly resolve the issue and keep your data pipeline running smoothly. dbt provides a variety of intrinsic testing options. Among these, you’ll find fundamental tests like unique, not_null, accepted_values, and

Behind the Error Message: Solving row_count package bug in dbt Read More »

Data Engineering, dbt
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
Scroll to Top