How to join Google App Engine's logging table in BigQuery with Error Reporting-CodePudding

At the moment, I would like to get how many "Acknowledged" errors happen per day. I can get which errors happen per day through the appengine_googleapis_com_request_log_* (e.g.: appengine_googleapis_com_request_log_20211130). However, I don't know how can I get if the error is Acknowledged or Open.

Does anyone know how can I combine those information, or at least if Error Reporting saves its information in any BigQuery table?

CodePudding user response：

Reviewing Google documentation to help with your question, apparently, it is impossible to get the resolution status.

You can view your errors on the Error Reporting page of your GCP Console, which displays a list of all errors in the order of frequency. Errors with the same root cause are grouped together. The error reporting list provides the following information for all reported errors:

Resolution status
Occurrences
Users
Error
Seen in
First seen
Last seen
Response code

In case you would like to have more information, you can review the viewing error documentation.

Now, as I said, there is no way to get the resolution status; however, what you can try to do is a feature request.

Here is some documentation that shows what you can get with the API, it could help you with the feature request.

Additionally, here is a link I found regarding the Error Processing and Log Monitoring documentation using GCP.