Exporting the DynamoDB data to AWS Redshift
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.
Getting ready
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.
How to do it…
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...
