We've added Amazon Athena as a new connection type. Faraday can read Glue-catalogued tables as datasets and write predictions back as tables in the same lake — no extracts, no separate warehouse.

Athena runs in your AWS account, so you keep the data and pay for the query compute. Faraday generates a unique IAM role per connection and assumes a role you create in your account to submit queries; there are no IAM user access keys involved. To set one up you'll need an AWS account ID, a region, the Glue database Faraday should read from and write to, and an S3 prefix for staging.

Targets always fully replace the destination table: Faraday writes CSV to a new prefix under your output location, then updates the Glue table in place, so the table name never disappears. Append and upsert aren't supported.

Via the API, use `POST /connections` with `"type": "athena"`. To get started, see the new [connection guide](/docs/how-to/connections/athena).