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.

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.)
Workgroup specifically can be found on page 104.