Contents

Cancel

Recommended Articles

  1. unify-apps

    Indexing

    Unify AI

    Transform raw content into searchable knowledge through AI-powered indexing and vector embeddings

  2. unify-apps

    IMAP

    Unify Integrations

    Integrate your app with IMAP to enable seamless email synchronization, real-time access, and enhanced communication workflows.

  3. unify-apps

    Preview Your Work

    Unify Automations

    Effortlessly review & monitor your automation’s performance

  4. unify-apps

    QuickBooks

    Unify Integrations

    Integrate your app with QuickBooks to streamline accounting, automate invoicing, and manage finances effortlessly

  5. unify-apps

    FTP/FTPS

    Unify Integrations

    Connect your app with FTP/FTPS to automate secure file transfers and streamline data exchange across systems.

  6. unify-apps

    Facebook Ads

    Unify Integrations

    Connect your app with Facebook Ads to automate campaign management, optimize ad performance, and track marketing success.

  7. unify-apps

    Snowflake

    Unify Automations

    Connect to Snowflake for fast, scalable cloud data warehousing and analytics

  8. unify-apps

    Button

    Unify Applications

    Create interactive elements with ease using buttons

  9. unify-apps

    BambooHR

    Unify Automations

    Integrate your app with BambooHR to streamline HR management, automate employee data processing, and enhance onboarding workflows

  10. unify-apps

    Build your first automation

    Unify Automations

    Learn how to build your automation step by step

  11. unify-apps

    User Management

    Unify Applications

    Efficiently manage user roles and permissions

  12. unify-apps

    Microsoft Teams

    Unify Automations

    Connect your app with Microsoft Teams to enhance communication, automate workflows, and foster collaboration across your organization

  13. unify-apps

    Jira

    Unify Automations

    Use Jira to plan, track, and manage your agile and software development projects

  14. unify-apps

    Pre Processing

    Unify AI

    Optimize query processing through intelligent rephrasing, retrieval, and ranking to deliver accurate AI responses

  15. unify-apps

    Google Calendar

    Unify Integrations

    Integrate your app with Google Calendar to streamline scheduling, automate event management, and improve team coordination

  16. unify-apps

    SAP HANA

    Unify Integrations

    Connect your app with SAP HANA to leverage in-memory computing for real-time data processing and advanced analytics at scale.

#
Unify Automations
Logo
Amazon Athena

Amazon Athena

Logo

4 mins READ

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

Integrating it with your application enhances data querying efficiency and provides powerful insights from your S3-stored data. 

Authentication

Before you begin, make sure you have the following information:

  • Connection Name: Choose a meaningful name for your connection. This name helps you identify the connection within your application or integration settings. It could be something descriptive like "MyAppAmazonAthenaIntegration."

  • Authentication Type: Select the type of authentication for connecting to your Amazon Athena account:

    • IAM Role

    • Access Key

Access Key-Based Authentication

For Access Key-based authentication, you'll need to perform the following steps to generate access credentials:

  1. Login to the AWS Management Console

  2. Create a new user

    • Search for Users in the top search bar of the AWS Console homepage.

    • Click Create User at the top right corner.

  3. Assign necessary permissions

    • Attach the AmazonAthenaFullAccess and AmazonS3ReadOnlyAccess policies directly to the user. This ensures the user can query Athena and access the necessary S3 data.

  4. Create Access Key

    • Once the user is created, click the username, navigate to the Security credentials section, and click the Create access key.

    • Use "Command Line Interface" as the use case for the access key.

    • Provide a description tag for the key and click Create access key.

  5. Store Access Credentials Securely

    • Store the Access Key and Secret Access Key securely, as they will allow access to your Athena account.

      Image
      Image

IAM Role-Based Authentication

For IAM Role-based authentication, follow these steps to set up an IAM role and grant the necessary permissions for Athena:

  1. Login to AWS Management Console

  2. Create an IAM Role

    • Navigate to the IAM dashboard by searching IAM in the search bar.

    • Select Roles from the left-hand menu, and click on Create role.

  3. Trusted Entity

    • Under the Trusted entity type, choose AWS account.

    • Select Another AWS account and input the UnifyApps AWS account ID (contact UnifyApps support to obtain this).

    • Check the Require external ID box and enter the External ID provided by UnifyApps.

      Image
      Image

  4. Assign Permissions to the Role

    • Attach the AmazonAthenaFullAccess policy to the role. This will allow Athena queries.

    • Attach AmazonS3ReadOnlyAccess if the role needs to query data in S3.

  5. Configure the Role

    • Provide a role name and description, and then click Create role.

Create an IAM permissions policy 

  1. Go to the AWS Console and open the IAM console- https://console.aws.amazon.com/iam

  2. Navigate to Access Management and select Policies.

  3. Choose Create Policy.

  4. Locate and choose the AWS service that UnifyApps will access.

  5. Select the required permissions under the Actions field.

  6. Define the resources that the role will have access to.

  7. Continue clicking Next until you reach the Review policy page.

  8. Provide a Name for the policy.

  9. Click Create policy once done.

Retrieve IAM Role ARN

To retrieve the IAM Role ARN for connecting Athena:

  1. Go to the AWS Console

  2. Locate Role

    • Navigate to Roles and search for the IAM role you created for Athena.

      Image
      Image

  3. Copy the ARN

    • Select the role and copy the Role ARN. This ARN will be used to configure the connection in UnifyApps.

Actions Supported

The following actions are supported in Amazon Athena:

Action

Description

Create Data Catalog

Creates a new data catalogue in Amazon Athena.

Create Work Group

Creates a work group in Athena to manage queries and resources.

Get Database

Retrieves a database object from Amazon Athena.

Get Query Result

Fetches the results of a previously executed query.

List Databases

Lists all available databases in Athena.

Start Query Execution

Runs SQL queries against the data in Amazon S3.

Stop Query Execution

Stops an ongoing query execution in Amazon Athena.