Tag: Database

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…

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 @ Freshers.in

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…

AWS Athena @ Freshers.in

Amazon Athena quick reference and cheat sheet

1. Amazon Athena is an interactive query service to analyze data in Amazon S3 using standard SQL. 2. Athena is…

AWS Redshift @ Freshers.in

Serializable isolation violation on table in Redshift : ERROR: 1023 : Resolved solution

When you run concurrent Amazon Redshift operations in different sessions, there is a probability of getting “ERROR: 1023 DETAIL: Serializable…

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…