Import your BigQuery data onto Google Sheets using Connected Sheets, then connect it to Geckoboard using our Google Sheets data source.
Open a new file in Sheets.
In the menu at the top, click Data > Data connectors > Connect to BigQuery.
Choose a BigQuery project. If you're unable able to access your project, you'll need to meet these requirements.
Choose a table or view. You can pick from any company table you have access to or from public datasets.
By default, Connected Sheets shows you a preview of 500 rows of raw data in BigQuery. As dashboards typically require a smaller sample of numbers, you might choose to extract a subset of the raw data directly into a new sheet. You can also create functions and column calculations, in addition to automatically refreshing your dataset.
Switch to Geckoboard and connect your sheet using our Google Sheets data source.
Once connected, you're ready to build dashboards widgets from your BigQuery dataset. For guides to creating spreadsheet dashboard widgets, select from the following visualization types:
Calculate new columns in your BigQuery dataset
Create new columns in your dataset that transform or combine other columns. These calculated numbers can then be displayed on your dashboards.
Click Add Calculated Column from the preview sheet.
Use the column on the right to view the available columns and the various functions you can use in your formula.
Give your calculated column a name and write your formula. You can see some example calculated columns by clicking the question mark at the top.
Click Add to see the column added to the preview sheet.
Extract only the numbers you need from your BigQuery dataset
Creating a new sheet specifically to power your dashboard widgets is useful when your source dataset is large. Use the Extract feature to extract smaller tables from a larger BigQuery dataset.
Click on Extract from the preview sheet. By default it will insert the data in a new sheet.
Choose whether to sync all columns from BigQuery or choose the columns you want to import.
Specify any filters and also how you want to sort it.
Set the row limit. Consider how many rows of data you need to build your dashboard widgets.
Hit Apply and this will import the raw data from BigQuery into your sheet.
Schedule automatic refreshes of your BigQuery dataset
By default, all the analysis you do in Connect Sheets remains unchanged until you decide to refresh it – even if that data changes in BigQuery. Set scheduled data refreshes by hour, day, week or month.
Click Refresh options from the preview sheet.
From the refresh options sidebar, click setup now under Scheduled refresh.
Specify a refresh rate and Start date and time.
Click Save to confirm.