Copying data via Data Warehouse Sync

Available for Roles Super Admin
Permissions • Manage Data Warehouse Sync integration
Packages Advanced Analytics add-on

In order to copy data using Data Warehouse Sync (DWS), you will need to establish a connection to your data via AWS Athena. You can connect to AWS Athena via DBeaver or ODBC. Read more about these options here:

This article guides your through steps to copy your data as well as a walkthrough using PowerBI. Once you have established a connection between DWS and your business intelligence tool (or other data storage unit), you are ready to start copying your data. The specifics of this process will vary depending on your tool or data storage unit, but will generally follow these steps:

  1. Configure your BI tool (or data storage unit) to use the ODBC connection and DSN you set up
  2. Select which tables you want to copy
  3. Execute the copy and store your data
  4. Set up a recurring task to copy data on a regular cadence (optional)

Note that data provided via DWS is refreshed once every 24 hours.

Copying data with PowerBI

  • Ensure that your download will not get throttled by Athena
    • Open PowerBI and navigate to File > Options and settings > Options; click on Data Load under the 'Current File' section
    • Uncheck the option to 'Enable parallel loading of tables' and click OK

Options menu in PowerBI; enable parallel loading of tables chebox outlined

  • Click on Get Data in the 'Home' menu

Get data button outlined in PowerBI toolbar

  • Select the ODBC connector

Get Data modal with ODBC in search bar

  • Select the DSN that you set up earlier (refer to our ODBC help article for more information)

From ODBC modal with Lever Data Warehouse in DSN field

  • Select 'Default or Custom' and click Connect; you may leave the 'Credential connection string properties' field blank; you do not need to enter your credentials again

ODBC driver on Default or Custom page

  • When the information loads, expand the file hierarchy until you expand the list of tables; select the tables you are interested in downloading by ticking the boxes next to the name of the table and click Load

File navigator in PowerBI with expanded file hierarchy

You have executed your first download using Data Warehouse Sync. You can now manipulate the tables and edit table relationships to suit your specific reporting needs as well as build custom views and integrate your Lever data with other data sources.

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