My experience too, GCP is frustrating. However, there is nothing like BigQuery to me, I love that DB.