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 Quality Features in Snowflake : Part2

During the last post we discussed about Data Governance, a feature of Data Quality. In continuation of the same we will talk about the other features i.e. Auditing, Error Handling, Snowsight, Information Schema to identify Stale tables. Auditing:  LOGIN_HISTORY: Comprehensive Audit Trail for all the activity by all users from […]

Read More

Data Quality Features in Snowflake : Part1

During this post we will discuss about the Data Quality features in Snowflake. As per the definition, Data quality is a measure of the condition of data based on factors such as accuracy, completeness, consistency, reliability and whether it’s up to date. Example of data Quality are duplicates, missing data, wrong […]

Read More

Snowflake to Python :Read_Sql() and Fetch_Pandas()

Read_Sql() and Fetch_Pandas(): During this post we will discuss different ways to get data from Snowflake to Python. Also we will try to compare the performance in terms of time to fetch data from Snowflake. For this discussion we have considered below three functions and measure the time of each […]

Read More

Snowflake: Truncate and Delete

Recently my friend asked very basic but important difference between Truncate and Delete in snowflake. With respect to Oracle, Truncate reset the high water mark of a table back to “zero” and release allocated space back to dba_free_space. Delete physically deletes data row by row and High-water marks are not […]

Read More

Object tagging with Dynamic Masking

Object tagging is use to track sensitive data, such as PII (Personally Identifiable Information) or PHI (Protected Health Information) data. It enables data stewards to track sensitive data for compliance, discovery, protection and auditing. Snowflake stores the tag and its string value as a key-value pair. For a table or […]

Read More

Serverless Task in Snowflake

During this post we will discuss about Serverless TASKS in snowflake. Snowflake tasks allow users to schedule the execution of a SQL statement. Before the Serverless task in place, creation of TASK requires the WAREHOUSE parameter or in other words Warehouse was tightly coupled with the task definition. User have to […]

Read More