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
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 inSnowflake·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. In Snowflake, you can schedule a single SQL statement or a Stored…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·Jul 24Snowflake Admin Series: Organization 2.0In this blog we are going to discuss further enhancement in Snowflake Organization area. These topics describe the administrative concepts and tasks associated with managing your organization in Snowflake. If you missed my previous article on Organization than you can read it now here What are the new enhancement ? Earlier you have to reach out…Snowflake4 min readSnowflake4 min read
Published inSnowflake·Jul 16Snowflake GROUP BY ALL — UnlockedIn this blog we are going to explore how we can utilize the Snowflake grouping clause. Hope everyone should know or hear what is GROUP BY clause in SQL if you are SQL background. But don't worry if you have not heard about this in the past. …Snowflake3 min readSnowflake3 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
