> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Connecting to Amazon Athena

> Connect Amazon Athena to Integrate.io ETL for querying data. Configure IAM access credentials, S3 output location, and connection settings.

## To allow Integrate.io ETL access to Amazon Athena

* [Create an IAM user in AWS](https://docs.aws.amazon.com/IAM/latest/UserGuide/id_users_create.html#id_users_create_console).
* Attach the `AmazonAthenaFullAccess` policy to the user.
* Create security credentials for the user and save them for later use when defining the connection in Integrate.io ETL.

## To define a connection in Integrate.io ETL to Amazon Athena

<Steps>
  <Step>
    Click the Connections icon (lightning bolt) on the top left menu.
  </Step>

  <Step>
    To create a connection, click **New connection**.

    <Frame>
      <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-93.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=9f6ce9175f3d9d7853de85f365f433a0" alt="New connection button in the Connections menu" width="1200" height="829" data-path="images/connectivity-and-security/image-93.webp" />
    </Frame>
  </Step>

  <Step>
    Select [**Amazon Athena**](https://www.integrate.io/blog/amazon-athena/) and name the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-94.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=f9c3597717e06042e21a5e5b1eb4216c" alt="Selecting Amazon Athena from the connection type list" width="1200" height="829" data-path="images/connectivity-and-security/image-94.webp" />
    </Frame>
  </Step>

  <Step>
    Select AWS region.
  </Step>

  <Step>
    Type in the S3 staging directory to use with Athena in the form `s3://bucket/path`. Note that the bucket should be in the same region you selected above.
  </Step>

  <Step>
    Enter the default database to use. If you leave it empty, the user's default database will be used.
  </Step>

  <Step>
    Fill out the IAM access key and secret.
  </Step>

  <Step>
    Click **Test connection**. If the credentials are correct, a message that the connection test was successful appears.
  </Step>

  <Step>
    Click **Create connection**.

    <Frame>
      <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-95.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=0151e66e55bb2c9aaf75a5796e39e9b4" alt="Amazon Athena connection form with region, S3 path, and credentials" width="1200" height="829" data-path="images/connectivity-and-security/image-95.webp" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-96.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=70fb66a7daefd6d1fa91ecf77471b665" alt="Amazon Athena connection created successfully" width="1200" height="829" data-path="images/connectivity-and-security/image-96.webp" />
    </Frame>
  </Step>
</Steps>