Using AWS CloudFormation Template

Before starting this Amazon Athena workshop, you need to create the required AWS resources. To do this, we provide AWS CloudFormation template to create a stack that contains the resources. When you create the stack, AWS creates a number of resources in your account.
To launch the CloudFormation stack, click on Launch Stack.

NOTE: This template is created for us-east-1 region (N. Virginia) and will not work in other regions. Don't change any of the default Database parameters in cloudformation.

Labs - Athena Basics: The CloudFormation stack will roughly take 5 minutes to complete. The CloudFormation stack will create necessary IAM users, Athena Workgroups and Athena Named Queries for trying out the labs. Check the CloudFormation console and wait for the status CREATE_COMPLETE as shown below: Click on the cloudformation stack and go to outputs tab which will display the S3 bucket name created for this workshop:
Labs - Federated Queries, User Defined Functions, Custom Connector & Machine Learning:
The CloudFormation stack will roughly take 20-30 minutes to complete. The CloudFormation stack will create a sample TPC database running on Amazon RDS, Amazon EMR Cluster with HBase, Amazon Elasticache Redis, Amazon DynamoDB, Glue Database and tables, S3 Bucket, S3 VPC Endpoint, Glue VPC Endpoint, Athena Named Queries, Cloud9 IDE, SageMaker Notebook instance and other IAM resources. Check the CloudFormation console and wait for the status CREATE_COMPLETE as shown below: Once you see the CloudFormation is completed goto EMR console and check the status of step. Wait if it's in Running state for it to complete. To launch EMR go to Services and enter EMR as shown here: Once you launch EMR you should see like this: Click on EMR-Hbase-Cluster. Then click on Steps as shown below to check the status of the step. Wait till it shows completed. Once the stack creation is completed, your AWS account will have all required resources to run this workshop. Capture the S3 lake bucket name, subnets, WorkshopSecurityGroup, EMRSecurityGroup, HbaseConnectionString, RDSConnectionString from the output tab and proceed to the next chapter to run different lab.