After previously bridging the gap between Sheets and BigQuery - its service for interactive analysis of big datasets -, Google has now announced the ability to refresh BigQuery data by using either macros or Apps Script.
For those not familiar, the integration mentioned in the first sentence allows users to view "up to 10,000 rows" of BigQuery data. The issue that this newest enhancement solves is one related to updating said vast amount of data, if required. More information about the specific permissions can be found on the dedicated support page.
You can of course choose how often the data is updated, either daily, weekly, monthly, or even whenever you open the corresponding Sheets file.
To make use of macros, users need to have the targeted Sheets document open in one tab, but start recording a macro in a different tab. Once the macro is recorded, it can be scheduled via Tools > Script editor > Edit > Current project"s triggers, and then selecting "Add trigger" on the bottom right.
This data refresh capability is on by default, and will be made available for G Suite Business, G Suite Enterprise, G Suite for Education, G Suite Enterprise for Education, and Drive Enterprise, but not G Suite Basic or G Suite for Nonprofits.
As far as when you"ll be able to take advantage of the capability, those on the Rapid Release track will take part in a gradual rollout which started on February 5 - though it can take up to 15 days for the feature to be visible. If you"re on the Scheduled Release track, a full rollout will begin on February 19, with between one to three days before the feature is visible.