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 read
1 day agoSnowflake Admin Series: Organization Usage SchemaIn this blog we are going to see how Snowflake maintain metadata of all accounts under an Organization to help give you one stop glance at your multiple accounts. …Snowflake5 min read
Published in Snowflake·Jun 16Snowflake Admin Series: OrganizationIn this blog we are going to discuss Snowflake Organization. These topics describe the administrative concepts and tasks associated with managing your organization in Snowflake. How much relevant this topic is with respect to certification exam? This topic is very important, and you may expect a couple of question from…Snowflake6 min read
Published in Snowflake·Jun 10Snowflake Semi-Structure Data FunctionIn this blog we are going to discuss some useful data function which can help you deal with semi-structure data. To be specific we are going to discuss today on below 4 data function: Object_Construct Object_Construct_keep_null Array_Construct Array_To_String OBJECT_CONSTRUCT This data function help you construct the object out of any…Snowflake3 min read
Published in Snowflake·Jun 8Snowflake QUALIFY ClauseIn this blog we are going to see how we can utilize the magic of qualify clause to reduce the overhead of an extra layer of query to filter certain sets of data. Hope you all are aware of Having Clause which we have quite frequently used in ANSI SQL…Snowflake2 min read
Published in Snowflake·Apr 12Snowflake Admin Series:Snowflake Parameters- a centralized cockpit control-Part 3This blog is the third part of my 3 part story on Snowflake parameter. I would recommend you to please read Snowflake Parameters- a centralized cockpit control-Part 1 before reading this blog for your better understanding. …Snowflake7 min read
Published in Snowflake·Apr 6Snowflake Admin Series: Snowflake Parameters- a centralized cockpit control-Part 2This blog is the second part of my two part story on Snowflake parameter. I would recommend you to please read Snowflake Parameters- a centralized cockpit control-Part 1 before reading this blog for your better understanding. In this blog I am going to highlight a few of the Snowflake parameter…Rajiv Gupta6 min read
Published in Snowflake·Mar 28Snowflake Admin Series: Snowflake Parameters- a centralized cockpit control-Part 1In this blog we are going to learn how we can use different types of parameters available in Snowflake. This is one out of three part stories. Before I start with any technical explanation or usage of any parameter I would like to put your focus on why it is…Snowflake6 min read
Published in Snowflake·Mar 21Snowflake Scripting Series: Branching ConstructIn this blog we are going to learn about branching construct which Snowflake SQL Scripting supports as part of this new feature. This can be used as anonymous block or inside stored procedure. Snowflake SQL Scripting is General Available now. This is one of the blog out of many for…Snowflake4 min read
Published in Snowflake·Mar 14Snowflake Scripting Series: PLSQL programming using LoopsIn this blog we are going to learn how we can use different types of loops available in Snowflake Scripting for our programming ease. This can be used as anonymous block or inside stored procedure. Snowflake SQL Scripting is General Available now. This is one of the blog out of…Rajiv Gupta5 min read
