About Us

Cloudyard is being designed to help the people in exploring the advantages of Snowflake which is gaining momentum as a top cloud data warehousing solution.

Site provides professionals, with comprehensive and timely updated information in an efficient and technical fashion. From basic to Advanced concepts along with the realtime scenario,Weaves the SnowSql, jq parser,Snowflake-Python connector,propositional logic all at one place in order to unveil nuances of realtime flavour and experiences with Snowflake Cloud. Read More

Latest Post

Dynamic Table and Alerts for Customer Purchase Notifications

Snowflake Dynamic Table and Alerts: This use case addresses automating customer accessory purchase monitoring in Snowflake to provide the marketing team with timely insights for personalized promotions. Imagine you’re a Data Engineer/Data Governance developer for an online retail store. You ensure the marketing team receives insights on customer accessory purchases […]

Read More

Disable Inactive Users in Snowflake

Managing user accounts is a critical task in any organization, especially for ensuring security and compliance. With the increasing number of users and automating the process of disabling or inactive user accounts for employees who have left the company is essential. This blog post will explore how you can leverage […]

Read More

Use Case: Monitoring Internal Stage Stale Storage

Many organizations leverage Snowflake stages for temporary data storage. However, with ongoing data ingestion and processing, it’s easy to lose track of stages containing old, potentially unnecessary data. This can lead to wasted storage costs. You want to implement a monitoring solution to track the storage usage of each internal […]

Read More

Dynamic Merge Procedure: Snowflake’s Enhanced Flexibility

Last week, I introduced a stored procedure called DYNAMIC_MERGE, which dynamically retrieved column names from a staging table and used them to construct a MERGE INTO statement. While this approach offered flexibility, it had a limitation – the HASH condition used static column names. Hence relying on static column names, […]

Read More

Aggregation Policy in Snowflake

Aggregation Policy: Let’s consider a scenario where Sachin Mittal, “Cloudyard,” has a central data repository stored in Snowflake. This repository contains detailed transaction records of customer orders across various stores. Sachin needs to share summarized transaction data with Vishal Kaushal (partner) regularly. However, Vishal is known for his inquisitive nature, […]

Read More

Dynamic Merge in Snowflake

Consider a Scenario where the Client manages a large Customer-Invoice details with constantly changing Invoice data. The company uses Snowflake to manage Invoice data in a table named S_INVOICE. This table receives daily loads(history + Current) to reflect changes in customer and invoice partial payment. The goal is to efficiently […]

Read More