Instead of exporting data manually, you can connect your DataHawk-powered Snowflake database directly to Excel. This gives you automatically refreshed data inside an Excel file using an ODBC connection.

<aside> 💡

Estimated setup time: under 5 minutes.

</aside>

Prerequisite

• Your data sources (Amazon / Walmart accounts) should be connected and collecting data.
  • If you did not connect any data sources, go to ‣
  • ‣ for more context info
• An activated DataHawk-hosted Snowflake database.
  • If you haven't set one up yet, go to ‣
• Once set up, it will take it shows as Enabled (it will take up to 4 hours)
• Retrieve your credentials
  • On your DataHawk App account, Setup > Destinations > Snowflake > See Credentials.

Set up

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

Step 1 — Install the Snowflake ODBC driver

Download and install the Snowflake ODBC driver for your operating system:

• Windows 64-bit
• Windows 32-bit
• macOS

Step 2 — Configure the ODBC data source

1. Search for ODBC on your computer to open the ODBC Data Source Administrator.
2. In the User DSN tab, click Add > SnowflakeDSIIDriver > Finish.
3. Fill in the fields using your DataHawk Snowflake credentials: