Tag: Database

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…

Amazon RDS interview questions

1. What is Amazon RDS ? Amazon Relational Database Service (Amazon RDS) is a managed service that makes it easy…

Amazon Athena interview questions

1. What is Amazon Athena? Amazon Athena is an interactive query service that makes it easy to analyze data in…

Complete list of System Functions in snowflake

The complete list of System Functions in Snowflake are as follows. System functions will Control functions that allow you to…