Error message for 'table not found' misleading (BQ)

[colmsnowplow]

Running 0.8.0 against BigQuery. Where there's a mistake in the SQL which references a table that doesn't exist returns an error like:

• googleapi: Error 404: Not found: Job [redacted-project-name]:EU.[redactedHashValue], notFound

I believe this is actually a 'table not found error' but it makes it look like either the job isn't found or some connection error happened.

Not sure if this is a sql-runner problem or if BQ just outputs unhelpful messages.

[chuwy]

My guess is that it is BigQuery's output. Can you confirm/object, @rzats?

[rzats]

It's indeed BigQuery output since the SQL runner is working with the Jobs API rather than anything related to tables. If need be this could be fixed by a health check call to the Tables API, so if a table doesn't exist the runner would fail with a more 'appropriate' error.