IssueTracker

This will create a feature request which anybody can view and comment on.

Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.

 Client would like to export alert policy data to Looker Studio. They have mentioned that it is enough to have the alert policies list from the UI as a dataset in BigQuery so that it is automatically updated whenever there are any changes to the policies. And they can later extract that data to Looker Studio.

After consulting different documentations [2] [3] [4] I came up with the following script [5] and suggested importing the file.csv to Looker [6]. They have mentioned that it is too much manual labour and they would like to have the list as a bigquery dataset that would update automatically as configurations change on the alert policies.  
 
Kindly assist in creating a feature that would help the client have their alert policy data in BigQuery.  

Other information (workarounds you have tried, documentation consulted, etc):

[2]:  
https://cloud.google.com/sdk/gcloud/reference/alpha/monitoring/policies/list

[3]:  
https://cloud.google.com/sdk/gcloud/reference/topic/formats

[4]:  
https://cloud.google.com/blog/products/management-tools/filtering-and-formatting-fun-with#:~:text=cloud.useraccounts.readonly-,Or%20flatten,-multi%2Dvalues%20to

[5]:  
gcloud alpha monitoring policies list --format="csv(displayName:label=Alert_Name,creationRecord.mutateTime:label=Created_On, mutationRecord.mutateTime:label=Last_Modified_On,mutationRecord.mutatedBy:label=Last_Modified_By,enabled:label=Enabled_Status)" > file.csv

[6]:  
https://support.google.com/looker-studio/answer/7333350?hl=en#zippy=%2Cin-this-article