One of my team members recently requested with calculating the database credits for a project in Snowflake. To calculate the storage space used by a specific Snowflake database, we first need to understand the base metadata view that provides the necessary details. Database_storage_usage_history (View) -> Details about database and Failsfe …

I am planning to write a series of articles on working with Snowpark in Python. Prior to starting any coding examples or sessions, we will first take a look at what Snowpark is and the advantages we can gain from using it. Snowpark Library: The Snowpark library offers a user-friendly…

Part1 edition describes about detailed about Serverless Task with Example? let’s move on to the execution part of the study. To compare their performance, I created a Server Task and a Serverless Task at the same time, and both tasks performed identical activities. …

I recently did a study on the Serverless Task feature, which was recently announced by the Snowflake team. Although this analysis may be lengthy, I have tried my best to keep it as concise as possible. Serverless Tasks (Definition): The serverless compute model for tasks enables you to rely on…

Snowflake recently added two new aggregation functions: min_by and max_by. These functions allow users to find the minimum or maximum value of a column (x) based on the value of another column (y), and also allows to return the nth value. …

This blog will cover Snowflake’s new SELECT * syntax improvements: “SELECT * EXCLUDE” . SELECT * EXCLUDE: When writing SQL, it is quite common to select all columns except a few. To achieve this, it is common to name every column in the SELECT clause, but this can take a long time when…

Part1 & Part 2 edition describes about detailed description of Object tagging, Tag override, Tag Discovery, Tag Lineage, How to create and apply tag to snowflake objects ? and How to Apply Tag-Based Masking Policies ? How to drop a Masking Policy in Snowflake ? A masking policy cannot be…

Part1 edition describes about detailed description of Object tagging, Tag override and How to create and apply tag to snowflake objects ? TAG discovery (Continuation): The below statement returns the tag value assigned to a Snowflake object by calling the get_tag system function with the parameters ‘<tag_name>’ , ‘<object_name>’ …

The purpose of this blog is to explore one of Snowflake’s key data governance features, Object Tagging, and its concepts and advantages. What is Object Tagging ? Object Tagging enables governance operations such as Data classification Tracking sensitive data Resource usage monitoring Protecting the data. Object tagging allows us to assign metadata to Snowflake objects…