This is a preview release of Integration Connectors with AppSheet. See Track and manage feature releases. Preview offerings are intended for use in test environments only. This feature is not recommended for use in production apps. For questions or assistance with this feature, contact AppSheet Support.
This preview release will roll out gradually over the next week.
Integration Connectors with AppSheet (preview) requires an AppSheet Enterprise Plus account.
AppSheet apps can now connect with external data sources, like BigQuery, using Google Cloud Integration Connectors. This feature uses a service account provided by AppSheet, but you'll need to set up a connection within Integration Connectors first.
Integration Connectors has several pricing plans.
- If you are on an Integration Connectors Subscription plan, there is no additional cost.
- If you are on a Pay-as-you-go plan, the free tier offers 2 connection nodes for Google services, like BigQuery. if you only have one connection, we recommend setting the max connection nodes to 2 to prevent autoscaling. If you have more than one connection or when you add a new one, your standard billing rates will apply.
The following table compares the existing BigQuery connection method with the new BigQuery connector.
|
Feature |
BigQuery data source |
BigQuery using Integration Connectors (private preview) |
|
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. |
No maximum. Note: We recommend using security filters to keep the number of rows returned below 100,000 for performance and to avoid timeouts, especially for tables with many columns. |
|
Subscription plan |
AppSheet Enterprise Plus account as BigQuery connector is considered an advanced connector |
|
|
Initial setup |
Configure BigQuery in Google Cloud and create service accounts and JSON keys. See Use data from Google BigQuery with the BigQuery data source. |
Configure Integration Connector to BigQuery in Google Cloud and grant access to the service account created by the AppSheet team. See Use BigQuery data sources with Integration Connectors. Note: For the private preview release, AppSheet will create the service account on your behalf and then give you the name so you can then grant access. |
|
Security |
AppSheet access to BigQuery is granted to a service account and a key is generated for that service account in the Google Cloud console. The secure key is then manually entered into AppSheet so no passwords or credentials are shared. The key used in AppSheet needs to be updated when the credentials for the service account are rotated. |
Follows best security practices by avoiding user-managed service account keys. AppSheet access to BigQuery is granted directly to a service account and is centralized in the Google Cloud console so service account keys no longer need to be created, manually entered, or refreshed into AppSheet, reducing exposure. |