The complete list of Table Functions in Snowflake are as follows. Table functions are functions…
Tag: Cloud Database
How can you track the change metadata of a Snowflake table?
The CHANGES clause enables querying the change tracking metadata for a table within a specified interval of time without having…
How to do Pivot in Snowflake ?
PIVOT in Snowflake PIVOT rotates a table by turning the unique values from one column in the input expression into…
How can you UNPIVOT in Snowflake ?
UNPIVOT in Snowflake UNPIVOT will rotate a table by transforming columns into rows. UNPIVOT is a relational operator which accepts…
Snowflake : How to load data from Amazon S3 to Snowflake table using Copy
With Snowflake COPY command you can load data from staged files on internal/external locations to an existing table or vice…
In Snowflake how to Encrypts a BINARY value using a BINARY key ?
ENCRYPT_RAW is used to Encrypts a BINARY value using a BINARY key. Syntax ENCRYPT_RAW( <value_to_encrypt> , <key> , <iv> ,…
How to encrypt VARCHAR or BINARY in Snowflake ? What are the Encryption Functions in Snowflake ?
In Snowflake Encryption functions encrypt or decrypt VARCHAR or BINARY values. ENCRYPT : This function will Encrypts a VARCHAR or…
What is Snowflake Merge Command ? How to use it ?
The Snowflake Merge command will allows you to perform merge operations between two tables. The Merge operation includes Insert, Delete,…
What are the Data Processing Operators in Snowflake ?
Filter : Represents an operation that filters the records. Attributes: Filter condition – the condition used to perform filtering. Join…
What are the Query Operators supported by Snowflake
Snowflake supports most of the standard operators defined in SQL:1999. Arithmetic Operators + , – , * , / ,…
Amazon Aurora quick reference and cheat sheet.
1. Aurora is an AWS proprietary database. 2. Aurora is a fully managed service. 3. Aurora have High performance and…