Create prepared statements using the Amazon CLI - Amazon Athena
Use create-prepared-statementUse start-query-execution and the PREPARE syntax
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Create prepared statements using the Amazon CLI

To use the Amazon CLI to create a prepared statement, you can use one of the following athena commands:

  • Use the create-prepared-statement command and provide a query statement that has execution parameters.

  • Use the start-query-execution command and provide a query string that uses the PREPARE syntax.

Use create-prepared-statement

In a create-prepared-statement command, define the query text in the query-statement argument, as in the following example.

aws athena create-prepared-statement 
--statement-name PreparedStatement1 
--query-statement "SELECT * FROM table WHERE x = ?" 
--work-group athena-engine-v2

Use start-query-execution and the PREPARE syntax

Use the start-query-execution command. Put the PREPARE statement in the query-string argument, as in the following example:

aws athena start-query-execution 
--query-string "PREPARE PreparedStatement1 FROM SELECT * FROM table WHERE x = ?" 
--query-execution-context '{"Database": "default"}' 
--result-configuration '{"OutputLocation": "s3://amzn-s3-demo-bucket/..."}'