To use data from Google BigQuery with AppSheet apps, use one of the following options:

  1. Use the built-in Cloud Database BigQuery data source, as described in Using data from Google BigQuery with the BigQuery data source.

  2. Use the Connected Sheets feature in Sheets to connect to BigQuery, as described in Using 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

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.

Did this answer your question?