BigQuery Example SA missing BigQuery Connection User Permission

[ryanrezvani]

I installed the BigQuery backend using the provided terraform, however I believe a permission is missing in order to run the back end on the BigQuery side, below is the error I saw:

Fixed by adding roles/bigquery.connectionUser :

resource "google_project_iam_member" "iam_permission_bq_connection_user" {
  project = var.project_id
  role    = "roles/bigquery.connectionUser"
  member  = format("serviceAccount:%s", google_service_account.explore-assistant-bq-sa.email)
}