Add Amazon Athena connector

[luca-martial]

Scope

Build packages/connector-athena/ for introspecting and querying Athena (S3-backed) data via the AWS Glue Data Catalog.

Where to start

• Model on packages/connector-bigquery/ — both are cloud query engines with API-based auth and catalog introspection
• Use @aws-sdk/client-athena for query execution and @aws-sdk/client-glue for catalog metadata
• Auth via the AWS credentials chain (env, instance profile, or assumed role)
• Wire the new driver in packages/context/src/project/driver-schemas.ts
• Add docs in docs-site/content/docs/integrations/primary-sources.mdx

Acceptance criteria

• @kaelio/connector-athena package builds, type-checks, and tests pass
• Catalog introspection lists databases, tables, and column types from Glue
• Read-only query execution via Athena, with workgroup configuration
• Authentication uses the standard AWS credential chain (no hardcoded keys)
• Integration docs added with a connection-config example

Reward

Merging this PR earns the hoodie tier (tier-3). See CONTRIBUTING.md.

Comment on this issue to claim it before starting work.

[d180]

Hey @luca-martial, I would like to work on this issue if it's still available. Thank You.

[luca-martial]

Hey @luca-martial, I would like to work on this issue if it's still available. Thank You.

Go for it! Thanks for showing interest.