AWS provides the petabyte-scale data warehouse as a service in Cloud. It provides us with SQL-like tools to perform business intelligence on virtually any size data. It is quite natural to we use DynamoDB as our application database. We would need to use the data warehouse tools to do analytics. So, in this recipe, we will see how to launch the Redshift cluster and import the DynamoDB data to it.
To perform this recipe, you need to know how to use the DynamoDB console. Also, follow the instructions to install the prerequisites for AWS Redshift from http://docs.aws.amazon.com/redshift/latest/gsg/rs-gsg-prereq.html.
To get started, we will first see how to launch the Redshift cluster, and then use the COPY command to import the DynamoDB data into it:
Go to the AWS Redshift console (https://console.aws.amazon.com/redshift/):
Click on the Launch Cluster button. On the next screen, you will need to enter the details for the cluster...