Athena (S3 + Glue)

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Uses Athena as the configured warehouse target. In public skippr.yaml, Skippr stores Athena connection and discovery settings here and derives the lower-level skippr-el sink config at runtime.

Configuration

warehouse:
  kind: athena
  workgroup: primary
  region: us-east-1
  result_s3: s3://my-bucket/athena-results/
  schema: raw_data

Field	Default	Description
workgroup		Athena workgroup name
region		AWS region
result_s3		S3 location for Athena query results
schema		Default database or schema for discovery and unqualified queries

CLI

skippr connect warehouse athena \
  --workgroup primary \
  --region us-east-1 \
  --result-s3 s3://my-bucket/athena-results/ \
  --schema my_database

Flag	Description
--workgroup	Athena workgroup name (default: primary)
--region	AWS region
--result-s3	S3 output location for query results (omit to use workgroup default)
--schema	Default database/schema for discovery and unqualified queries

Config output

Running connect warehouse athena writes the public Athena settings into skippr.yaml. Skippr then translates those values into the runtime Athena sink shape when it generates skippr-el.yaml.

warehouse:
  kind: athena
  workgroup: primary
  region: us-east-1
  result_s3: s3://my-bucket/athena-results/
  schema: my_database

Authentication

Authentication uses the AWS default credential chain.

• AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY
• IAM roles, instance profiles, or task roles
• AWS SSO or shared config profiles

Permissions or Network Requirements

The AWS principal needs access to the target S3 bucket, Glue database, and Athena workgroup or result location you configure. The runner must also be able to reach the AWS APIs for the configured region.

Troubleshooting

Symptom	Fix
query or Glue metadata errors	Verify the Glue database name, Athena workgroup settings, and the configured result S3 location.
AccessDenied	Check the AWS credential chain and confirm access to S3, Glue, and Athena resources.

Next steps

• Pair this destination with a source from Source Connectors.
• See Quick Start for the recommended warehouse evaluation paths.

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy