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

Third-Party Packages from Anaconda in Snowflake

During this post we will discuss about how to use third party packages from anaconda in Snowflake. As we know Anaconda Announces Partnership with Snowflake to Bring Open-Source Python to the Data Cloud. Hence, Now onwards a number of popular open source third-party Python packages that are built and provided […]

Read More

Snowflake:Transferring Pipe Ownership

During this post we will discuss about Transferring Pipe Ownership. In our current Account majority of PIPES are owned by ACCOUNTADMIN role. As part of maintenance, this becomes a painful task for AccountAdmin role. As per discussion with Business, it was decided to transfer some responsibility from ADMIN to other […]

Read More

Snowflake:SQL Scripting Procedure to find Duplicate

During this post we will discuss a requirement which we resolve using SQL scripting. Currently we are in the development phase, and we have created multiple tables. Later on, using the different mechanisms we have populated these tables. As per the confirmation from the source team as well, they don’t […]

Read More

Secondary Roles in Snowflake

During this post we will discuss about Primary roles and Secondary Roles. Primary Role is your current role. The Role we select by using USE <<ROLE>> or the default role assigned to the user at the time of creation. Sometimes when there is no role assign a default PUBLIC role […]

Read More

DIRECTORY Table: Download File from Internal Stage

During the last post we discussed DIRECTORY table and GET_PRESIGNED_URL two key properties in snowflake. We used these features to download the File Snowflake WEBUI instead of respective cloud provider UI framework. We accessed the file present on the external stage i.e. AWS using DIRECTORY and GET_PRESIGNED_URL in SQL query. […]

Read More

ADF Script Activity to load Snowflake

ADF Script Activity: During the last ADF post we have discussed about COPY activity to ingest data into snowflake. With COPY Activity we have limited control in terms of loading data from external stage to Snowflake. Also there are key Snowflake COPY parameters and we cannot leverage them during ADF […]

Read More