Skip to main content

Home

Amazon Athena (preview only)

Amazon Athena is a serverless query service that enables you to interact with data directly in place on AWS S3 using ANSI standard SQL. You pay only for the queries you run, based on how much data the queries scan. Failed queries cost $0. For cancelled or killed queries, you're charged only for the data that was scanned before the queries were cancelled. For more information on Athena pricing, see Amazon's Athena pricing. Since you’re charged per scan per query, you can use Unravel to show you the cost per Athena query.

Note

This feature is in beta/preview mode. Currently, Unravel UI doesn't display insights and recommendations on Athena queries.

Preview features are in beta and are subject to change. The design and code are less mature than official GA features. They are provided as-is with no warranties. Preview features are not subject to the support SLA of official GA features. We do not recommend you deploy Preview features in a production environment.

This feature is available only in releases that include updates to Unravel's Amazon EMR support, such as 4.5.0.5. See Unravel's ​​Amazon EMR​ compatibility matrix for more information.

Use cases

Amazon Athena is well suited to structured data such as logs.

You send Unravel information about your Athena queries through an AWS Lambda function which monitors your AWS CloudTrail trail for Athena events.

Follow these steps to connect your Athena queries to Unravel through an AWS Lambda function. These steps assume you already have Athena queries set up. In summary, we'll walk you through how to:

  • Create a trail in AWS CloudTrail for management read/write events.

  • Create a new AWS role to allow AWS Lambda functions to call AWS services on your behalf.

  • Create an AWS Lambda function that sends data to Unravel whenever your trail has a new entry.

  • View Athena queries in Unravel UI.

For help with Amazon's Athena, documentation for more help

1. Create a trail in AWS CloudTrail

You can capture Athena activity by creating a specific CloudTrail trail for management read/write events, and specifying a new or existing S3 bucket to store the trail.

Note

Your AWS account must have the following permissions for these steps:

  • AWSCloudTrailReadOnlyAccess

  • CloudtrailFullAccess

  1. Log into your AWS console at https://console.aws.amazon.com.

  2. In the AWS console, select CloudTrail.

  3. On the CloudTrail page, click Trails | Create trail.

  4. In the Trail name field, type Unravel

  5. In the Apply trail to all regions section, select Yes.

  6. In the Management events section, next to Read/Write events, select All.

    aws-cloudtrail-1.png
  7. In the Data events section, don’t make any changes. This trail doesn’t need to log any data events.

  8. In the Storage location section, specify where you want AWS to store your new trail.

    You can create a new S3 bucket or use an existing S3 bucket. If you create a new bucket:

    1. Set the S3 bucket name to unravel-cloudtrail

    2. Expand the Advanced section.

    3. Leave the Log file prefix field blank.

    4. For Encrypt log files with SSE-KMS, select No.

    5. For Enable log file validation, select Yes.

    6. For Send SNS notification for every log file delivery, select No.

    7. Click Create.

  9. Configure CloudWatch permissions on unravel-cloudtrail:

    1. Click your newly created trail, unravel-cloudtrail, and scroll down to CloudWatch Logs.

    2. Click Configure.

      aws-cloudwatch-logs.png
    3. In the New or existing log group field, type CloudTrail/UnravelLogGroup

      aws-cloudwatch-loggroup.png
    4. Click Continue.

    5. On the next page, expand View Details, and specify the following:

      1. IAM Role: Create a new IAM Role.

      2. Role Name: unravel-cloudtrail-role

      3. Click Allow.

        The configuration summary for this trail appears, and in the upper right corner the logging status is displayed.

        aws-cloudtrail-summary.png
2. Create a role for Unravel's AWS Lambda function

Unravel provides an AWS Lambda function to forward your CloudTrail trail to Unravel. To connect Unravel’s AWS Lambda function with your trail, you first need to create an AWS role for Unravel’s Lambda function to use, if you don’t have one already.

