Get Started

RPA Blog

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

How to Create Multi-Page Applications with Streamlit

Photo by Andrea De Santis on Unsplash By Deiby Gómez As Data Engineers, there’s a growing need to present data pipelines, monitoring tools, and insights through lightweight, user-friendly web applications. Streamlit has become a go-to framework for building these tools due to its speed, simplicity, and native integration with the Python data ecosystem. Streamlit allows […]

How to Create Multi-Page Applications with Streamlit Read More »

Streamlit, Uncategorized
Teal cloud icon glowing on a microchip with circuit lines and a lock symbol, representing AWS Lambda Snowflake SSH authentication through secure key exchange.

How to Update your Lambdas to Authenticate with SSH Keys in Snowflake

By Deiby Gómez Snowflake is deprecating user/password authentication in favor of key pair authentication. This impacts AWS Lambda-based data pipelines that currently rely on legacy authentication. This article explains how to update your Lambda functions to use SSH key-based authentication when connecting to Snowflake. You’ll learn how to securely store your private key in AWS

How to Update your Lambdas to Authenticate with SSH Keys in Snowflake Read More »

AWS, AWS Lambda, Data Engineering, Security, Snowflake
Abstract data stream visualizing natural language processing into SQL queries, with glowing blue and orange lines representing structured business information flow.

How to Access Business Information using Natural Language in Snowflake with Cortex Analyst

By Deiby Gómez One of the biggest challenges in working with data is giving non-technical users direct access without relying on Data Engineers or Analysts. While SQL remains the backbone of data querying, business users still need to extract insights quickly without writing code. This is where Snowflake Cortex Analyst comes into play. It’s a

How to Access Business Information using Natural Language in Snowflake with Cortex Analyst Read More »

AI, Business Intelligence, Data Analytics, Snowflake, Uncategorized

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

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

dbt, Modern Data Platform, Snowflake Computing, Strategy
This captivating image showcases a symbolic interaction between a robotic hand and a human hand, forming a heart shape amidst a neon-lit, cyberpunk cityscape. It visually represents the harmonious blend of human creativity and advanced AI technology in the field of agile project management. The image highlights the theme of the blog, discussing how generative AI technologies are increasingly integrated into Scrum methodologies to enhance collaboration and innovation in project teams.

Generative AI’s Unexpected Romance with Scrum

by Kristi Smith Hey there! If you’re a Scrum team member in the software development world, you’ve probably found yourself knee-deep in Scrum meetings, wondering if there’s a better way to handle all those sticky notes and ceremonies. Even rock-star Scrum teams hit roadblocks — those marathon meetings, communication snafus, and admin work that steals precious time.

Generative AI’s Unexpected Romance with Scrum Read More »

Agile, AI, project management
A classic DeLorean DMC-12 flying through a snowy landscape, leaving behind glowing snowflake trails instead of traditional time-travel streaks. This visually represents the concept of Snowflake time-based tables, symbolizing dynamic data sequencing and structured time intervals in Snowflake’s cloud data platform.

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 Create Dynamic Time-Based Tables in Snowflake Read More »

Cloud Computing, Data Warehousing, Snowflake, Snowflake Computing, SQL, Uncategorized
Grand hallway with a black and white checkered floor, symbolizing structured data and open data sources for analytics and business intelligence

Got Technology, Need Data? Here’s the Best Free Data Sources for Analytics & AI

Photo by Cristina Gottardi on Unsplash The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” free data sources–think census, stock

Got Technology, Need Data? Here’s the Best Free Data Sources for Analytics & AI Read More »

Big Data, Business Intelligence, Data Integration, Data Visualization, Free Data Sources, General, Open Data, Public Data Sets, Tips
Silhouette of a person demonstrating how to combine filters in Looker with creative lighting effects.

How to Combine Advanced and Custom Filters in Looker Studio

By Kristi Smith Note: Looker, now part of Google Cloud’s Looker Studio, remains a powerful BI tool for creating dashboards. While this guide focuses on combining filters in Looker, the steps also apply to Looker Studio environments. Matches Advanced Filters I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive,

How to Combine Advanced and Custom Filters in Looker Studio Read More »

Business Intelligence, Data Analytics, Data Visualization, Looker, Uncategorized

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