Assigned
Status Update
Comments
ma...@google.com <ma...@google.com>
ma...@google.com <ma...@google.com> #2
I have forwarded this request to the engineering team. We will update this issue with any progress updates and a resolution.
Best Regards,
Josh Moyer
Google Cloud Platform Support
Best Regards,
Josh Moyer
Google Cloud Platform Support
Description
Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.
What you would like to accomplish:
- We'd like to make it possible to create alerting policies for BQ DTS configs using their display name filtering by a Regex.
Issue summary:
- Currently, the only unique field in audit logs for Big Query scheduled queries / DTS configs, is the config_id.
- Ideally, the customer would like the display name field to be added to these logs.
- The goal is to be able to configure alerting on a log based metric for errors relating to specific Big Query scheduled queries / DTS configs, filtered by a display name regex.
- Additionally, using a display name regex would allow to create alerting policies for future DTS configs. Considering some teams create several of these, this would be helpful in not needing to repeat the task.
How this might work:
- Adding a display name field that can be queried using Regex to the BQ DTS audit logs.
If applicable, reasons why alternative solutions are not sufficient:
- N/A
Other information (workarounds you have tried, documentation consulted, etc):
At the moment, we can create Log-based metrics for these logs using the config_id, but this would be unique to a DTS config after it is created, and can't help with future scheduled queries which would cause added overhead.