fix(bigquery): raise error if bigquery project id cannot be identified

fix(bigquery): raise error if bigquery project id cannot be identified #27692