Data collected by Factbird is stored in Amazon's object storage service, S3, and is made available on request through an ODBC (SQL-like) interface which the built-in Amazon Athena data connector can attach to.

First of, the data of interest needs to be made available to you as a customer, so contact our support at [email protected] and let us know which devices, solutions or the type of data you are interested in.

Currently, we only support internet of things-, IoT-, collected data to be forwarded and made available through this interface.

Requirements

  1. Install ODBC driver available at https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc.html and you can find its corresponding manual at https://s3.amazonaws.com/athena-downloads/drivers/ODBC/SimbaAthenaODBC_1.1.3/Simba+Athena+ODBC+Install+and+Configuration+Guide.pdf
  2. OPTIONAL: If you are behind a proxy, you may need to disable ResultSet streaming after following the Configuration-section.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/76fe64c4-5888-4414-89fb-1e45f476ed53/resultset-streaming.png

Configuration

With the ODBC driver installed, it should be available through the Alteryx interface.

  1. Drag an Input Data component onto the workflow sheet

  2. Click the Connect a File or Database dropdown arrow

  3. Under Data Sources, Select Amazon Athena as data source

    It should display the following if Alteryx is able to find the ODBC driver.

    https://s3-us-west-2.amazonaws.com/secure.notion-static.com/324755e8-ec63-4b86-a452-e469459a782a/Screenshot_2020-10-22_at_19.45.24.png

  4. Click ODBC Admin

  5. Under System DSN, click Configure...

  6. Fill out the following.

  7. Click Authentication Options...

  8. Pick Authentication Type: IAM Credentials

  9. Fill out the following. These are considered sensitive credentials and can be re-generated and revoked on request in case they happen to leak for some reason.

  10. Click OK, followed by Test... to verify that the connection works.