Creating New Amazon Athena Connections

Arcadia Data supports Amazon Athena data connections for the cloud.

Amazon Athena is a serverless interactive query service that enables you to analyze data in Amazon S3 using standard SQL.

The following steps demonstrate how to create new Amazon Athena data connections.

Create New Data Connection Modal Window: Athena
Create a New Amazon Athena Connection
  1. On the main navigation bar, click Data.

    Click DATA on main navigation bar

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. In the side bar, click New Connection.

    Create New Connection

    The Create New Data Connection modal window appears.

  3. In the Create New Data Connection modal window, under Connection type, select Amazon Athena.
  4. Under Connection name, specify the name of the new connection. Here, we use AmazonAthenaConnection.
  5. Under Region Name, enter the name of the region.

    Here, we used us-east-1.

  6. Under S3 Staging Directory, enter the name of the directory within the S3 bucket, where the data resides.

  7. Under Credentials, complete the following entries.

    • Under Access Key ID, enter the access key.

    • Under Secret Access Key, enter the secret access key.

  8. At the bottom of the modal, click Test.

    testing connection
    Testing the New Connection

    If the connection is valid, the system returns a 'Connection Verified' message.

  9. Click Save.

    connection verified, connecting
    Connecting a Verified Connection

After this operation succeeds, the new connection name appears on the side navigation bar. To customize the connection, see the options available under the Cache tab.

Cache Options

  • Click the Cache tab.

    Cache tab, specifying Result Cache Enable and Retention Time options
    Specifying Cache
  • Select the Result Cache option to enable periodic cache updates.

  • In the Retention Time field, specify the frequency of cache updates, in seconds.

    For example, the default value of 86400 indicates an update every 24 hours, and a value of 300 initiates a refresh every 5 minutes.