Monday, May 8 2023

A Deep Dive into Data Sharing

Introduction: Big data refers to extremely large datasets that can be analyzed to identify patterns, trends, and associations. The analysis of big data provides insights into various fields, including business, science, and government. However, the challenge with big data is not just analyzing it,  […]

Continue reading

Saturday, May 6 2023

Time Travel In Snowflake

Continue reading

Step-by-step guide on how to load an XML file into a Snowflake database in 6 steps.

In this articles ,  we will learn how to load a XML file in a snowflake database . Step 1: Convert the XML file to a compatible format As mentioned earlier, Snowflake natively supports loading and querying JSON files. Therefore, we need to first convert the XML file to a JSON file using an  […]

Continue reading

Friday, December 9 2022

Intro to the Snowflake Data Cloud

Snowflake-Key-Features.png, Dec 2022

With data’s consistent rise in volume and velocity, organizations seek solutions to process big data and any related challenges. One of the first decisions that organizations take? Adopting a cloud-based model that offers flexibility, scalability, and high performance. Snowflake is one cloud-based  […]

Continue reading

Saturday, October 1 2022

Change Data Capture using Snowflake Streams

Screenshot 2022-10-01 192702.png, Oct 2022

Introduction Change Data Capture (CDC) is a process that identifies and captures changes made to data in a database and then delivers those changes in real-time to a downstream process or system. There are several proven methods through which CDC can be implemented like making use of Audit Columns  […]

Continue reading

Working with Snowflake External Tables and S3 Examples

Snowflake External tables allow you to access files stored in external stage as a regular table. You can join the Snowflake external table with permanent or managed table to get required information or perform the complex transformations involving various tables. The External tables are commonly  […]

Continue reading

Saturday, September 24 2022


STORAGE INTEGRATION is a Snowflake object that stores a generated identity and access management entity for external cloud storage (Amazon S3, Google Cloud Storage, or Microsoft Azure). Cloud administrators can grant permissions on the storage locations to the generated entity. By using storage integration users need not provide credentials as open text while creating external stages or when loading data from external cloud storage.

Continue reading

Monday, March 14 2022

Snowflake :- Real Time Data Ingestion

Monday, January 3 2022

Snowflake :- Time Travel


Continue reading

Monday, December 27 2021

Snowflake :- Load Parquet File in table

Tuesday, December 21 2021

Snowflake :- Load Json File in table

Wednesday, November 24 2021

Snowflake :- Create Tables

How to create a warehouse in snowflake.

Tuesday, November 23 2021


What is JSON? JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. While it is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition - December 1999, it  […]

Continue reading


Introduction Snowflake has recently announced external functions available in public preview. This allows developers to invoke external APIs from within their Snowflake SQL queries and blend the response into their query result, in the same way as if they were internal Snowflake functions. In this  […]

Continue reading


In this post, I’m going to walk you through where the information lives in Snowflake and show you a couple of ways that I get the users, roles, and grants information combined that work well and make it very accessible for answering those security and audit questions. Snowflake Users and Roles via  […]

Continue reading