Search
K

Amazon Athena

Amazon Athena is a serverless, interactive analytics service built on open-source frameworks, supporting open-table and file formats.

Prepare

Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL. Learn more about Athena and how to set it up here.
You will need the following information to create the connection:
  • Amazon Region
  • IAM Key ID
  • IAM Key Secret
  • Database
  • S3 Staging query

Create connections

To create a data connection:
  1. 1.
    Pick connection type.
  2. 2.
    Store credentials.
  3. 3.
    Start or restart the kernel.
There are multiple places you can create data connections:
Notebook
Resource Page
To add a data connection from the notebook:
  1. 1.
    Open the Data Connections panel by clicking on the database icon in the left sidebar.
  2. 2.
    Click on the sign to launch the Create a data connection modal.
  3. 3.
    Select Amazon Athena for the connection type.
  4. 4.
    Provide a Name for the data connection and a description, if desired.
  5. 5.
    Provide your Amazon Region
  6. 6.
    Provide your IAM Key ID
  7. 7.
    Provide your IAM Key Secret
  8. 8.
    Provide your Database name
  9. 9.
    Provide your S3 Staging Directory
  10. 10.
    Choose the connection's Visibility - this cannot be changed later:
    1. 1.
      Private connections can only be seen, managed, or accessed by the user who created the connections, and can be used in any space.
    2. 2.
      Space-level connections can be seen and managed by all users who have Contributor or Owner access for the space but can only be used in notebooks within the designated space.
  11. 11.
    Click Create.
  12. 12.
    Restart the kernel, if prompted.
To add a data connection from the resources page:
  1. 1.
    Click on the Data Connections link in the main sidebar. This sidebar is visible from all space or project pages.
  2. 2.
    Click on the +Create a data connection button to launch the Add data connection modal.
  3. 3.
    Select Amazon Athena for the connection type.
  4. 4.
    Provide a Name for the data connection and a description, if desired.
  5. 5.
    Provide your Amazon Region
  6. 6.
    Provide your IAM Key ID
  7. 7.
    Provide your IAM Key Secret
  8. 8.
    Provide your Database name
  9. 9.
    Provide your S3 Staging Directory
  10. 10.
    Choose the connection's Visibility - this cannot be changed later:
    1. 1.
      Private connections can only be seen, managed, or accessed by the user who created the connections, and can be used in any space.
    2. 2.
      Space-level connections can be seen and managed by all users who have Contributor or Owner access for the space but can only be used in notebooks within the designated space.
  11. 11.
    Click Create.

Use connections

Learn more about how to use SQL cells here.