The complete list of Table Functions in Snowflake are as follows. Table functions are functions…
Tag: Cloud Database
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…
Snowflake : Lateral Join in Snowflake
Lateral Join is a powerful feature in Snowflake that allows you to join a table with a table-valued function (TVF)….
Snowflake : Recognizes matches of a pattern in a set of rows (MATCH_RECOGNIZE)
Snowflake’s MATCH_RECOGNIZE is a powerful feature that allows users to identify patterns in data and extract meaningful insights. With MATCH_RECOGNIZE,…
Snowflake : Analyze data in a hierarchical manner (CONNECT BY)
Snowflake’s CONNECT BY is a powerful feature that enables hierarchical queries to be performed on data in a Snowflake database….
Snowflake : Data Sharing in Snowflake
Data Sharing is a unique feature of Snowflake that enables organizations to securely share data across different Snowflake accounts. This…
Hive : Learn hive external functions and how can you use external functions in Hive?
Hive is built on top of Hadoop, which is a distributed file system and a framework for processing large data…
Hive : Hive custom input/output formats .How can you use custom input/output formats in Hive?
Introduction to Custom Input/Output Formats in Hive: Hive allows users to define custom input and output formats to read and…