How do I connect to Data Warehouse Sync using ODBC

In order to connect to your reporting data, you will need to connect to AWS Athena. This can be achieved in one of several ways:

1. Using your business intelligence tool. Your BI tool should have supporting documentation on how to connect.
2. Using an Amazon-provided driver like Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC).
3. Using a third-party tool, such as DBeaver.

This guide walks through how to connect to AWS Athena on Windows using ODBC. If you are interested in learning more about Data Warehouse Sync, check out the overview page.

Configuring your connection to Athena using ODBC

1. Download and install the latest version of the ODBC driver here. You should download the 64-bit version unless you are running an older version of windows and are sure that you need the 32-bit version.
2. Open the ODBC Data Sources utility.
3. Select the "User DSN" tab and click "Add..." 
4. Select "Simba Athena ODBC Driver" and click "Finish" 
5. Add the following details:
   1. Data Source Name: This can be anything you want, but it is recommended that you name is something descriptive, like "Lever Data Warehouse Sync"
   2. AWS Region: This is the AWS region that you are connecting to. Currently, the only available region for DWS is "us-west-2". Refer to the connection sheet you were provided to determine your region.
   3. Workgroup: Refer to the connection sheet you were provided to determine your workgroup. It's usually the same as the name of your Lever instance.
   4. S3 Output Location: Copy and paste the following location exactly, substituting {accountID} with your own Lever accountID. Refer to the connection sheet you were provided to determine your accountID. 

      s3:::services.lever.us-west-2.production.etl/accounts/{accountID}/output/

   5. NOTE: Do not edit any other fields. 
6. Select "Authentication Options..." and set the Authentication Type to "IAM Credentials". Fill in the User and Password using the username and password provided on your connection sheet. 
7. Click "OK" and then click "Test...". If the connection fails, save the error message and send it to Lever Support for further diagnosis. If the connection succeeds, you should see a message similar to this: 
8. Congratulations! You've successfully connected to Lever's Data Warehouse Sync via AWS Athena.

If you are having troubles connecting, check out this article on Common Connection Issues for Data Warehouse Sync.