How to Build your First Streamlit App in Snowflake

By Deiby Gómez
Photo by Mark Basarab on Unsplash
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 [...]

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 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.

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.

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.

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.

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.

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.

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.