Looker

DataCamp's Data Connector 2.0 makes it easy to analyze your data in Looker. All you need to do is set up a connection using the Looker Athena Connector and configure it using the credentials you can retrieve in the Groups tab.

Set up the Athena connector in Looker

First, make sure you have your credentials.

In the Admin section of Looker, select Connections, then Add Connection, and enter the following data:

1. Name: Specify the name of the connection. Free to choose (e.g., DataCamp Data Connector)

2. Dialect: Amazon Athena

3. Host: athena.us-east-1.amazonaws.com

4. Port: 443

5. Database: Specify the default database that you would like modeled

6. Username: The AWS Access Key ID from your credentials

7. Password: The AWS Secret Access Key from your credentials

8. Temp Database: s3://{bucketname}/tmp/looker → replace {bucketname} with the S3 Bucket Name from your credentials

To save these settings, click Connect.

Resources

• Official Looker guide
• Official Amazon Athena Looker documentation