Establish Connectivity to Amazon Athena

This article describes how to connect to Athena in order to load data into Datasets and Reports in Metric Insights.

1. Create New Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+ New Data Source] 
  2. Select SQL as a type of new Data Source
  3. [Next Step]

2. Provide Required Parameters

  1. Input a descriptive phrase in Name
  2. Select the desired Auth Type:
    • "Password": input Athena credentials as exemplified above
    • "Identity Profile": select the required Identity Profile from the field that will appear below Auth Type
  3. Enter Data Source Username 
  4. Enter Data Source Password to access the database
  5. Choose "Amazon Athena" from the drop-down
    • The Port number will be set by default, but can be modified.
  6. The JDBC sting must include the AWS Region and s3_staging_dir parameter that specifies the path of the Amazon S3 location where you want to store query results, prefixed by s3://. See the screen above.
  7. [Save]