To grant access to an S3 bucket for a Snowflake account, you will need to…
Category: snowflake
Why sqitch init snowflake cannot determine Snowflake account name ?
Currently supported databases by Sqitch’s database change management tool include Snowflake’s Cloud Data Warehouse as well as PostgreSQL 8.4+, SQLite…
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 features in Snowflake Query History page?
You can access the snowflake query history page from Navigation=>Compute=>Query History. Users can access the Query History page from the…