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

Credit Consumption Notification by Role

Imagine you’re responsible for overseeing the usage of Snowflake credits across different roles within your organization. You need a streamlined way to monitor credit consumption by role over specific periods to identify any anomalies or trends. This stored procedure, SendEmailWithCreditDetails, automates the process of notifying users about Snowflake credit usage […]

Read More

Identifying Table Types Within a Session

In a dynamic database environment, users often leverage session-specific temporary tables to perform ad-hoc analyses, data manipulations, or intermediate computations. However, managing and identifying these temporary tables across sessions can pose challenges, especially when coexisting with permanent tables of the same name. Ensuring efficient utilization of temporary tables while preserving […]

Read More

Customer Segmentation with Snowpark

Consider a scenario, you are part of data engineering team at a retail company. you’re tasked with leveraging customer behavior and preferences to improve engagement and marketing strategies. However, the volume of daily transaction data poses challenges in effectively segmenting customers and optimizing engagement. Traditional segmentation methods fall short in […]

Read More

Keeping an Eye on Your Snowflake Warehouse: Automated Monitoring and Email Alerts

In the world of data warehousing, keeping track of changes to your Snowflake warehouse size is crucial. Unexpected adjustments can impact performance and potentially incur additional costs. This blog post introduces a solution for automated warehouse size change monitoring and email alerts using Snowflake Streams and Tasks. Imagine you’re a […]

Read More

Exploring Books with Snowpark and Streamlit

In this blog post, we will explore how to leverage Snowpark and Streamlit to build an interactive book exploration application. Snowpark is a feature in Snowflake that allows developers to write code in their preferred programming language, and Streamlit is a Python library for creating web applications with minimal effort. […]

Read More

Automating Dynamic Table Creation with Event Logging

In the ever-evolving world of data management, streamlining processes and ensuring data freshness are crucial. Snowflake, a cloud-based data platform, provides a revolutionary feature known as Dynamic Tables. This blog post showcases a novel approach combining Snowflake’s Event Logging and Dynamic Tables to automate the creation and population of dynamic […]

Read More