Tag: Database

Snowflake

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…

Continue Reading What are the Best Practices when using Snowflake Transactions?
Snowflake

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…

Continue Reading Semi-structured Data Types that is supported by Snowflake
Snowflake

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…

Continue Reading Data types supported in Snowflake for managing Dates

Amazon RDS interview questions

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

Continue Reading Amazon RDS interview questions

Amazon Athena interview questions

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

Continue Reading Amazon Athena interview questions
Snowflake

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…

Continue Reading Complete list of System Functions in snowflake
Snowflake

Complete list of Table Functions in snowflake

The complete list of Table Functions in Snowflake are as follows. Table functions are functions that produce a collection of…

Continue Reading Complete list of Table Functions in snowflake
Snowflake

Complete list of Aggregate Functions in snowflake

The complete list of Aggregate Functions in Snowflake are as follows. Aggregate function or aggregation function is a function where…

Continue Reading Complete list of Aggregate Functions in snowflake

Complete list of Scalar Functions in snowflake

The complete list of Scalar Functions in Snowflake are as follows. SCALAR Functions are based on user input. Scalar functions…

Continue Reading Complete list of Scalar Functions in snowflake

Snowflake interview questions

1. What is a Snowflake data warehouse? Snowflake is a data warehouse built on top of the Amazon Web Services…

Continue Reading Snowflake interview questions