Redshift

Redshift NULL Handling Functions-Usage and Examples

A NULL value in a relational database is a special marker used in SQL to indicate that a data value does not exist in the database. In other words, it is just a placeholder to denote values that are missing or that we do not know. Almost all relational databases support functions to handle nulls. In this article, we will check Redshift NULL handling functions, usage and some examples Redshift NULL Handling Functions A NULL functions are used to handle NULL values that you may receive as a part of the data. For example, you can use…

Continue ReadingRedshift NULL Handling Functions-Usage and Examples
Comments Off on Redshift NULL Handling Functions-Usage and Examples
February 23, 2021
Redshift

Redshift Comparison Operators – ALL, SOME, ANY Alternative

The relational database such as Teradata support SQL comparison operators, including ALL, ANY and SOME. Some databases refer ALL, ANY and SOME as a SQL logical operator. A logical operators is an operator applied to the result of a predicate to determine the result of a search condition. Amazon Redshift does not support ALL, ANY and SOME logical operators. In this article, we will check what are ALL, SOME, ANY comparison operators alternatives in Redshift. SQL Logical Operators ALL, SOME and ANY Before jumping into details about alternative approach, let…

Continue ReadingRedshift Comparison Operators – ALL, SOME, ANY Alternative
Comments Off on Redshift Comparison Operators – ALL, SOME, ANY Alternative
February 17, 2021
Redshift

QUALIFY Clause in Redshift – Alternative and Examples

If you are migrating from Teradata to Redshift, you will notice that many features are missing in Amazon Redshift. The feature such as QUALIFY clause is widely used in Teradata. But, the same feature is not available in Redshift. In this article, we will check what is QUALIFY Clause alternative in AWS Redshift. QUALIFY Clause in Redshift The relational databases such as Teradata uses QUALIFY clause to filter the result of ordered analytical function. Amazon Redshift does not support this feature yet. But, when you are migrating Teradata scripts to…

Continue ReadingQUALIFY Clause in Redshift – Alternative and Examples
Comments Off on QUALIFY Clause in Redshift – Alternative and Examples
February 11, 2021
Redshift

What are INSTR Alternative Functions in Redshift?

The INSTR function in relational databases such as Oracle, Teradata, etc. is used to search a string for a substring and find the location of the substring in the string. The Amazon Redshift does not support the INSTR function. However, there are few string functions that you can use. In this article, we will check what are INSTR alternative functions in Redshift. SQL INSTR String Function The SQL INSTR function returns the location of a substring in a string. Optionally, you can provide the starting position and occurrence of the…

Continue ReadingWhat are INSTR Alternative Functions in Redshift?
Comments Off on What are INSTR Alternative Functions in Redshift?
February 11, 2021
Redshift

How to Create an Index in Amazon Redshift Table?

Indexing is a way to optimize the databases. It will reduce the disk I/O when you execute a query to search particular value. Basically, indexing is a data structure technique which you can use to quickly locate and access the data in a database. Many traditional relational databases such as Oracle, SQL Server, etc support indexes. But, being a columnar database, Amazon Redshift does not support indexing on the tables. In this article, we will check alternate approach to create an index in the Amazon Redshift table. How to Create…

Continue ReadingHow to Create an Index in Amazon Redshift Table?
Comments Off on How to Create an Index in Amazon Redshift Table?
November 25, 2020
Redshift

Redshift TO_NUMBER Function and Different Arguments

There are many situations where you need to pre-process the received data in order to store it in the data warehouse. For instance, you many receive currency data with currency symbol. You have pre-process currency column to remove the dollar ($) symbol and store clean value in the database. Amazon Redshift support TO_NUMBER function, you can use it to remove unwanted characters from numeric value. In this article, we will check how to use TO_NUMBER type conversion function with its different format. We will also check different examples to use…

Continue ReadingRedshift TO_NUMBER Function and Different Arguments
Comments Off on Redshift TO_NUMBER Function and Different Arguments
September 21, 2020
Redshift

Redshift Trunc and Date_Trunc Functions, Examples and Differences

Amazon Redshift supports many built-in functions that you can use to perform day to day activities such as extracting only date part from a timestamp value. Redshift provides many date and string functions that you can use to play around date type. In this article, we will check how to use an Amazon Redshift trunc and date_trunc functions, syntax, usage, examples and difference between these two functions. Redshift Trunc and Date_Trunc Functions You can use the trunc and date_trunc functions to trunc certain portions of the date type. However, you…

Continue ReadingRedshift Trunc and Date_Trunc Functions, Examples and Differences
Comments Off on Redshift Trunc and Date_Trunc Functions, Examples and Differences
September 15, 2020
Redshift

Redshift vs Snowflake – Key Differences

Data is the lifeline for many companies. Be it is an advertising company or decision making company, data plays an important role in each and every step. To understand and utilize all this data, data warehouses have become an essential part of modern business. There are many data warehouse appliance such as Teradata, Vertica, Greenplum, etc are available in the market. But, nowadays, organizations are more inclined towards cloud data warehouses such as Snowflake, Redshift, Azure SQL Synapse, Google cloud Spanner, etc. In this article, we will check key differences…

Continue ReadingRedshift vs Snowflake – Key Differences
Comments Off on Redshift vs Snowflake – Key Differences
September 14, 2020
Redshift

Best Amazon Redshift Query Tools – SQL Editors

Similar to Snowflake, Amazon Redshift is a cloud based data warehouse and is a component of Amazon web services (AWS). Amazon Redshift supports both ODBC and JDBC connection. There are many companies released a tool that uses Redshift ODBC or JDBC driver to connect Redshift. In this article, we will check some of best Amazon Redshift query tools or SQL editor that you can use. Best Amazon Redshift Query Tools - SQL Editors Many SQL developers are comfortable with the tools to execute queries and play around data. There are…

Continue ReadingBest Amazon Redshift Query Tools – SQL Editors
Comments Off on Best Amazon Redshift Query Tools – SQL Editors
September 4, 2020
Redshift

UNLOAD Redshift Table to S3 and Local

Amazon Redshift unload command exports the result or table content to one or more text or Apache Parquet files on Amazon S3. It uses Amazon S3 server-side encryption. You can unload the result of an Amazon Redshift query to your Amazon S3 data lake in Apache Parquet, an efficient open columnar storage format for analytics. In this article, we will check how to unload Redshift table to Amazon S3 and later download it to the local system using Amazon AWS command line interface (CLI). Unload Redshift Table Unload command unloads…

Continue ReadingUNLOAD Redshift Table to S3 and Local
Comments Off on UNLOAD Redshift Table to S3 and Local
August 26, 2020