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

Data Sharing with Listing in snowflake

In this blog post, we will delve into Snowflake’s Listing feature, which operates on the data sharing provider and consumer model. Secure data sharing, which encompasses External tables, Dynamic tables, Secure views, Secure materialized views, Secure UDFs, and Tables, is well-known for its restrictive access. The Listings feature enhances the […]

Read More

Object Privileges in CLONE

During this post, we are going to discuss how the object privileges works during the CLONE operation. Recently one of my colleagues encountered a scenario a scenario where they had cloned few tables from one DB to Target DB. While cloning they assumed that the object privileges would also get […]

Read More

Dynamic Copy Process

In this post, we will explore the automation of the COPY process for loading a Snowflake table from an S3 bucket. Imagine a scenario where data needs to be migrated from a traditional system to a Snowflake database. The source system contains numerous tables that must be replicated in Snowflake. […]

Read More

Execute Immediate From Stage

During this post we are going to discuss EXECUTE IMMEDIATE FROM SQL command which trigger directly from files stored in an internal stage. We can have one or multiple sql files consist of valid Snowflake SQL commands. We can upload these files to the internal staging area and can execute […]

Read More

Schema Evolution with CSV

In this post, we’ll explore Schema Evolution in Snowflake, a crucial feature allowing seamless adaptation to changing data structures. While Parquet files were initially supported, Snowflake has extended this feature to CSV and JSON files as well. Modern data systems often append new columns to accommodate additional information, necessitating downstream […]

Read More

Snowflake Python UDFs: An overview

In this post, we are going to discuss Python User-Defined Functions (UDFs) within Snowflake. While we don’t have a specific use case in mind, this exploration is driven by the sheer potential these UDFs offer. Especially if we talk about the seamless integration of Python within Snowsight, this integration simplifies […]

Read More