New AWS Quick Start Simplifies Data Warehouse Deployments

Amazon Web Services Inc. (AWS) has published a new Quick Start for deploying a modern enterprise data warehouse on it cloud platform.

Developed in cooperation with partners, Quick Starts provide automated reference deployments for key cloud workloads in order to simplify the process of launching, configuring and running projects with the necessary resources for compute, network, storage and other AWS services while followingsecurity and availability best practices.

The new "Modern Data Warehouse on AWS" Quick Start to deploy an enterprise data warehouse (EDW) environment is based on the company's Amazon Redshift service, also incorporating analytics and data visualization capabilities supplied by Tableau Server.

It includes:

  • An Amazon Redshift data warehouse, which is an enterprise-class relational database query and management system.
  • Tableau Server for business intelligence (BI) and data visualization capabilities, and a sample Tableau Server dashboard that demonstrates how to connect to multiple data sources in AWS.
  • A sample dataset that's loaded to an Amazon Redshift cluster to support efficient creation of aggregates at large data scale, and an associated SQL worker instance. Developers can also choose to load their own datasets.
  • Amazon Relational Database Service (Amazon RDS) with PostgreSQL, to provide high-query-volume aggregate tables that feed scale-out dashboards.
Data Warehouse Quick Start Architecture
[Click on image for larger view.] Data Warehouse Quick Start Architecture (source: AWS)

"You can choose to build a new VPC [Amazon Virtual Private Cloud] infrastructure that's configured for security, scalability, and high availability, or use your existing VPC infrastructure for the data warehouse deployment," the company said in a blog post published last Friday. "AWS CloudFormation templates automate the deployment and provide customization options for network resources, instance types, and configuration for Amazon Redshift, PostgreSQL, and Tableau Server. The Quick Start also includes a guide with detailed information and step-by-step instructions."

More information is available in a "Data Warehouse Modernization on the AWS Cloud" PDF.

About the Author

David Ramel is the editor of Visual Studio Magazine.