Red Pill Analytics, Author at Red Pill Analytics

How to Connect to Oracle Database from an AWS Lambda using Thin mode

By Deiby Gómez After exploring How to Connect to Oracle Database using AWS Lambda in Thick Mode, we now move on to Thin Mode. With so many companies using AWS as their Cloud Provider, AWS Lambda is a popular solution to process Serverless Code. This guide was written to help people that need to work […]

How to Connect to Oracle Database from an AWS Lambda using Thin mode Read More »

AWS, Cloud Computing, Data Integration, Databases, Oracle, Technical Tutorials

Abstract image of floating numbers symbolizing data connectivity between AWS Lambda and Oracle Database

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode

By Deiby Gómez Many companies use AWS as their Cloud Provider to implement solutions, and AWS Lambda is a popular choice for processing Serverless Code. In a world where data is king, it’s common to need to pull or push from Oracle Databases. For that reason, I wrote this guide to help anyone that needs

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode Read More »

Cloud Solutions, Data Integration, Databases, Oracle, Oracle Technology Network, Technical Tutorials

Architectural blueprint and project planning tools for data project specifications, featuring measuring tapes, levels, and drafting equipment on a vibrant orange workspace.

Mastering Data Project Specifications: A Strategic Guide

by André Deroide Data projects are helping organizations gain insights, drive efficiency, and keep a competitive edge in the age of big data. However, the complexity inherent in these projects can easily lead to misunderstanding, delays, misaligned outcomes, and unexpected results. Data Project Specifications serve as a critical roadmap to avoid these pitfalls. This guide

Mastering Data Project Specifications: A Strategic Guide Read More »

project management, Red Pill Analytics Tips, Team Collaboration

Hand holding a rolled-up 20-dollar bill, symbolizing cost management in Snowflake credit consumption

How to Analyze Snowflake Credit Consumption for Cost Management

By Deiby Gómez Cloud-based data warehousing platforms like Snowflake have changed the way organizations store, manage, and analyze their data. But with this power and flexibility comes the challenge of managing costs, especially when it comes to Snowflake credit consumption. Snowflake’s pricing model can lead to unexpected expenses if credit usage is not monitored and

How to Analyze Snowflake Credit Consumption for Cost Management Read More »

Cloud Computing, Cost Management, Data Warehousing, Snowflake

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste

By Deiby Gómez In this article, we’ll explore how to analyze the load and usage of a Snowflake warehouse to uncover opportunities for reducing credit waste and identifying overloaded warehouses. We’ll use the Prismafy tool, which generates detailed reports in just a few minutes. Prismafy is free to use and supports external authentication, including username/password

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste Read More »

Data Analytics, Data Warehousing, Snowflake, Snowflake Computing

Turquoise 3D Snowflake icon on a black background, illustrating how to identify Snowflake ACCOUNTADMIN privileges using Prismafy.

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake

By Deiby Gómez Wondering how to quickly identify Snowflake ACCOUNTADMIN privileges and the users or roles that hold them? This article will show you how to easily identify them using Prismafy, a free tool that generates detailed reports in just a few minutes. Prismafy supports external authentication, usernames and passwords, and MFA, making it secure

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake Read More »

Databases, Security, Snowflake

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