Category: snowflake

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…

Continue Reading What are the Best Practices when using Snowflake Transactions?
Snowflake

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…

Continue Reading Semi-structured Data Types that is supported by Snowflake
Snowflake

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…

Continue Reading Data types supported in Snowflake for managing Dates
Snowflake

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…

Continue Reading Complete list of System Functions in snowflake
Snowflake

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…

Continue Reading Complete list of Table Functions in snowflake
Snowflake

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…

Continue Reading Complete list of Aggregate Functions in snowflake

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…

Continue Reading Complete list of Scalar Functions in snowflake