How to Solve Common Connection Issues for Data Warehouse Sync

Available for User roles All users
Packages Select Lever packages

If you are having trouble connecting to AWS Athena or running into issues copying your data, you may be running into an easy-to-solve problem. 

Common Connection Issues


You may have a corporate firewall that is blocking the connection. In order to bypass this, you will need to open ports and/or protocols in order to fix the issue. Please reach out to your IT team for instructions on how to bypass your firewall.

Poor connectivity

The machine you are using to connect to AWS Athena may have an unstable internet connection. Check your internet connection and try again.

Incorrect credentials

Check that the credentials you entered match the credentials provided to you and try again.

Incorrect or missing information

Ensure that all required parameters are used and entered correctly. This includes setting the "Workgroup" parameter to your account-specific value and setting the "Catalog" parameter to "AwsDataCatalog". 

Tool-specific Issues


If you are connecting to Tableau using JDBC and receive an error message similar to the following:

An error occurred while communicating with Amazon Athena
Invalid username or password.
Error Code: 37CE01A3
[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. User is not authorized to perform: athena:StartQueryExecution on resource: arn:aws:athena:us-west-2:46364624578:workgroup/primary [Execution ID not available]
Invalid username or password.

You will need to customize your connection using a Properties file. Learn how to do that here.

If you are having issues with a specific tool that is not addressed here, please reach out to the providers of that tool for support. They will be best-equipped to help solve your problem. 

Was this article helpful?
0 out of 0 found this helpful