How to connect Google Data Studio to AWS Athena?

Question

I need to connect Google Data Studio to AWS Athena. One way to do that is with a the JDBC URL connection option. I used the following parameters in the Database Authentication form and I got the error shown below:

Params:

Url

jdbc:awsathena://athena.us-east-2.amazonaws.com:443;UID=[MY_AWS_ACCESS_KEY];PWD=[MY_AWS_SECRET_KEY];S3OutputLocation=s3://[S3_OUTPUT_BUCKET];

Username

[MY_AWS_ACCESS_KEY]

Password

[MY_AWS_SECRET_KEY]

Error:

The server encountered an internal error and was unable to complete your request.

Any solution to connect Google Data Studio to AWS Athena or even connect to AWS S3 should solve this problem. I tried this Google Apps script to connect to S3 but failed to connect with authentication error as shown in this open issue.

Answer 1

An open-source connector for Google Data Studio now exists here.

To use it, you need to follow the instructions detailed here, i.e. copy/paste the code into a Google Apps Script Project and then deploy it to Google Data Studio.

Answer 2

Google Data Studio does not appear to support installing drivers (not that surprising, since it's a hosted, not self-hosted, app).

I think your best bet would be to create a connector -- I actually am surprised no open-source community connector exists yet. I think basically you'd need to wrap the Athena API, following the Google Data Studio connector guide. It's not simple, but it looks doable...