Get Started

Snowflake

Welcome to our Snowflake category. This section is dedicated to providing comprehensive resources, expert tutorials, and best practices for using Snowflake, the cloud data platform. Whether you’re a data analyst, data engineer, or IT professional, our content covers essential topics such as Snowflake architecture, data warehousing, performance optimization, data sharing, and security. Learn how to leverage Snowflake’s powerful features to streamline your data processes, improve scalability, and enhance your data analytics capabilities. Stay updated with the latest trends, tools, and techniques in Snowflake with our in-depth guides and practical insights.

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

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

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