title: How to connect Google Data Studio to AWS Athena?
body: <p>I need to connect <a href="https://datastudio.google.com/" rel="noreferrer">Google Data Studio</a> to <a href="https://aws.amazon.com/athena/" rel="noreferrer">AWS Athena</a>.  One way to do that is with a <a href="https://support.google.com/datastudio/answer/7088031?hl=en&amp;ref_topic=7332343" rel="noreferrer">the JDBC URL connection option</a>.  I used the following parameters in <a href="https://datastudio.google.com/u/0/datasources/create?connectorId=8" rel="noreferrer">the Database Authentication</a> form and  I got the error shown below:</p>
  
  <p>Params:</p>
  
  <p><strong>Url</strong></p>
  
  <pre><code>jdbc:awsathena://athena.us-east-2.amazonaws.com:443;UID=[MY_AWS_ACCESS_KEY];PWD=[MY_AWS_SECRET_KEY];S3OutputLocation=s3://[S3_OUTPUT_BUCKET];
  </code></pre>
  
  <p><strong>Username</strong></p>
  
  <pre><code>[MY_AWS_ACCESS_KEY]
  </code></pre>
  
  <p><strong>Password</strong></p>
  
  <pre><code>[MY_AWS_SECRET_KEY]
  </code></pre>
  
  <p><strong>Error:</strong></p>
  
  <blockquote>
    <p>The server encountered an internal error and was unable to complete your request.</p>
  </blockquote>
  
  <p>Any solution to connect Google Data Studio to AWS Athena or even connect to AWS S3 should solve this problem.  I tried <a href="https://github.com/eschultink/S3-for-Google-Apps-Script" rel="noreferrer">this Google Apps script</a> to connect to S3 but failed to connect with authentication error as shown in <a href="https://github.com/eschultink/S3-for-Google-Apps-Script/issues/1" rel="noreferrer">this open issue</a>.</p>