Category: snowflake

What are the Best Practices when using Snowflake Transactions?

A transaction should contain statements that are related and should succeed or fail together. Larger transactions can improve performance in…

Semi-structured Data Types that is supported by Snowflake

Semi-structured Data Types that Snowflake support are VARIANT,OBJECT,ARRAY. These data types are used to represent arbitrary data structures which can…

Data types supported in Snowflake for managing Dates

DATE Snowflake supports a single DATE data type for storing dates (with no time elements). DATE accepts dates in the…

Complete list of System Functions in snowflake

The complete list of System Functions in Snowflake are as follows. System functions will Control functions that allow you to…

Complete list of Table Functions in snowflake

The complete list of Table Functions in Snowflake are as follows. Table functions are functions that produce a collection of…

Complete list of Aggregate Functions in snowflake

The complete list of Aggregate Functions in Snowflake are as follows. Aggregate function or aggregation function is a function where…

Complete list of Scalar Functions in snowflake

The complete list of Scalar Functions in Snowflake are as follows. SCALAR Functions are based on user input. Scalar functions…