Looker (JDBC)

Interact Advanced Analytics uses the AWS Data Lake technologies to power the data querying, analysis, and retrieval. To connect Looker to Interact's Advanced Analytics Solution, you will need:

  • Looker
  • AWS Athena JDBC Driver

The setup largely mimics the steps outlined in the JDBC Connectivity page, as this covers the in-depth JDBC configuration steps.

The Looker AWS Athena setup is documented in quite a lot of detail on this page.
https://docs.looker.com/setup-and-management/database-config/amazon-athena

The only thing which is not covered in the Looker AWS Athena documentation is setting the Workgroup setting which is a requirement for Interact Advanced Analytics.

Full documentation on the AWS Athena JDBC Configuration can be found here (including the Workgroup setting.)
https://s3.amazonaws.com/athena-downloads/drivers/JDBC/SimbaAthenaJDBC-2.0.16.1000/docs/Simba+Athena+JDBC+Driver+Install+and+Configuration+Guide.pdf
Workgroup specifically can be found on page 104.