Load Metadata from Amazon Athena

Version:
Current
Last modified: November 18, 2020

Use the Athena Loader to upload metadata to Alteryx Connect from a specified Amazon Athena server.

Review Loader Requirements

The Alteryx Connect Loaders must be installed on the machine where Alteryx Server is installed. To install the loaders:

  1. Download the loaders installer. For compatibility, the Loaders installer version must match the Alteryx Connect version.
  2. Run the installer as an administrator.

Athena must be accessible via ODBC:

  1. Download and install the Athena ODBC driver from the Amazon portal
  2. Configure and test a new DSN in the Windows ODBC Data Sources Administrator. 

If you are unsure about the correct AWS Region, S3 Output Location or Authentication, contact your IT administrator. 

There are strict restrictions for S3 Output Location as described in Bucket restrictions and limitations

Open the Loader

  1. Open Alteryx Designer.
  2. Select Help > Sample Workflows > Alteryx Connect Metadata Loaders > Athena Loader > Athena Loader.

Run the App

  1. Select Run as Analytic App Run as analytic app button.
  2. In the Athena server tab:

    • Type the Athena connection information, including Athena Server (ODBC connection name), Athena Access Key, and Athena Secret.
    • In Databases to load, optionally specify a comma-separated list of databases. Leave blank to load all databases.

  3. In the Alteryx Connect tab, type the URL for your Alteryx Connect instance and your credentials. 
    https://yourcompany.alteryxconnect.com

  4. Before running the app, select Save button and save the app configuration to the following directory: 
    C:\ProgramData\Alteryx\AlteryxConnect\Athena_Loader\

    The .yxwv app values file is used for scheduling the loader to run in the Gallery. See Schedule Metadata Loaders.

  5. Select Finish to run the app.
    • If the run succeeds, "Success" appears in the App Results window.
    • If the run fails, a "There were Errors" message appears.

Depending on how much metadata is being imported, the app can take a long time to run.

View the Metadata

  1. Go to the Alteryx Connect URL and log in.
  2. From the main menu, select Data Sources > Databases.
  3. Select a folder to view its contents.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.