Audit queries against a shared table in Analytics Hub

[gclouddev70]

Hi.

I am using BigQuery Analytics Hub for data sharing. I created a digital clean room and then put a new listing inside it. This listing shares a view which performs a query in one of the tables of my dataset.

I also set up a subscriber for this digital clean room and this subscriber is already able to access and query the shared view. 

My question is if there is any way I, as a publisher, can audit and see the queries being performed by the subscriber against this  shared view. I've searched at Analytics Hub documentation and couldn't find anything. The only way I could figure out was by accessing BigQuery's audit logs.

[jangemmar · Accepted solution]

Hi @gclouddev70,

Welcome to Google Cloud Community!

While Analytics Hub offers a robust security and privacy framework, auditing and identifying queries that are performed by the subscriber against the shared view is not available as of the moment. As a Publisher, you can manage your listing and track the usage metrics of your listing, there are two ways to track your shared data by monitoring your listings.

• The Analytics Hub will give you the usage metrics for your shared data, usage metrics can be retrieved by INFORMATION_SCHEMA.SHARED_DATASET_USAGE
• You can also track how subscribers use your datasets by querying INFORMATION_SCHEMA.SHARED_DATASET_USAGE

You may keep an eye on the release notes for any latest updates or new features related to BigQuery.

I hope the above information is helpful.

[Sidharth_2145]

Hey @jangemmar 

What about the usage metric option under exchange ?

We have options there like total jobs executed, tables job frequency, total bytes scanned. In documentation it’s mentioned we can use these ways to track as well but when my subscriber is running their query I’m unable to track anything under usage metric option only it’s showing subscriber count per organization correctly rest everything is 0 even though we tested multiple times. Any possible issues or concerns? 

Note - we are using cross project sharing under same organization. 

[gclouddev70]

Hi @jangemmar,

Many thanks for your reply. It clarified a lot!