Collecting data from Amazon Athena

This guide explains how to collect data from Amazon Athena. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

  • Amazon Athena can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

Creating a datastream to collect data from Amazon Athena

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Amazon Athena.

Authorization: Allow Adverity to access Amazon Athena

To set up an authorization to Amazon Athena, follow the instructions in Setting up an authorization to Amazon Athena.

Configuration: Choose the data you want to collect from Amazon Athena

To choose what data to collect and customize the Amazon Athena datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Query Type, select one of the following options:

    • Select Custom to collect data from Amazon Athena using an SQL query. Enter the SQL query in the Query field at the bottom of the page.

    • Select Saved to collect data using a SQL query created within Amazon Athena user interface. Select the query in the Named Query field at the bottom of the page.

  2. In Work Group, select the work group on which to collect data. The list of available work groups is determined by the account used in the authorization to Amazon Athena.

  3. In Amazon S3 Bucket, enter the file path to the S3 bucket from which to collect data. For more information on finding the S3 bucket file path, see the Amazon documentation.

  4. (Optional) In Add Path to Folder, enter the file path to the directory which contains the data to collect.

  5. In Schema Name, enter the name of the table schema to use when collecting data from Amazon Athena. If you leave this field empty, the default table schema is used. For more information on table schema, see the Amazon documentation.

  6. Choose one of the following options:

    • In Query, enter an SQL query. This option is only available if you selected Custom in Query Type.

    • In Named Query, select a saved query created in the Amazon Athena user interface. This option is only available if you selected Saved in Query Type. For more information on creating a Query in Amazon Athena, see the Amazon documentation.

What's next?