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

Simplifying Data Processing with Snowpark

In this blog post, we’ll delve into a practical example that showcases the prowess of Snowpark by processing customer invoice data from a CSV file and handling credit card details from a JSON source. For instance, Consider a scenario where an organization needs to streamline the processing of customer invoice […]

Read More

Snowflake Cloning Facts

During this post we are going to discuss some interesting facts about cloning. As we know Snowflake’s Zero Copy Cloning feature offers a fast and straightforward method to duplicate tables, schemas, or entire databases. Importantly, this process incurs no extra costs, as the created copy utilizes the same underlying storage […]

Read More

Suspend Child Tasks Programatically

In this blog post, we will delve into a specific scenario concerning the suspension of Child tasks in Snowflake. A colleague recently presented a challenge where he sought to automate the suspension of particular CHILD tasks. In his current setup, there were over 20+ child task intricately connected to a […]

Read More

Read Excel using SnowflakeFile.open

During this post we are going to discuss how we can read EXCEL file in Snowflake Python code. Snowflake offers seamless integration with a variety of file formats, such as CSV, JSON, Parquet, Avro, ORC, and XML, providing users with extensive options for data ingestion. However, what if your specific […]

Read More

Streamlit: Create and Load Table Dynamically

Please excuse me again for one more post related to the Streamlit. In this ongoing exploration of Streamlit, today’s focus is on dynamically creating a table and populating it with a user-defined number of records. Users have the flexibility to choose the record count using a slider, with a maximum […]

Read More

Streamlit App: Export DDL

Continuing my exploration of Streamlit, let’s delve into another Streamlit app today that focuses on exporting the Data Definition Language (DDL) of Snowflake objects. Although there isn’t a particular use case driving this exploration, my curiosity led me to develop code for exporting the DDL of both Tables and Stored […]

Read More