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.
Updated almost 4 years ago