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 Masking in Snowflake Using Tags, Policies, and Automation

Data Masking in Snowflake Using Tags, Policies, and Automation: In modern data platforms, data masking and access control are critical pillars of security and compliance — especially with sensitive fields like SSNs, email addresses, and financial metrics. In this blog, we explore how to implement a tag-driven masking and row-level […]

Read More

Snowpark Magic: Auto-Create Tables from S3 Folders

Snowpark Magic: Auto-Create Tables from S3 Folders — In modern data lakes, it’s common for departments like Finance, Marketing, Sales, etc., to continuously drop data files into their respective folders within an S3 bucket. These files often arrive in CSV format, and over time, teams request new folders or refresh their […]

Read More

Optimizing Snowflake Serverless Tasks

Snowflake’s Serverless Tasks are designed to automate workflows without requiring a dedicated warehouse. Instead, Snowflake dynamically allocates compute resources based on workload demands, making it a cost-effective and scalable solution for scheduling data transformations, ELT processes, and real-time analytics. However, to fully optimize serverless tasks, Snowflake provides three key parameters […]

Read More

Significance of Snowflake task graphs

Snowflake provides tasks—a powerful way to schedule and automate SQL operations. However, when workflows grow complex, a single-task approach is not enough. Enter task graphs, a feature that allows us to define dependencies, sequence executions, and optimize performance across multiple tasks. This blog explores the significance of Snowflake task graphs, […]

Read More

Automating CSV & Parquet File Ingestion from S3 to Snowflake

In modern data architectures, businesses rely on automated pipelines to ingest, transform, and analyze data efficiently. Automating CSV & Parquet File Ingestion from S3 to Snowflake becomes crucial when customers place different file types (such as CSV and Parquet) in a single S3 bucket. This scenario demands a seamless, automated […]

Read More

Masking in SF Without Hardcoded Roles: Including ARRAY cols

In data-driven enterprises, data security is non-negotiable. Dynamic Masking policies in Snowflake help safeguard sensitive information such as customer emails, payment details, and purchased items. However, a common challenge arises: Hardcoded role names in masking policies make managing access permissions cumbersome. Whenever a new role is added or removed, the […]

Read More