Athena
SQL over data in S3 — backed by DuckDB when available (set ATHENA_ENGINE=duckdb to require it).
Quick start
import boto3
ath = boto3.client("athena", endpoint_url="http://localhost:4566",
region_name="us-east-1",
aws_access_key_id="test", aws_secret_access_key="test")
q = ath.start_query_execution(QueryString="SELECT 1",
ResultConfiguration={"OutputLocation":"s3://out/"})
print(ath.get_query_results(QueryExecutionId=q["QueryExecutionId"]))
Supported operations
30 operations exposed by this service as of MiniStack 1.3.14. Extracted directly from the handler dispatch in the source module.
BatchGetNamedQuery
BatchGetQueryExecution
CreateDataCatalog
CreateNamedQuery
CreatePreparedStatement
CreateWorkGroup
DeleteDataCatalog
DeleteNamedQuery
DeletePreparedStatement
DeleteWorkGroup
GetDataCatalog
GetNamedQuery
GetPreparedStatement
GetQueryExecution
GetQueryResults
GetTableMetadata
GetWorkGroup
ListDataCatalogs
ListNamedQueries
ListPreparedStatements
ListQueryExecutions
ListTableMetadata
ListTagsForResource
ListWorkGroups
StartQueryExecution
StopQueryExecution
TagResource
UntagResource
UpdateDataCatalog
UpdateWorkGroup
CloudFormation
No CloudFormation resource types map to this service yet. Resources can still be created via the SDK or CLI.
Known limitations
- ATHENA_ENGINE=mock returns empty result sets — use auto or duckdb for real SQL.
- Glue Data Catalog integration is limited; simple CREATE EXTERNAL TABLE usually works.
Source
ministack/services/athena.py:174-234
Read the source to verify the ops list above — dispatch tables and handler functions are the ground truth.