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.
With the ODBC driver installed, it should be available through the Alteryx interface.
Drag an Input Data component onto the workflow sheet
Click the Connect a File or Database dropdown arrow
Under Data Sources, Select Amazon Athena as data source
It should display the following if Alteryx is able to find the ODBC driver.
Click ODBC Admin
Under System DSN, click Configure...
Fill out the following.
Click Authentication Options...
Pick Authentication Type: IAM Credentials
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.
Click OK, followed by Test... to verify that the connection works.