To use data from Google BigQuery with AppSheet apps, use one of the following options:
- Use the built-in Cloud Database BigQuery data source, as described in Use data from Google BigQuery with the BigQuery data source.
- Use the Connected Sheets feature in Sheets to connect to BigQuery, as described in Use data from Google BigQuery with Connected Sheets.
The following table provides a comparison on features to help you choose the best option based on your use case:
|
Feature |
BigQuery data source |
Connected Sheets |
|
Maximum number of rows |
100,000 rows plus security filters to select the most relevant rows first Note: In some cases, the provider-specific row limit may be lower than this maximum limit. |
10,000 rows |
|
Subscription plan |
Enterprise-level AppSheet account as BigQuery Connector is considered an Advanced Connector (see details) |
Enterprise-level Google Workspace account (see details) |
|
Initial setup |
Configure BigQuery in Google Cloud (more complex) |
Configure Connected Sheets feature in Sheets (simpler for non-technical users) |
|
Sync time |
App is connected and synced in near real time to the BigQuery dataset providing access to the latest data |
Sheet syncs on a schedule you configure; your app data may become stale between syncs |
Note: If you have a lightweight use case and need to have production support right away, or have a lower license than is required, use BigQuery with Connected Sheets.