BigQuery is Google Cloud's data warehouse tool that allows businesses to run analytics across a tremendous amount of data using SQL (Structured Query Language).
BigQuery integration is only available on Business and Enterprise plans. Need to upgrade? Read more about our plans and pricing here.
Before using BigQuery with Glide, you'll need to set up a BigQuery account.
Make sure your first column in your data set is a unique string or number column named “id” so Glide can identify the rows.
New to SQL queries? Check out Google's documentation to get started.
Make sure cookies are left on in your personal Glide settings.
Select BigQuery and sign in to the relevant Google account.
Search or browse your datasets and select the one you want to sync with Glide.
In the query screen, run whatever queries you like to create the dataset you want to pull into Glide.
When you're ready, you can name the query and save it as a table.
You can now work with this data for your Glide app.
Unlike our other data integrations, changes you make to BigQuery data in Glide do not write back to your BigQuery data warehouse. Glide uses BigQuery as a read-only data source.
To change your table:
Select edit query in the upper right corner of your query table.
Make any changes to the query you'd like.
Preview your data, then save it to update your table.
There are some features in Glide that aren't compatible with a table generated from BigQuery. Those features are:
In computed columns, filtering, sorted, and search is not supported.
The following components will load at most 5000 rows: