Snowflake

How to Alter Large Tables Without Downtime

A story about adding a new column to a table with 600 million records The Challenge Picture this. You have a task to implement data…

Automated Testing of ETL Pipeline in Snowflake

Introduction Building on our previous blog Building ETL Pipeline in Snowflake, we will cover different approaches to automated testing for ETL Pipelines in Snowflake. For…

Integrating Snowflake with Java: JDBC and Async JDBC Execution

Introduction Snowflake is a cloud-based data platform that enables simple, fast, and scalable data storage, processing, and analysis. Unlike traditional solutions, Snowflake is not built…

Storing semi-structured data in Snowflake

Introduction Snowflake's definition on their website is as follows: “A single, fully managed platform that powers the AI Data Cloud. Snowflake securely connects businesses globally…

Consuming and Storing Kafka Messages in Snowflake Using Kafka Connect (Part 2)

In the previous blog we explained what Kafka Connect is, what we can do with it, and what are some of the most important components…

Building ETL Pipeline in Snowflake

Introduction In today's data-driven landscape, the efficiency and flexibility of your ETL processes can make or break your analytics strategy. With its robust, cloud-native architecture,…