Menu
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 :
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-template-resource-type-ref.html
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-athena-namedquery.html
476
Use a CREATE TABLE statement to create an Athena table based on the data. Reference the OpenCSVSerDe class after ROW FORMAT SERDE and specify the character separator, quote character, and escape character in WITH SERDEPROPERTIES , as in the following example.
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
50
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
34
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
