Allowing Xplenty access to my Google BigQuery dataset

Connect Xplenty to your BigQuery dataset in order to write data to it, or read data from it. Watch this short video tutorial or read below for textual instructions:


Xplenty uses highly secured certificate-based authentication for connecting to your Google BigQuery Dataset.
You need to grant Xplenty access only to projects and associated datasets that you specifically select.

Project Access

To run Load jobs, grant READ permissions to Xplenty for the relevant BigQuery dataset project container:

  1. Access your Google Cloud Console.
  2. Click the project name for which you want to grant Xplenty access.
  3. On the sidebar, choose IAM
  4. Click +add.
  5. Paste Xplenty's Google Cloud email under NEW MEMBERS:869780223921-fkm5hu2ev8la67tqrntm6b5tjm6c6sgl@developer.gserviceaccount.com
  6. Click Roles drop-down list and choose project-> viewer on the second drop-down list.
  7. Click Add.

Dataset Access

To enable Xplenty to write to a specific dataset, grant WRITE permissions to Xplenty for the relevant BigQuery Dataset:

  1. Access your Google Cloud Console.
  2. Click the project name for which you want to grant Xplenty access.
  3. In the navigation menu, expand Big Data and click BigQuery.
  4. In the new window, verify the project name (to switch projects, click the down arrow next to the project name, then hover on Switch to project and select a different project).
  5. Hover on the dataset, click the down arrow when it appears then click Share dataset.
  6. In the Add people textbox, paste Xplenty's Google Cloud user name:
    869780223921-fkm5hu2ev8la67tqrntm6b5tjm6c6sgl@developer.gserviceaccount.com
  7. In the drop-down menu to the right of the textbox, click Can Edit.
  8. Click Add.
  9. Click Save Changes.

For more information, see Google BigQuery Access Control.

External tables access

In order to read data from external tables that are based on Google Sheets, share the sheets (or a directory containing them) with the service account 869780223921-fkm5hu2ev8la67tqrntm6b5tjm6c6sgl@developer.gserviceaccount.com.

Feedback and Knowledge Base