How can we create database and table in Amazon Athena using CloudFormation

5
votes

Is there any way to create DataBase and Table in Amazon Athena using CloudFormation. I referred to AWS documentation and there seems to be only one resource which can be created using CloudFormation.

Ref :

2
amazon-web-servicesamazon-cloudformationamazon-athena
CloudFormation doesn't seem to support this right now. You can always use a custom resource to do it. - kichik
Take a look at this answer for a solution: stackoverflow.com/a/50419635/697243 - Pål Brattberg

2 Answers

2
votes

It is now possible to create Athena Table in CloudFormation through the Glue Data Catalog: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-glue-table.html

0
votes

I think its possible with (https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/AWS_Athena.html) AWS::Athena::WorkGroup & AWS::Athena::NamedQuery

**NamesQuery - where you will provide your SQL/DDL to create the table.

Example from AWS

https://athena-in-action.workshop.aws/20-howtostart/201-self-paced/2013-cloudformation.html