save_query_results: Save Query Results to Disk
In hrbrmstr/roto.athena: Perform and Manage 'Amazon' 'Athena' Queries

Description Usage Arguments Details Value References Examples

Downloadsthe results of a single query execution specified by query_execution_id to filename. This request does not execute the query but returns results. Use start_query_execution() to run a query.

1
2
3

save_query_results(query_execution_id, filename, aws_access_key_id = NULL,
  aws_secret_access_key = NULL, aws_session_token = NULL,
  region_name = NULL, profile_name = NULL)

`query_execution_id`	unique ID of the query execution.
`filename`	download location of the athena result
`aws_access_key_id`	AWS access key id
`aws_secret_access_key`	AWS secret access key
`aws_session_token`	AWS session token
`region_name`	region name
`profile_name`	profile name

This is useful for downloading large results where it is undesireable to load the full dataset into memory.

the filename

https://boto3.readthedocs.io/en/latest/reference/services/athena.html#Athena.Client.get_query_results

## Not run: 
start_query_execution(
  query = "SELECT * FROM elb_logs LIMIT 100",
  database = "sampledb",
  output_location = "s3://aws-athena-query-results-redacted",
  profile = "personal"
) -> sqe

# wait a bit

save_query_results(sqe, filename)

## End(Not run)