Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Google Data Clean Room

Hello.
I want to test the Clean Room in the Google Cloud for testing purposes. Unfortunately, I can't get to grips with it. I want to analyse two data sets from different accounts together. I have already created a Clean Room and uploaded the datasets from both accounts. However, I cannot analyse them together. I have tried this via BigQuery but have got nowhere. Does anyone here have a suggested solution or perhaps even a short guide on how the Data Clean Room works? Unfortunately I can't find anything on this.

0 1 289
1 REPLY 1

Hi @Jan2000,

Welcome to Google Cloud Community!

The Data Clean Room(DCR) allows you to creates a secure platform that enables multiple parties to collaborate, merge, and analyze their data assets while keeping the original data protected and unseen.

To resolve the issue with analyzing datasets from different accounts using Google Cloudโ€™s Data Clean Room, you can try this steps:

Confirm Clean Room Configuration:

  • Ensure Correct Setup: Verify that the Clean Room is set up correctly and both datasets are uploaded. Check that the datasets are within the same Clean Room environment and are correctly configured for sharing.
  • Review Sharing Settings: Make sure that the datasets from both accounts are properly shared with the Clean Room and that necessary access permissions are in place.

Verify Query Access:

  • Check Dataset Visibility: In BigQuery, confirm that both datasets from the Clean Room are accessible. You should be able to see and query them within the Clean Room project.
  • Permissions: Ensure you have the required permissions to access and query the datasets. You may need roles such as BigQuery Data Viewer or BigQuery Data Editor.

Troubleshooting:

  • Check Error Messages: If you encounter errors, review the messages and logs for clues. Common issues might include permission errors, incorrect dataset references, or schema mismatches.
  • Consult Documentation: Refer to the Google Cloud Data Clean Room documentation and BigQuery documentation for detailed instructions and troubleshooting tips.

If you continue to experience issues, consider contacting Google Cloud Support for assistance.

I hope the above information is helpful.