Hi, I am trying to build dashboards for my cloud run using log analytics but I am not able to create any labels which can be further filtered, I couldn't find any example on the internet, could any please provide me an example.
I am trying to do some thing like this with the logs
SELECT timestamp,
JSON_EXTRACT_SCALAR(json_payload, '$.format_parameters.Status') AS status, JSON_EXTRACT_SCALAR(json_payload, '$.format_parameters.StatusCode') AS statusCode, JSON_EXTRACT_SCALAR(parent_scope, '$.accountId') AS accountId,
FROM
`partner-payments-test.global._Default._Default`, UNNEST(JSON_EXTRACT_ARRAY(json_payload, '$.parent_scopes')) AS parent_scope
WHERE
JSON_EXTRACT_SCALAR(json_payload, '$.serviceContext.service') = 'my-service' AND JSON_EXTRACT_SCALAR(parent_scope, '$.accountId') IS NOT NULL AND JSON_EXTRACT_SCALAR(json_payload, '$.format_parameters.Status') IS NOT NULL
ORDER BY timestamp DESC
LIMIT 1000
LinkedIn
Twitter