For more information on AWS Lambda, see Using AWS Lambda with AWS CloudTrail.

  1. Log into your AWS console at https://console.aws.amazon.com.

  2. In the AWS console, select IAM.

  3. On the IAM page, click Roles.

  4. Click Create role.

  5. In the Select type of trusted entity, choose AWS service.

  6. In the Choose the service that will use this role section, select Lambda.

    aws-iam-new-role.png
  7. Click Next: Permissions.

  8. On the Attach permissions policies page, type each of the following policies into the search box and select the checkbox next to it:

    1. AmazonS3ReadOnlyAccess

    2. AWSLambdaVPCAccessExecutionRole

  9. Click Next: Tags.

  10. (Optional) If you want to add tags to this role, add them here.

  11. Click Next: Review.

  12. On the Review page, set Role name to unravel-athena-lambda-role

    aws-iam-new-role-review.png
  13. Click Create role.

    The AWS console displays a message indicating that it created the role.

    aws-iam-new-role-success.png
  14. Select the role in the list of roles.

  15. On the role summary page, select the Trust relationships tab to verify which trusted entities that can assume this role.

    aws-iam-new-role-trusted.png
3. Create Unravel's AWS Lambda function

This section explains how to create an AWS Lambda function that sends data to Unravel whenever your trail has a new entry.

Note

Your AWS account must have the following permission for these steps:

  • AWSLambdaFullAccess

Define basic settings for the Lambda function
  1. Log into your AWS console at https://console.aws.amazon.com

  2. In the AWS console, select Lambda.

  3. On the Lambda page, click Create function.

  4. On the Create function page, enter the following:

    1. Function name: UnravelAthenaLambda

    2. Runtime: Python 2.7

    3. Execution role: Use an existing role

    4. Existing role: unravel-athena-lambda-role

      aws-lambda-fn-create.png
  5. Click Create function.

    AWS displays a banner indicating success, and displays your new Lambda function’s page.

Add a trigger to the Lambda function
  1. From the list of triggers on the left, select S3.

    aws-lambda-fn-resources.png
  2. In the Configure triggers section, enter the following:

    1. Bucket: unravel-cloudtrail

    2. Event type: All object create events

    3. Select the Enable trigger checkbox.

      aws-lambda-fn-triggers.png
  3. Click Add.

    AWS shows the new S3 trigger at the bottom of the page.

    aws-lambda-fn-trigger-added.png
  4. At the top of the page, click Save.

    aws-lambda-fn-trigger-save.png
Add code to Unravel’s AWS Lambda function
  1. Select the new Lambda function:

    aws-lambda-fn-code.png

    AWS displays configurable settings for this function.

  2. In the Function code section, enter the following:

    1. Code entry type: Upload a file Amazon S3

    2. Amazon S3 link URL: s3://unraveldatarepo/share/lambda/UnravelAthenaLambda.zip

    3. Runtime: Python 2.7

  3. In the Environment variables section, enter the following key-value pair:

    1. Key: unravel_lr_url

    2. Value: http://private-IP-of-Unravel-Node:Port/logs/athena/j-default/athena/athena

      Where: private-IP-of-Unravel-Node is the private IP address of your Unravel Server, and Port is 4043 unless 4043 is already in use (in which case, contact ).

      aws-lambda-fn-environment-vars.png
  4. In the Execution role section, enter the following:

    1. Select Use an existing role.

    2. Existing role: unravel-athena-lambda-role

  5. In the Network section, specify your virtual private cloud (VPC) information:

    Note

    Don’t select No VPC.

    1. Select your VPC.

    2. Select at least two subnets from the pull-down list (hold CTRL to select multiple subnets).

    3. Select your private security group (SG).

    4. Review the inbound and outbound rules.

      aws-lambda-fn-network.png
  6. At the top of the page, click Test.

  7. At the top of the page, click Save.

    AWS displays a banner indicating success.

4. View Athena queries in Unravel UI

In Unravel UI, look at Athena | Apps.

Resources
https://docs.aws.amazon.com/lambda/latest/dg/getting-started-create-function.html
https://docs.aws.amazon.com/lambda/latest/dg/lambda-permissions.html
https://docs.aws.amazon.com/athena/latest/ug/manage-and-monitor.html