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 Using data from Google BigQuery with the BigQuery data source.
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:
BigQuery data source
Maximum number of rows
100,000 rows plus security filters to select the most relevant rows first
Enterprise-level AppSheet account as BigQuery Connector is considered an Advanced Connector (see details)
Enterprise-level Google Workspace account
Configure BigQuery in Google Cloud (more complex)
Configure Connected Sheets feature in Sheets (simpler for non-technical users)
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.