How can we create database and table in Amazon Athena using CloudFormation
up vote
1
down vote
favorite
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
amazon-web-services amazon-cloudformation amazon-athena
asked Feb 6 at 11:32
Suresh Kumar
183
add a comment |
up vote
1
down vote
favorite
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
amazon-web-services amazon-cloudformation amazon-athena
asked Feb 6 at 11:32
Suresh Kumar
183
CloudFormation doesn't seem to support this right now. You can always use a custom resource to do it.
– kichik
Feb 8 at 2:05
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
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
amazon-web-services amazon-cloudformation amazon-athena
asked Feb 6 at 11:32
Suresh Kumar
183
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
amazon-web-services amazon-cloudformation amazon-athena
amazon-web-services amazon-cloudformation amazon-athena
asked Feb 6 at 11:32
Suresh Kumar
183
asked Feb 6 at 11:32
Suresh Kumar
183
asked Feb 6 at 11:32
Suresh Kumar
183
asked Feb 6 at 11:32
Suresh Kumar
183
asked Feb 6 at 11:32
Suresh Kumar
183
183
CloudFormation doesn't seem to support this right now. You can always use a custom resource to do it.
– kichik
Feb 8 at 2:05
add a comment |
CloudFormation doesn't seem to support this right now. You can always use a custom resource to do it.
– kichik
Feb 8 at 2:05
CloudFormation doesn't seem to support this right now. You can always use a custom resource to do it.
– kichik
Feb 8 at 2:05
CloudFormation doesn't seem to support this right now. You can always use a custom resource to do it.
– kichik
Feb 8 at 2:05
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
Have you looked here
https://docs.aws.amazon.com/athena/latest/ug/creating-tables.html
Why do you need to create a database and table with Cloudformation in Athena?
answered Feb 7 at 16:51
MonkeyMagic
912
Yes I have looked at it and I have implemented it as well. We are supposed to use CloudFormation and its a requirement for us.
– Suresh Kumar
Feb 8 at 10:41
In that case then you may need to use CloudFormation to create a lambda function that then is triggered to create the table in Athena
– MonkeyMagic
Mar 2 at 15:31
add a comment |
up vote
0
down vote
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
answered Nov 6 at 12:23
ics88
1
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
– Reza Mousavi
Nov 6 at 14:46
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f48642078%2fhow-can-we-create-database-and-table-in-amazon-athena-using-cloudformation%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Have you looked here
https://docs.aws.amazon.com/athena/latest/ug/creating-tables.html
Why do you need to create a database and table with Cloudformation in Athena?
answered Feb 7 at 16:51
MonkeyMagic
912
Yes I have looked at it and I have implemented it as well. We are supposed to use CloudFormation and its a requirement for us.
– Suresh Kumar
Feb 8 at 10:41
In that case then you may need to use CloudFormation to create a lambda function that then is triggered to create the table in Athena
– MonkeyMagic
Mar 2 at 15:31
add a comment |
up vote
0
down vote
Have you looked here
https://docs.aws.amazon.com/athena/latest/ug/creating-tables.html
Why do you need to create a database and table with Cloudformation in Athena?
answered Feb 7 at 16:51
MonkeyMagic
912
Yes I have looked at it and I have implemented it as well. We are supposed to use CloudFormation and its a requirement for us.
– Suresh Kumar
Feb 8 at 10:41
In that case then you may need to use CloudFormation to create a lambda function that then is triggered to create the table in Athena
– MonkeyMagic
Mar 2 at 15:31
add a comment |
up vote
0
down vote
up vote
0
down vote
Have you looked here
https://docs.aws.amazon.com/athena/latest/ug/creating-tables.html
Why do you need to create a database and table with Cloudformation in Athena?
answered Feb 7 at 16:51
MonkeyMagic
912
Have you looked here
https://docs.aws.amazon.com/athena/latest/ug/creating-tables.html
Why do you need to create a database and table with Cloudformation in Athena?
answered Feb 7 at 16:51
MonkeyMagic
912
answered Feb 7 at 16:51
MonkeyMagic
912
answered Feb 7 at 16:51
MonkeyMagic
912
answered Feb 7 at 16:51
MonkeyMagic
912
912
Yes I have looked at it and I have implemented it as well. We are supposed to use CloudFormation and its a requirement for us.
– Suresh Kumar
Feb 8 at 10:41
In that case then you may need to use CloudFormation to create a lambda function that then is triggered to create the table in Athena
– MonkeyMagic
Mar 2 at 15:31
add a comment |
Yes I have looked at it and I have implemented it as well. We are supposed to use CloudFormation and its a requirement for us.
– Suresh Kumar
Feb 8 at 10:41
In that case then you may need to use CloudFormation to create a lambda function that then is triggered to create the table in Athena
– MonkeyMagic
Mar 2 at 15:31
Yes I have looked at it and I have implemented it as well. We are supposed to use CloudFormation and its a requirement for us.
– Suresh Kumar
Feb 8 at 10:41
Yes I have looked at it and I have implemented it as well. We are supposed to use CloudFormation and its a requirement for us.
– Suresh Kumar
Feb 8 at 10:41
In that case then you may need to use CloudFormation to create a lambda function that then is triggered to create the table in Athena
– MonkeyMagic
Mar 2 at 15:31
In that case then you may need to use CloudFormation to create a lambda function that then is triggered to create the table in Athena
– MonkeyMagic
Mar 2 at 15:31
add a comment |
up vote
0
down vote
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
answered Nov 6 at 12:23
ics88
1
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
– Reza Mousavi
Nov 6 at 14:46
add a comment |
up vote
0
down vote
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
answered Nov 6 at 12:23
ics88
1
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
– Reza Mousavi
Nov 6 at 14:46
add a comment |
up vote
0
down vote
up vote
0
down vote
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
answered Nov 6 at 12:23
ics88
1
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
answered Nov 6 at 12:23
ics88
1
answered Nov 6 at 12:23
ics88
1
answered Nov 6 at 12:23
ics88
1
answered Nov 6 at 12:23
ics88
1
1
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
– Reza Mousavi
Nov 6 at 14:46
add a comment |
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
– Reza Mousavi
Nov 6 at 14:46
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
– Reza Mousavi
Nov 6 at 14:46
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
– Reza Mousavi
Nov 6 at 14:46
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f48642078%2fhow-can-we-create-database-and-table-in-amazon-athena-using-cloudformation%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
CloudFormation doesn't seem to support this right now. You can always use a custom resource to do it.
– kichik
Feb 8 at 2:05