Introduction/Brief Why I like Snowflake : Myself Rajiv Gupta, working as architect and having more than 15 years of experience in Database. From Dec, 2020 I started my journey toward cloud technology. I got introduce to Snowflake from one of my senior folk as it was getting traction in Europe…


In this blog, we are going to see how we can use OKTA as federation authentication to connect to Snowflake.

What is Federated Authentication & SSO?

Federated authentication enables a user to connect to Snowflake using secure SSO (single sign-on). With SSO enabled, your users authenticate through an external, SAML…


In this blog, we are going to discuss on how Snowflake Table Sampling can help you create faster development data set to ease your development lifecycle.

We all love getting our development queries to complete faster on production, like data. …


In this blog, we are going to discuss how SqlDBM can help you accomplish data modeling tasks in Snowflake.

SqlDBM is an online, collaborative data modeling and diagramming tool. It’s a web-based pure SAAS(Software as a Service) data modeling tool. My experience of using the SqlDBM tool was very seamless…


Photo by EJ Strat on Unsplash

In this blog, we are going to discuss on how we can build end to end pipeline for type 2 Slowly Changing dimension. This blog is divided into two part.

  1. Manual Step by Step walk through.
  2. Automate Step 1

So, let’s start and understand the basic setup and flow of…


Photo by Renáta-Adrienn on Unsplash

In this blog, we are going to discuss on how Snowflake Task can help you. Task in Snowflake is more of a scheduler like any other database or OS. Some of similar example are database scheduler, CRON job etc. …


Photo by Bernd Klutsch on Unsplash

In this blog, we are going to discuss on Snowflake Table Streams. Suppose you are reading a book, and it's very interesting, but it's too late to complete. What will you do ? Obviously, you will keep a bookmark on the last page you read today so that you can…


Photo by Markus Spiske on Unsplash

In this blog, we are going to see how we can bulk export data from Snowflake like any other data warehouse. What all format Snowflake support and other important details. Snowflake data export is also a two-step process, just like data import.

  1. Use COPY INTO…<Stage> command to export the raw…

In this blog, we are going to discuss Snowflake Schema Detection's upcoming feature. This feature is currently in Public Preview.

Disclaimer: Currently this feature is in public preview, and subject to change. The majority of features will not see an impact, but small enhancements here and there can be noticed.


In this blog, we are going to discuss on Snowflake Data Governance Feature: Column Level Security.

Dynamic Data Masking & External tokenization are the implementation of Column Level Security. This feature falls under “Protect your data” category and available for all account that are Enterprise Edition (or higher).

If you…

Rajiv Gupta

Data Architect by Profession | Snowflake Data Super Hero | Learner by nature | Blogger by Passion| Motivator by act

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store