Published inSnowflake·PinnedAll You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 1This blog will be multipart blog and going to start with basic and then increase the understanding level till complex concept. Please read all the part of this series to get the full understanding for this important topic. Database replication is standard edition ready feature and most of the organization…Snowflake5 min readSnowflake5 min read
Published inDev Genius·PinnedWhen To Use Which Table In Snowflake?In this blog we are going to discuss on various table type available in Snowflake and their specific use-case. I will try to make the use case as much as clear and hope after reading this blog you can easily make your decision to pick the right table type for…Snowflake10 min readSnowflake10 min read
Published inDev Genius·PinnedHow to use Database Role in Snowflake, It’s behavior, everything you need to know…!Today we are going to discuss on use case demo on Database role. How to use database role in Snowflake. At the moment we don’t see implementation for database role in Snowsight UI. Preview feature is currently working at code level only. If you have not seen my recent blog…Snowflake2 min readSnowflake2 min read
Published inSnowflake·PinnedGetting Started with Snowflake TasksIn this blog, we are going to discuss how Snowflake Task can help you. A task in Snowflake is more of a scheduler like any other database or OS. Some similar examples are database scheduler, CRON job, etc. …Snowflake7 min readSnowflake7 min read
PinnedZero to Hero in Snowflake Certification : SNOWPRO Core Certified in 2–3 weeksIntroduction/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…Certification8 min readCertification8 min read
Published inSnowflake·Apr 9How To Audit Views In Snowflake?In this blog we are going to discuss on how we can set up audit on views. Earlier we can track the dml operation on tables which was useful, but we can’t do the same on views. …Snowflake4 min readSnowflake4 min read
Published inSnowflake·Jan 4All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 4This blog is a continuation of my below previous part: All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 3 All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 2 All You Need To Know About Snowflake Database Replication & Fail-Over/Failback —…Snowflake5 min readSnowflake5 min read
Published inSnowflake·Jan 2All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 3This blog is a continuation of my below previous part: All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 2 All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 1 If you missed seeing the previous blog than I would recommend reading…Snowflake3 min readSnowflake3 min read
Published inSnowflake·Dec 30, 2022All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 2This blog is a continuation of All You Need To Know About Snowflake Database Replication & Fail-Over/Failback — Part 1. If you missed seeing the previous blog than I would recommend reading that first to understand this blog better. Please read through the below admin series of blog which might…Snowflake5 min readSnowflake5 min read
Published inDev Genius·Dec 24, 2022Exploring DDL/DML/CLONE Operation Impact on Snowflake StorageIn this blog we are going to do various DDL & DML operation on normal and cloned tables and observe its impact on storage and try to explore what action can hit the storage overhead and which we need to take care during our actual project implementation. This blog is…Snowflake8 min readSnowflake8 min read