You can access the snowflake query history page from Navigation=>Compute=>Query History. Users can access the…
Category: snowflake
What are the Query Operators supported by Snowflake
Snowflake supports most of the standard operators defined in SQL:1999. Arithmetic Operators + , – , * , / ,…
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…