Instead of exporting data manually to Excel, you can add your DataHawk-powered database as a data source in your Excel file, allowing you to easily get the up-to-date data you need automatically.

Set up

Connecting Datasets

Estimated configuration time of less than<5 minutes.

1. On DataHawk, create a Snowflake destination
2. Download and install ODBC driver for Snowflake - Win64 or Win32 or MacOS latest driver
3. Search for ODBC on your computer to open ODBC Data Source Administrator
4. In the User DSN tab, click Add > SnowflakeDSIIDriver > Finish
5. Enter the credentials you can find in DataHawk for your Snowflake destination in the relevant areas
   1. Give your Data Source any name you want, such as “DataHawk”
   2. Enter the User, Password, Server, Database, and Warehouse details you got from DataHawk
6. On Excel, from the Data tab, click Get Data > From Other Sources > From ODBC then select your data source
7. Re-enter your database User Name and Password
8. Select the tables you want to load

https://demo.arcade.software/seUku6Au9kQjDRVc1SYJ?embed

In case you want to load only partial data - such as a specific time frame, or specific columns - instead of the entire table, or merge data from multiple tables, you can transform it using Power BI Query Editor on Excel, or alternatively write a SQL query, notably as you get familiar with our datasets.

Scheduling Updates

To ensure your file contains the most recent data, you can schedule a refresh.

We recommend setting up a refresh when opening the file, or every 999 minutes if you’ll keep your file open for days. There’s no need to select a faster frequency as we update data once a day, and the max limit you can set on Excel is 999 minutes which is about every 16 hours.

1. Click Data in the navigation menu
2. Click Queries & Connections to open its tab if it wasn’t already open
3. Right-click on a query