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.

Connectivity And Security

  1. Allowing Xplenty access to data on Amazon S3
  2. Allowing Xplenty access to my Redshift cluster
  3. Allowing Xplenty access to my data on Google AdWords
  4. Allowing Xplenty access to my data on Google Analytics
  5. Allowing Xplenty access to my Google BigQuery dataset
  6. Allow Xplenty access to my Google Cloud Spanner instance
  7. Allow Xplenty access to my data on Google Cloud Storage
  8. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)
  9. Allowing Xplenty access to my server behind a firewall
  10. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS
  11. Allowing Xplenty access to MongoDB
  12. Importing Heroku Connections
  13. Allowing Xplenty access to my data on Bing Ads
  14. Allowing Xplenty access to Azure SQL Databases
  15. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)
  16. Allowing Xplenty access to Facebook Ads Insights data (Beta)
  17. Allow Xplenty access your data on Salesforce
  18. Allowing Xplenty access to NetSuite
  19. Allowing Xplenty access to my data on Intercom
  20. Set up a reverse SSH tunnel from Windows
  21. Allowing Xplenty access to my data on Xero (Beta)
  22. Allow Xplenty access to my data on Azure Blob Storage
  23. Allowing Xplenty access to my Snowflake account
  24. Allowing Xplenty access to my data on YouTube
  25. Allowing Xplenty access to my data on Google Sheets
  26. Allowing Xplenty access to my data on Linkedin
  27. Allowing Xplenty access to my data on Instagram
  28. Allowing Xplenty access to my data on Shopify
  29. Allowing Xplenty access to my data on Pinterest

Feedback and Knowledge Base