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
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
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
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
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
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
