Create Digital Clean Room listing with analysis rules via BigQuery Analytics Hub API

[gclouddev70]

Hello,

I've been recently playing with BigQuery Analytics Hub API version 1. I was able to  programmatically  create a digital clean room and also add new listings into it by sharing  existing  views and tables. I'm using the Python client SDK for Analytics Hub.

When we create new listings inside a digital clean room using the Analytics Hub GUI console, there are options to set up analysis rules (e.g aggregation threshold policy, list overlap rules, etc) over the view being shared. However, I've searched in the Analytics Hub API documentation and did not see any operation related to setting up analysis rules for clean room listings.

The only way I could think of was applying the analysis rules in advance over the view DDL (by using the BigQuery OPTIONS clause) . Then, once the restricted view is defined,  we  create a new listing sharing this view by the calling createListing() API method.

Is there  a more straightforward way to accomplish this using the Analytics Hub API?

[mpinlac]

Hi @gclouddev70,

Welcome to Google Cloud Community!

As for now there are no direct operations to set up analysis rules in Analytics Hub, but here’s what we can do, for now you can log a feature request for the specific analysis rules that could be implemented in the future.

These are the documents regarding analysis rules:

• Restrict data access using analysis rules
• Share sensitive data with data clean rooms

Here is a sample scenario for a data clean room: Advertiser and publisher attribution analysis

Please note that I can't provide any details or timelines at this moment for the feature request. However, you may keep an eye on the release note for any latest updates or new features related to Analytics Hub API.

I hope the above information is helpful.