CODEWITHSUNDEEP
amazon-web-servicesaws-cloudformationamazon-athena
Suresh Kumar
Suresh Kumar

Reputation: 712

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

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 :

Upvotes: 9

Views: 12125

Answers (2)

Tushar De
Tushar De

Reputation: 419

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

Upvotes: 0

ics88
ics88

Reputation: 61

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

Upvotes: 6

Related Questions