← Go back to our integrations

Privacy with Looker

Transcend automatically fulfills privacy requests in Looker and other major data systems.

Privacy CenterIncoming RequestsData Map1Data Access RequestStatusDetailsAudit TrailMessagesData SilosReportCompiling DataEnriched IdentityWaiting for approvalLookerReadyAmplitudeReadySegmentReadyFacebook AdsReadyGoogle AdsReadySnap AdsReadyAsanaReadyIntercomReadyHelp ScoutReadyMarketoReadyShopifyReadyZendeskReady

Looker is a business intelligence & big data analytics platform.

Transcend can access data in the form of Looker queries (e.g. Looks).

Looking to comply with GDPR and CCPA data subject access and erasure requests (DSRs)?

Documentation

Deleting data in Looker

Transcend allows you to programmatically access data in the form of Looker queries (e.g. Looks) in the Looker platform in accordance with data privacy regulations like GDPR and CCPA.

Setting up the Looker integration

To get started, make sure you're logged in to Transcend. If not, log in to Transcend here. To configure the Looker integration, you'll want to:

  1. Navigate to Data Map > Add data silo > Looker.
  2. To connect the Looker integration, you'll need your subdomain, port, Client Secret and Client ID. To retrieve these, follow the below steps:
  • If your Looker instance is self-hosted, you must provide your domain and (if configured with one) port. If you host a Looker instance at lookerinstance.companyName.com:9090, for instance, your domain is companyName.com:9090. If you do not self-host Looker, leave the default value. The subdomain can be retrieved by logging into your Looker account and inspecting the portion of the url after "https://", and before ".looker.com" (or before your own domain for self-hosted integrations - in the first bullet point, the subdomain is lookerInstance). The Client Secret and Client ID can be retrieved from the users section of the admin dashboard, as described in the following article under the "API3 Keys" section.
  • Create a folder named "Transcend DSR Automation" containing only the queries to be run for data subject requests. Your dedicated Transcend user should have access to only this folder. This security practice ensures that Transcend can only access looks and queries necessary to fulfill data subject requests. For tips on how to manage access to content in Looker, please see this article. To filter a query response for the data subject's email, populate the relevant columns with the following template: {{endUserEmail}}. Here's an example of valid JSON for a query: "filters": { "model.user_email_property_of_your_choosing": "{{endUserEmail}}" }.
  1. Success! Once connected, navigate to the Privacy Center tab. You'll need to map the data in Looker to your Data Practices. To do this, create a new Category as well as a new Data Collection with the appropriate naming convention (e.g. "User Profile"). When you're done, hit publish.
  2. Navigate back to your Data Map and click into the Looker data silo. Expand "Manage Datapoints" and select the Collection Label (Category) you created in the previous step from the dropdown. You can also choose which data actions (e.g. access) are enabled for which datapoints.
  3. Next, while still in the Looker data silo, expand "Manage Identifiers". Check the respective boxes for which identifiers you'd like enabled. As an example, if you'd like Transcend to search users by email address, you'd check the box to enable the Email Address identifier. Note: if identifiers are not enabled correctly, we may not be able to process requests for certain users.
  4. Done!

Testing

We recommend testing requests across your Data Map before you start processing requests from end-users. To do this:

  1. Go to Privacy Center and click "View your Privacy Center".
  2. From your Privacy Center, click Take Control, then Download my data. You'll need to enter your email or login to authenticate yourself before submitting the request.
  3. Check your email for a message from Transcend. You'll be asked to click on a verification link to verify the request. Confirm your download request.
  4. Next, back in the Admin Dashboard, navigate to the Incoming Requests tab and select your request. If you don't see the request here, contact us at support@transcend.io.
  5. Once you've clicked into your request, navigate to the Data Silos tab and select Looker. Inspect the data returned.
  6. Finally, navigate to the Report tab and click Approve and Send. You should receive the report at the email address you submitted with the request.
  7. Done!

Removing the Looker integration

To remove the Looker data silo from your Data Map, navigate to your Data Map, and click into Looker. At the bottom of the screen, expand "Remove Looker". Click Remove Silo. You'll be prompted to confirm that you'd like to remove the silo, click Ok. Confirm the silo has been removed by navigating back to your Data Map.

Want to learn more about the benefits of using Transcend and Looker together? Read more here.