AWS Athena - How to Parameterize the SQL query

Question

I want to provide runtime values to the query in Select & Create table statements. What are the ways to parameterize Athena SQL queries? I tried with PREPARE & EXECUTE statements from Presto however it is not working in Athena console. Do we need any external scripts like Python to call it?

PREPARE my_select1
FROM SELECT * from NATION;

EXECUTE my_select1 USING 1;

Answer 1

The SQL and HiveQL Reference documentation does not list PREPARE nor EXECUTE as available commands.

You would need to fully construct your SELECT statement before sending it to Amazon Athena.

Answer 2

You have to upgrade to Athena engine version 2 and now this seems to be supported as of 2021-03-12 but I can't find an official report:

https://docs.aws.amazon.com/athena/latest/ug/querying-with-prepared-statements.html