Use data from Google BigQuery with AppSheet

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 Use data from Google BigQuery with the BigQuery data source.
  2. 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.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
7558712099281363899
true
Search Help Center
true
true
true
false
false