I have a BigQuery instance set up with multiple datasets and tables and views. I also have a Data Studio dashboard that is connected to these BQ views. However, every so often Data Studio will give me an error about the missing data and I'll find that the view is no longer in BQ.
I've been able to follow this process to get the view back up quickly, but I cannot find any logs for the delete of that view, so I have no idea how it happened.
Has anyone experienced this before and know how to fix/investigate?
I've tried using the below query to find delete events, but nothing is showing up.
resource.type="bigquery_resource"
protoPayload.methodName="tableservice.delete"
