Published in Snowflake·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 in Dev Genius·PinnedMember-onlyWhen 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 in Dev Genius·PinnedMember-onlyHow 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 in Snowflake·PinnedMember-onlyGetting 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
PinnedMember-onlyZero 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 in Snowflake·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 in Snowflake·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 in Snowflake·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 in Dev Genius·Dec 24, 2022Member-onlyExploring 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
Published in Dev Genius·Dec 19, 2022Member-onlyDatabase Role V/S Account Role in SnowflakeToday we are going to discuss freshly baked all edition feature direct from Snowflake oven i.e. Database role.Snowflake5 min readSnowflake5 min read