Redshift ORDER BY
Redshift ORDER BY is used to sort the output rows in the result set. You can sort the output rows in ascending or descending order.… Read More »Redshift ORDER BY
Redshift SQL
Redshift ALIAS – Column & Table
In SQL, ALIAS means another name given to objects like columns & tables. You can use column and table aliases to make sql query more… Read More »Redshift ALIAS – Column & Table
Redshift Select
In this post, I will show you how you can use SELECT statements in Redshift to query data from tables. SELECT is used to fetch… Read More »Redshift Select
Should you use PARQUET files with Redshift Copy ?
Amazon Redshift supports loading columnar file formats like PARQUET, ORC. This extends compatibility and possibility of moving data easily from different environments for your data… Read More »Should you use PARQUET files with Redshift Copy ?
4 ways to Create Table in Redshift
In the previous post, we saw that you can create table in redshift by specifying 3 minimum details : Table Name, Column Name & Column… Read More »4 ways to Create Table in Redshift
Redshift Copy Command – Load S3 Data into table
In the previous post, we created few tables in Redshift and in this post we will see how to load data present in S3 into… Read More »Redshift Copy Command – Load S3 Data into table
Redshift Create Table Example
In this post, we will see a very simple example in which we will create a Redshift table with basic structure and then we will… Read More »Redshift Create Table Example
