Instead of exporting data manually to Google Sheets, you can add your DataHawk-powered BigQuery database as a data source in your Google Sheets document, 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. Contact us to get your DataHawk-powered BigQuery database set up
  2. Create a Google Sheets file
  3. On the navigation menu, click Data > Data connectors > Connect to BigQuery
  4. Select the BigQuery project that DataHawk created for you
  5. Select the Schema you want so you can access the tables it contains; else, write a SQL query
  6. Select the table you want to load entirely; else, write a SQL query
  7. Click on Connect
  8. Create an Extract

https://demo.arcade.software/km1FjOLRWaL4KiOuIPkj?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 write a SQL query as you get familiar with our datasets.

<aside> 💡

To show data from your DataHawk-powered BigQuery database right in a Google Sheets document, you can either (a) load an entire table without writing any line of code simply by selecting it, or (b) you can write a SQL query.

</aside>

Scheduling Updates

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

We recommend setting up a daily refresh. There’s no need to select a faster frequency as we update data once a day. The fastest frequency you may wanna select is perhaps every 12 hours.

  1. Click Schedule refresh