AWS Athena

Version: 1.1
Updated: Jun 15, 2023

Amazon Athena is a cloud-based service that enables you to run SQL queries on data stored in Amazon S3 without the need to set up any infrastructure. It is a serverless, pay-per-query service that makes it easy to analyze large amounts of data.

• Run Query (Enrichment) - The action runs the SQL query statements contained in the Query and retrieve the results from the query.
• Start Query (Enrichment) - Start a query execution.
• Get Query Execution (Enrichment) - Returns the details of a single query execution or a list of up to 50 query executions.
• Get Query Results (Enrichment) - Streams the results of a single query execution specified by the Query Execution ID.
• Cancel Query (Enrichment) - Stops a query execution.
• List Databases (Enrichment) - Lists the databases in the specified data catalog.
• List Workgroups (Enrichment) - Lists available workgroups for the account.
• List Table Metadata (Enrichment) - Lists the metadata for the tables in the specified data catalog database.

Amazon Athena configuration

To get access key and secret access key, you will need to follow these steps:

1. Sign in to your AWS Management Console.
2. Click on your account name in the top-right corner of the screen and select My Security Credentials from the drop-down menu.
3. Click on the Access keys section in the left-hand menu.
4. Click on the Create New Access Key button.
5. Your new access key and secret access key will be displayed on the screen. Make sure to copy and save them in a secure location as you will not be able to access them again.

Configure Amazon Athena in Automation Service and Cloud SOAR

Before you can use this automation integration, you must configure its authentication settings so that the product you're integrating with can communicate with Sumo Logic. For general guidance, see Configure Authentication for Automation Integrations.

How to open the integration's configuration dialog

1. Access App Central and install the integration. (You can configure at installation, or after installation with the following steps.)
2. Go to the Integrations page.
   Classic UI. In the main Sumo Logic menu, select Automation and then select Integrations in the left nav bar.
   New UI. In the main Sumo Logic menu, select Automation > Integrations. You can also click the Go To... menu at the top of the screen and select Integrations.
3. Select the installed integration.
4. Hover over the resource name and click the Edit button that appears.
   

In the configuration dialog, enter information from the product you're integrating with. When done, click TEST to test the configuration, and click SAVE to save the configuration.

• Label. The desired name for the resource.
• AWS Region. Your AWS region. (Default: us-east-2).
• Access Key ID. Your Access Key ID.
• Secret Access Key. Your Secret Access Key.
  

For configuration information specific to AWS integrations, see the AWS integrations section.

For information about Amazon Athena, see Athena documentation.

External Libraries

• AWS Athena

Change Log

• February 22, 2023 (v1.0) - First upload
• June 15, 2023 (v1.1) - Updated the integration with Environmental Variables