CODEWITHSUNDEEP
aws-cloudformationamazon-athena
shantanuo
shantanuo

Reputation: 32326

resource type error while trying to use cloudformation

I tried to use the exact same example provided in the user guide mentioned below. It works from console but fails to create stack using client.

https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-athena-namedquery.html

I got an error while trying to execute the following:

{
  "Resources": {
    "AthenaNamedQuery": {
      "Type": "AWS::Athena::NamedQuery",
      "Properties": {
        "Database": "swfnetadata",
        "Description": "A query that selects all aggregated data",
        "Name": "MostExpensiveWorkflow",
        "QueryString": "SELECT workflowname, AVG(activitytaskstarted) AS AverageWorkflow FROM swfmetadata WHERE year='17' AND GROUP BY workflowname ORDER BY AverageWorkflow DESC LIMIT 10"
      }
    }
  }
}

Is the "create-stack" parameter of cloudformation correct?

aws cloudformation create-stack --stack-name dnd --template-body file://final.json

Why am I getting a resource type error like this?

An error occurred (ValidationError) when calling the CreateStack operation: Template format error: Unrecognized resource types: [AWS::Athena::NamedQuery]

Upvotes: 2

Views: 955

Answers (1)

shantanuo
shantanuo

Reputation: 32326

It worked when I updated my CLI version as suggested in the comment. This issue is now closed.

Upvotes: 3

Related Questions