Category: snowflake
Granting Select Access to All Tables in Snowflake to Public Role
Learn how to efficiently grant SELECT permissions to all tables within a specific schema in Snowflake to the PUBLIC role….
Unveiling the Utility of EQUAL_NULL in Snowflake: A Comprehensive Guide
Snowflake, a cloud data platform, offers a unique feature known as EQUAL_NULL. This feature changes the behavior of the equality…
Snowflake admin activity and expectations : What all things an Snowflake admin needs to know
Snowflake is a cloud-based data warehousing platform that provides a wide range of administrative activities for managing data, users, and…
Optimizing snowflake costs through query tag-based analysis
Analyzing Snowflake costs based on query tags is a useful approach to gain insights into how different types of queries…
Retrieving a list of all user names within the current account in snowflake
The ALL_USER_NAMES function in Snowflake is a powerful tool for retrieving a list of all user names within the current…
Snowflake : Combining multiple arrays into a single array, removing duplicate elements in Snowflake
ARRAY_UNION_AGG ARRAY_UNION_AGG is a built-in function in Snowflake that combines multiple arrays into a single array, removing duplicate elements. This…
Creating, cloning, and dropping databases in Snowflake
Snowflake is a powerful cloud-based data warehousing platform that offers a wide range of features for data management and analytics….
Insert a dataframe into Snowflake using Python – Source code included
In this article we will see how to insert a DataFrame into Snowflake using Python. You can use the pandas…
String Manipulation Techniques in Snowflake : REGEXP, CONTAINS, REPLACE, Splitting and Concatenating
String manipulation is fundamental when dealing with textual data in any database system. Snowflake offers an array of string functions…
Exploring the VARIANT data type in Snowflake
Snowflake, a leading cloud data platform, has a unique feature that distinguishes it from traditional relational databases. It offers a…