Amazon Redshift is a popular data warehousing solution that is widely used by businesses to…
Tag: Database
Redshift : Learn how to link Amazon redshift to s3 bucket
Amazon Redshift is a fully-managed, petabyte-scale data warehouse service in the cloud. It allows you to run complex analytical queries…
Redshift : Role of VACUUM and ANALYZE in Redshift
Amazon Redshift is a popular data warehousing solution that is widely used by businesses to manage and analyze large volumes…
SQL : How to execute large dynamic query in SQL
There are a few ways to execute large dynamic queries in SQL, but one common method is to use a…
What is DBT and how does it differ from traditional SQL-based ETL tools?
DBT (Data Build Tool) is a command-line tool that helps users write, test, and organize database transformations. It is designed…
How to choose the right database for your service – SQL vs NoSQL – Diagrammatic explanation
Structured data is for tabular datastores. Semi-structured data is for NoSQL. Unstructured data is for Blob Storage. [ We will…
What are the Optimization Techniques that you can apply on Apache Hive ?
1. Partitioning : Partitioning works by dividing the data into smaller segments, These are created using logical grouping based on…
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…