kedhar.natekar

Anaytics, Big Data

Improving query performance in Snowflake and its related costs

In the previous blog, we understood how to Optimally use Snowflake Warehouse and Tables. So let's continue the blog series, where we will now focus on improving the performance in Snowflake and its associated costs. As we know, Snowflake tables are micro-partitioned, which significantly improves query performance. However, over time,...

15-May-2023

Anaytics, Big Data

Optimal use from Snowflake Warehouse and Tables

In the previous blog, we discussed the Best practices to be followed while Data loading into Snowflake from Stages. Continuing the snowflake blog series lets us understand how to use Snowflake Warehouse and Tables optimally. Snowflakes Virtual Warehouses Virtual Warehouses is one of the critical components in Snowflake architecture...

30-Mar-2023

Anaytics, Big Data

Best practices and hacks for Data Loading in Snowflake from Stages

Continuing our Snowflake blog series, after learning about setting up a  Snowflake account using System-defined Roles, we will explore the best practices for loading data from a file into Snowflake. Let’s begin. Snowflake supports file-based data ingestion through Internal and External stages.  However, there are various...

16-Mar-2023

Anaytics, Big Data

Snowflake Account setup using System defined roles

This is the first blog in a series that will focus on Snowflake, where we'll cover best practices for using Snowflake, explore various Snowflake functionalities, discuss how to maximize the benefits of Snowflake, and address the challenges that come with its implementation or migration. In this blog, we'll start by discussing setting...

16-Feb-2023