Category: snowflake

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…

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…