How can I find the Query ID for an Athena Saved Query on AWS console?

After I create a query in Athena using the AWS console, how can I find the Query ID associated with that query?

If I run the query and it fails, I can see the Query ID in the AWS console by going to "Recent Queries" and clicking the "Failed" link next to the query run (https://docs.aws.amazon.com/athena/latest/ug/querying.html), but this doesn't work for queries where the status is "completed".

I can also use the API to first call ListNamedQueries, then iterate through that resulting list of query ids and call GetNamedQuery on each one to see if the name matches the query I'm looking for. But that's a really roundabout process just to get the query id for a query I just created.

Is there another way to simply find a named query's id via the console that I'm not seeing?

トピック

分析

タグ

Amazon Athena

言語

English

AWS-User-8508909

質問済み 2年前1901ビュー

2回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

No, I'm not looking for the Execution Id. That would be the id for a query run. I'm looking for a way to find the NamedQueryId for a Named Query from console.

AWS-User-8508909

回答済み 2年前

Fabrizio@AWS エキスパート
2年前
Thank you for the clarification, could you also let me know how you want to use the Named query ID?

As mentioned the NamedQueryId is different from the QueryId (in the Recent Queries tab for Failed execution query id = execution id).

in the Saved Queries tab, you can see all the Named query in the workspace you are using, that tab shows the Actual Name of the query , the SQL and the description.

the only thing missing is the database and the Named query Id itself, https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html#Athena.Client.get_named_query

Hi ,

based on the documentation link you shared I think that the id you are looking for is the **Execution Id** . If want to check click on the failed query and look at the Query Id you will see it should match the execution id.

hope this helps,

エキスパート

Fabrizio@AWS

回答済み 2年前

How can I find the Query ID for an Athena Saved Query on AWS console?

関連するコンテンツ