How can I execute the saved queries on Athena with Python?

[diegopmayer]

Objective

• Execute or extract data with saved queries on Athena.

Context

• I created a query with AWS Athena and saved that query "saved_query_name", and in Python awaqrangler I want call that query saved, such as wr.read_sql_query(sql="Select col1 from table", database=gold), but using the name such as wr.read_sql_query('saved_query_name") or some like that.

Tries

• Tried execute a wr.athena.get_query_execution('saved_query_name') -> didn't run, cause it needed of id

I couldn't find the solution on documentation.

[jaidisido]

There is a get_named_query boto3 method to retrieve the underlying sql statement, so this could be a enhancement idea. Will raise a PR 👍🏼

[diegopmayer]

Hello @jaidisido, first of all, thanks for your feedback, and I agree with you, in fact I already use the boto3 for that, I just ask for using awswrangler, because I have using, but ok, thanks again.

[jaidisido]

Oh yeah, what I am saying is that we will work to add this in Wrangler