athena_cli::commands::query

Function execute

Source 
pub async fn execute(ctx: &Context, args: &QueryArgs) -> Result<()>
Expand description

Executes an Athena SQL query and displays the results.

§Arguments

  • ctx - The application context containing configuration and connection details
  • args - Command line arguments including the SQL query text and reuse time

§Returns

Returns a Result indicating success or failure of the query execution

§Features

  • Configurable query result reuse (caching) duration
  • Displays query statistics including data scanned and cache status
  • Supports pagination for large result sets
  • Returns results as a Polars DataFrame for further processing

§Examples

Basic query example:

athena-cli query "SELECT * FROM my_database.my_table LIMIT 10"

Using result reuse/caching (30 minutes):

athena-cli query --reuse-time 30m "SELECT count(*) FROM my_table"

Query with specific database:

athena-cli -d my_database query "SELECT * FROM my_table WHERE id=123"

Query with custom workgroup and output location:

athena-cli -w my_workgroup --output-location s3://my-bucket/results/ query "SELECT * FROM my_table"