BigQuery Integration

Automating your privacy request fulfillment by integrating Mine PrivacyOps to BigQuery

This integration allows you to automate copy and deletion requests of user data from BigQuery. 

By using this integration, you can define queries that will preview, copy and/or delete user's data from your BigQuery.

Before you start

  • Make sure your Mine PrivacyOps plan supports integrations.

Setting up

To connect the BigQuery integration, follow the steps below:

1. On the left sidebar, click Data Inventory and then Data Sources

2. Click on Add data source

3. Select Google Big Query from the catalog, then enter the Google Big Query page from your data sources list

4. In the RequestHandling tab, check the Handle this data source in privacy requests checkbox and choose the Integration handling style 
5. Click "Connect".

Project Id

Insert your project id

Defining the queries

To manage your DSR handling actions, you need to define the queries that will run in Big Query for each possible action:

Note: The queries you use won't be validated. You should run them in your BigQuery account to make sure they are running as expected

Preview Query

The Preview query will be used when opening the ticket processing screen and is responsible for showing how many records were found as well as showing a sample (preview) of the data.


Example Query:

SELECT name, age, country FROM `dataset.table` WHERE email = {{endUserEmail}} 

* Preview will return the count of the number of records returned in the query response

* Preview will show the first 3 values from the query response, it supports strings and long types

* The variable is mandatory

Copy Query

The Copy query will be used for the Copy action. Copy action is running on the ticket processing page in ticket of type Copy when clicking on Generate Copy

Example Query:

SELECT * FROM `dataset.table` WHERE email = {{endUserEmail}} 

* Copy will show all records returned in the query response

* The variable is mandatory

Delete Query

The Delete query will be used for the Delete action. Delete action is running on the ticket processing page in ticket of type Deletion when clicking on Delete from X sources

Example Query:

DELETE FROM `dataset.table` WHERE email = {{endUserEmail}} 

* The variable is mandatory


Paste the project id and queries in the Request handling tab in the correct inputs and click Save


What's next?

Read more about the deletion process using integrations here.

Read more about the get a copy process using integrations here.

Talk to us if you need any help with Integrations via our chat or at, and we'll be happy to assist!🙂