AWS Quick Starts — Customer Ready Solutions

Modern Data Warehouse on AWS

Modernize your EDW capabilities with Tableau Server, Amazon Redshift, Amazon RDS

This Quick Start helps you deploy a modern enterprise data warehouse (EDW) environment that is based on Amazon Redshift and includes the analytics and data visualization capabilities of Tableau Server.

This AWS-validated architecture includes an Amazon Redshift data warehouse, which is an enterprise-class relational database query and management system. Amazon Redshift achieves efficient storage and optimum query performance through massively parallel processing, columnar data storage, and efficient, targeted data compression encoding schemes.

The Quick Start deploys Tableau Server for BI and data visualization capabilities. It includes a sample dataset that's loaded to an Amazon Redshift cluster to support efficient creation of aggregates at large data scale. You can also load your own dataset.

See also: To deploy a Tableau Server standalone or cluster (multi-node) environment on AWS, see the Quick Start for Tableau Server.


This Quick Start was developed by Tableau Software in collaboration with AWS. Tableau is an
APN Partner.

  •  What you'll build
  •  How to deploy
  •  Cost and licenses
  •  Resources
  •  What you'll build
  • The Quick Start architecture for the EDW includes the following infrastructure:

    • A virtual private cloud (VPC) with multiple public and private subnets across multiple Availability Zones, so that AWS resources can be deployed in highly available configurations.
    • In a public subnet, a Linux bastion host in an Auto Scaling group to provide secure access to Linux instances located in the public and private subnets.
    • In a public subnet, a Remote Desktop Gateway instance in an Auto Scaling group to provide secure access to Microsoft Windows instances located in the private and public subnets.
    • In the public subnets, NAT gateways to provide outbound internet connectivity for instances in the private subnets.
    • AWS Identity and Access Management (IAM) roles to enable AWS resources created through the Quick Start to access other AWS resources when required. For example, these IAM roles enable access to data in Amazon S3, enable Amazon Redshift to copy data from Amazon S3 into its tables, and enable association of the generated IAM role with the Amazon Redshift cluster.

    The Quick Start gives you the option to build a new VPC infrastructure with these components or use your existing VPC infrastructure. Within this infrastructure, the Quick Start deploys:

    • Amazon Redshift as the data warehouse. The Quick Start uses Amazon Redshift to provide full fact tables, ad-hoc exploration and aggregation, and filtered drill-downs. Amazon Redshift is optimized for computationally intensive workloads such as computation of aggregates and complex joins, and supports analysis on both Microsoft Windows and macOS.
    • Amazon Simple Storage Service (Amazon S3) to store datasets, dashboards, and SQL queries required to configure AWS database services and to compute aggregates for the sample dataset.
    • A sample dataset, stored in Amazon S3, that demonstrates parallel data load to Amazon Redshift and computation of aggregates at large data scale.
    • Amazon RDS with PostgreSQL, which provides the Quick Start with high-query-volume aggregate tables that feed scale-out dashboards. Amazon RDS is deployed in multiple Availability Zones for high availability.
    • A single-instance deployment of Tableau Server with the ability to host and serve analytics dashboards and workbooks, which is supported by the trial license. The Quick Start also deploys a sample Tableau Server dashboard that demonstrates how to connect to multiple data sources in AWS to optimize performance.
    • A SQL worker instance that is used to coordinate and issue SQL commands, consistent with the sample dataset, to load data in parallel from Amazon S3 to Amazon Redshift, to set up a database link from Amazon RDS to Amazon Redshift, to define the desired aggregate computations in Amazon Redshift, and to publish computed aggregates to Amazon RDS.  



  •  How to deploy
  • You can build your EDW environment in a few simple steps:

    1. If you don't already have an AWS account, sign up at
    2. Launch the Quick Start. Each deployment takes about 50 minutes, plus an additional 20-25 minutes if you choose to load the sample dataset. You can choose from two options:
    3. Log in to Tableau Server, and view the data sources and dashboards.

    The Quick Start includes parameters that you can customize. For example, you can change instance types, specify the number of nodes in the Amazon Redshift cluster, customize the Amazon RDS configuration, and choose to load your own dataset.

    Amazon may share user-deployment information with the AWS Partner that collaborated with AWS on the Quick Start.  

  •  Cost and licenses
  • You are responsible for the cost of the AWS services used while running this Quick Start reference deployment. There is no additional cost for using the Quick Start. See the pricing pages for each AWS service you will be using for cost estimates.

    The AWS CloudFormation templates for this Quick Start include configuration parameters that you can customize. Some of these settings, such as instance type, will affect the cost of deployment. See the pricing pages for each AWS service you will be using for cost estimates.

    You can choose to bring your own Tableau Server license and use it when launching the Quick Start. If you do not have a Tableau Server license or would prefer to launch the Quick Start as a trial, the Quick Start will provide a 14-day Tableau Server evaluation license. At the end of the 14-day trial, you must enter a product key to continue using Tableau Server. For more information about Tableau Server licenses, see the Tableau website.

    To develop reports and dashboards to publish to Tableau Server, you will need Tableau Desktop, which you can license separately from Tableau Server.

  •  Resources
  • This Quick Start reference deployment is related to a solution featured in Solution Space that includes a solution brief, optional consulting offers crafted by AWS Competency Partners, and AWS co-investment in proof-of-concept (PoC) projects. To learn more about these resources, visit Solution Space.