Steps to prepare and connect to Athena

Lightup account setup

  1. Create a new IAM user, and enable Programmatic Access.

    Create a new Athena user account

  2. Select Attach existing policies directly, then Create policy.

    Create a new Athena policy

  3. Use the following template to create the new policy:


Please replace the following template values with your own data.

  • Replace 000000000000 with your own ID.
  • Change any mention of us-west-2 that's incorrect to the AWS region that applies.
  • Replace athena-s3-result-dir with your actual S3 path.
  "Version": "2012-10-17",
  "Statement": [
      "Sid": "VisualEditor0",
      "Effect": "Allow",
      "Action": [
      "Resource": [
      "Sid": "VisualEditor1",
      "Effect": "Allow",
      "Action": [
      "Resource": "*"
      "Effect": "Allow",
      "Action": [
      "Resource": [
      "Effect": "Allow",
      "Action": [
      "Resource": [
  1. Name the policy and attach the policy to the user.

    • Name the policy athena-read-only, then select Create policy.
  • Select the athena-read-only policy, then select Attach existing policies directly.
  1. Finish the Add User dialog.


Workgroup support

Lightup supports Athena workgroups, which can help you manage costs and performance. A workgroup must be in place before you connect to the Athena datasource in Lightup— you can't add a workgroup to an existing datasource.

Connector setting

  • Region - Specify the AWS Region where your data is hosted, e.g. "us-west-2". Read more about Athena Regions.
  • Access Key ID - You'll receive the Access Key ID when you create the new user.
  • Secret Access Key - You'll receive the Secret Access Key when you create the new user.
  • Staging Directory - Enter lightup-athena-staging.
  • Workgroup - If needed, enter a specific Athena workgroup to connect to.

Advanced/Schema scan frequency

You can adjust how often scans run for a datasource.

  • In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.

Query governance

Athena datasources support the Query history, Scheduling, and Enable data storage settings. For steps, see Set query governance settings for a datasource.