KNOWLEDGE BASE

Error "The request signature we calculated does not match the signature you provided" Connecting to Athena When Server Contains Uppercase Letters


Published: 23 Sep 2022
Last Modified Date: 03 Oct 2022

Issue

When attempting to connect or refresh an Athena extract that uses a server address that contains uppercase letters, the following error occurs: 


TableauException: [JDBC Driver]The request signature we calculated does not match the signature you provided. Check your AWS Secret Access Key and signing method. Consult the service documentation for details. (Service: AmazonAthena; Status Code: 400; Error Code: InvalidSignatureException; Request ID: [...]) System error."

Environment

  • Tableau Cloud
  • Tableau Desktop
  • Amazon Athena

Resolution

Option 1 Change the server (Athena.eu-west-1.amazonaws.com) to start with a lower case letter (athena.eu-west-1.amazonaws.com)

Option 2 Change the server (Athena.eu-west-1.amazonaws.com) to include the region (athena.eu-west-1.amazonaws.com;AwsRegion=eu-west-1;)

Cause

A change on the Athena side requires the server address be in lowercase letters.
Did this article resolve the issue?