Redshift is a data warehousing solution provided by Amazon Web Services (AWS). It supports a variety of date and time functions that can be used to perform operations on date and time data stored in Redshift tables. This article is about detailed descriptions and examples of the commonly used Amazon Redshift date functions that you can use to manipulate date data types in Resdshift SQL. In the real word scenarios many application manipulate the date and time data types. Date types are highly formatted and very complicated. Each date value…

Amazon Redshift handles petabytes of data without any resource contention. Redshift support many data types to store data into Redshift table. As of now, you can alter Redshift table to increase the size of varchar column. However, Amazon Redshift does not support alter Redshift table column to a different data type for now. This feature may be added in later release for now we will check the alternative to change redshift table column data type. How to Alter Redshift Table column Data type? Currently, there is no way to change…

Amazon Redshift is a cluster of nodes with separate disks, memory and CPU. Redshift distributes optimally across all the nodes based on the type of distribution you choose on the table or materialized views. In this article, we will learn about amazon redshift distribution types and some of examples. Amazon Redshift Distribution Types There are three distribution types available in the Amazon Redshift; EVEN, KEY, ALL and AUTO. You can choose any methods based on your requirement and type of joining that you are going to perform on the tables.…

Amazon Redshift Architecture is a shared nothing MPP architecture. The architecture is similar to the other MPP data warehouse systems such as Netezza, MS PDW, Greenplum etc. Amazon Redshift is a result of  database integration, processing CPU and storage in a system. Amazon Redshift architecture is depicted in below diagram: SQL Client applications There are many SQL client applications that you can use to connect and query data stored in Amazon Redshift database: SQL Workbench/J: It is a free, open-source SQL client application for Windows, MacOS and Linux. pgAdmin: provides a psql, another…

Redshift analytic functions compute an aggregate value that is based on a group of rows in the tables. A Redshift PostgreSQL analytic function works on the group of rows and ignores the NULL in the data if you specify explicitly in the function. Redshift is basically a data warehouse analytics system and provides many useful functions that can perform day to day aggregations that save lot of times during the development. Usage of Redshift analytic function improves the performance of the query. Frequently used Redshift analytical functions are as follows:…

Redshift SSL Certificates are small data files that digitally bind a cryptographic key to redshift cluster connection details. In this article, we will discuss on Redshift install SSL certificate in local system. Redshift SSL Certificate You have to login to AWS console to download the .pem file. To support SSL connections, Amazon Redshift creates and installs a self-signed SSL certificate on each cluster. To login to cluster, you should have an account created with Amazon AWS cloud. You can obtain the account by yourself or use the corporate account. The public…

Sometimes Amazon Redshift takes hours together to just drop or truncate the tables even if table has very limited rows. In this article, I have put together the steps I usually follow when Amazon Redshift Drop and Truncate Table Running Slow. Amazon has a very fast I/O; it should not take more than second to drop or truncate the tables for any cluster type that you are using. This issue is because there might be more connections with open transactions. Follow below steps: Check for DB locks You can check…