Tag: Database

SQL @ Freshers.in

What are the Aggregate functions in SQL ?

Aggregate functions are the function that is used to compute against a “returned column of numeric data” from your select…

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…