derived_table gcp_billing_export creation failed: SQL Error in CREATE TABLE as SELECT: 404 Not Found GET

Sana1
New Member

I’m trying to work with “Cloud Cost Management: Google Cloud” block. The dashboards are failed to load, the database connection is working and the service account on GCP has the right permissions but I don’t know why can’t create derived table


The error: 

Ensure the database connection is working and the modeled syntax is appropriate to the connections SQL dialect.derived_table gcp_billing_export creation failed: SQL Error in CREATE TABLE as SELECT: 404 Not Found GET https://bigquery.googleapis.com/bigquery/v2/projects/mikesky/queries/82b686b4-8a45-4289-9915-415b512418a7?location=us-east4&prettyPrint=false { "code" : 404, "errors" : [ { "domain" : "global", "message" : "Not found: Table mikesky:Looker_Report.gcp_billing_export_public was not found in location us-east4", "reason" : "notFound" } ], "message" : "Not found: Table mikesky:Looker_Report.gcp_billing_export_public was not found in location us-east4", "status" : "NOT_FOUND" }


Anyone have any idea what's happening ?

1 0 293
0 REPLIES 0
Top Labels in this Space