Increase Performance When Extracting Large Volumes of Google BigQuery Data

To increase performance when extracting large volumes of data, like 10 million records, use the Staging extract mode. When you extract data using this mode, the connector first stages the data in the specified Google Cloud storage path and then extracts the data from the storage path.

Where: This change applies to Einstein Analytics in Lightning Experience and Salesforce Classic. Einstein Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: To use the staging mode, enter Staging in the Extract Mode connection property. Also enter the bucket name or the bucket name and folder name in the Storage Path property, like <bucket_name> or <bucket_name>/<folder_name>.

Note

To write files to this staging area, the user specified in Client Email must have the list, read, and write permissions on the bucket.

The Extract Mode property appears at the end of the connection properties.

To use the original mode, leave the Extract Mode property blank or enter Direct.