Programmatic Access

Interact Advanced Analytics uses the AWS Data Lake technologies to power the data querying, analysis, and retrieval.

To connect programmatically, you need access to the AWS Athena APIs, which can be achieved either by:

  • ODBC connectivity (eg. write bespoke .NET-based applications and scripts)
  • JDBC connectivity (eg. write bespoke Java-based applications and scripts)
  • AWS SDK (support for many languages and frameworks)

AWS Athena SDK

This is an SDK available in many different languages.

Python

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html

You could use this SDK for Python scripts, Jupyter Notebooks, etc.

.NET

https://docs.aws.amazon.com/sdkfornet/v3/apidocs/
https://docs.aws.amazon.com/sdkfornet/v3/apidocs/items/Athena/TAthenaClient.html

You could use this to write custom analysis in .NET etc.

Other SDKs

Many other AWS Athena SDKs exist and would allow you to connect to Interact Advanced Analytics and write bespoke scripts.