PinnedSnowflake — Get Self Started!Introduction: Myself working as Architect in Cloud Data Warehouse technologies based out of India. I am Snowpro Architect & Data Engineer Certified, AWS Solutions Architect — Associate, Teradata Vantage Architect & Teradata Vantage Senior Developer. I got introduced to Snowflake in the year 2019; then already working on Amazon Redshift…Snowflake2 min readSnowflake2 min read
5 days agoBuilding Dashboard for Snowflake Account MonitoringBuilding dashboards on Snowflake is very simply, where you can visualize data by collection of customized charts, that are generated by query results. For demonstration, lets build a dashboard to monitor your free trail account that illustrates following charts - Days Remaining for Free Snowflake Account Expiry Storage in TB Storage Usage Remaining…Snowflake4 min readSnowflake4 min read
Jan 3Snowflake Snowpipe with Azure— System Topic error related to EventGrid subscriptionIf you are setting up Snowflake Snowpipe first time with Azure container following https://snowflakewiki.medium.com/snowpipe-setup-to-azure-container-1a320a93f1b5 then, at step 3) Create Event grid subscription, following error could be encountered.Snowflae2 min readSnowflae2 min read
Dec 12, 2022Snowflake Infrastructure with Security made easyDesigning a snowflake solution using a version control tool, integrating with external storages and workflow management platforms; managing the infrastructure of your cloud resources can be a challenge without compromising on security aspects. It would no longer be that complex if you go through this POV. Getting started, following are…Snowflake7 min readSnowflake7 min read
Dec 3, 2022Snowpipe setup to Azure ContainerHere is the step by step guide for beginners to establish snowpipe connectivity in Snowflake with Azure blob storage containers. If you are looking for navigation using Azure UI to configure the set up (that is not in snowflake documentation) then you are at a right place here. 1) Set…Snowflake4 min readSnowflake4 min read
Nov 29, 2022Connecting Snowflake to Azure ContainerHere is the step by step guide for beginners to connect Snowflake with Azure blob storage containers using storage integration. If you are looking for navigation using Azure UI to configure the set up (that is not in snowflake documentation) then you are at a right place here. 1) Login…Snowflake4 min readSnowflake4 min read
Oct 6, 2022SnowPro Advanced: Data Engineer Certification GuidePreparation, checks and hints needed to clear SnowPro Advanced: Data Engineer Certification in your 1st attempt SnowPro Advanced: Data Engineer Certification sure is intense exam and though than anticipated. …Snowpro3 min readSnowpro3 min read
Mar 28, 2022Case Sensitivity in SnowflakeUnderstanding Case Sensitivity when creating and querying snowflake objects Snowflake is case-sensitive and let us understand how it behaves through demonstrations below: Demo1 — Creating an object in upper case without double quotes a) Selecting the object in any case without double quotes will return the table. b) Selecting the…3 min read3 min read
Mar 15, 2022SnowPro Advanced Architect Certification GuidePreparation, checks and hints needed to clear SnowPro Advanced Architect Certification in your 1st attempt SnowPro Advanced, Architect Certification tests your real time hands on and in depth understanding of the Snowflake topics. The knowledge you acquired for SnowPro Core Certifications is the foundation and few of the exam questions…Snowpro4 min readSnowpro4 min read
Mar 15, 2022SnowPro Core Certification GuidePreparation, checks and hints needed to clear SnowPro Core Certification in your 1st attempt To begin with SnowPro Core Certification is a simple exam if you are already working on Snowflake in any capacity. Incase if you are new to Snowflake, get self started by referring to — https://snowflakewiki.medium.com/snowflake-get-self-started-6859d4f2112c Important…Snowpro Core Exam3 min readSnowpro Core Exam3 min read
