Lateral Join is a powerful feature in Snowflake that allows you to join a table…
Tag: Snowflake
Snowflake : Retrieve the SQL script used to create a specific database, schema, table, view, materialized view
In Snowflake, you can use the “GET_DDL” function to retrieve the SQL script used to create a specific database, schema,…
Snowflake : How Snowflake handle backup and recovery?
In this article, we will discuss how Snowflake handles backup and recovery, and how these features help ensure the integrity…
Snowflake : Process of scaling and managing Snowflake clusters
Snowflake’s architecture is designed to provide virtually unlimited scale, allowing users to easily scale up or down based on their…
Snowflake : An overview of Snowflake’s Data Sharing feature
One of Snowflake’s most popular features is its data sharing capability, which allows organizations to securely share data with external…
Snowflake : DESCRIBE SEARCH OPTIMIZATION – Analyze the query plan for a specific query and identify areas for optimization
In Snowflake, the DESCRIBE SEARCH OPTIMIZATION command is used to analyze the query plan for a specific query and identify…
Snowflake : LIMIT and FETCH of Snowflake . How it differs ? When and where its used.
In Snowflake, the LIMIT and FETCH clauses are used to limit the number of rows returned by a query. While…
Snowflake : Filtering the results of window functions in Snowflake [QUALIFY]
One of the features that sets Snowflake apart from other data warehousing solutions is its support for advanced SQL constructs…
Snowflake : Cube in detail. Learn how to implement Cube in Snowflake
In data warehousing, a cube is a multi-dimensional representation of data. It allows users to view data from different perspectives,…
Snowflake : Getting sampled row from the specified table in Snowflake [SAMPLE,TABLESAMPLE]
Two of the most useful tools for working with large datasets in Snowflake are the SAMPLE and TABLESAMPLE functions. The…
Snowflake : Snowflake’s UNPIVOT function – Transform columns into rows in a table
One of the many powerful features of Snowflake is its UNPIVOT function, which allows users to transform columns into rows…