Tag: Cloud Database

AWS Glue @ Freshers.in

How to create AWS Glue table where partitions have different columns?

There can be a condition where you can expect new column in JSON file regularly . There can be a…

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 + , – , * , / ,…