How to Build your First Streamlit App in Snowflake

By Deiby Gómez
As Data Engineers, we focus on building robust data pipelines, optimizing queries, and ensuring data reliability at scale. With Streamlit now available in Snowflake, you can build and deploy interactive data apps directly inside your Snowflake environment. There’s no need to leave the platform or set [...]

Why Analytics Leaders Are Embracing Modern Data Platforms: A Look at dbt & Snowflake

by Kristi Smith
Are you an analytics leader thinking about moving to a more modern data platform, but not sure where to start? Makes sense; there are a lot of options out there. Red Pill Analytics understands that analytics leaders are facing a tough challenge: how to transform raw data into insights while managing complex

How to Create Dynamic Time-Based Tables in Snowflake

By Deiby Gómez
In data analysis and reporting, handling time-based data is crucial. Many workflows require the ability to generate and work with time sequences—such as creating calendar tables, tracking events at specific intervals, or managing detailed schedules. Snowflake, a cloud-based data warehousing platform, offers tools to handle these needs through its SQL capabilities. This

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

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

Bulk Loading Zone

Whether it’s an enterprise application, the automobile you drive, or your favorite tea kettle, seemingly everything in the world today produces data. This results in a need to transfer data to a place where people and technology can make sense of it. Typically, the faster data can be transferred and more data that can be ...