move-coop / parsons

A python library of connectors for the progressive community.
Other
255 stars 125 forks source link

Remove self.project reference from GoogleBigQuery.get_columns() query #1008

Closed coastlines closed 3 months ago

coastlines commented 4 months ago

The GoogleBigQuery.get_columns() base query from statement references {self.project} which causes an error (below). Removing {self.project} solves this issue and aligns with the format used in other queries in this class, such as get_columns_list.

raise exceptions.DatabaseError(exc)
03/06/2024 10:11:26 AM
google.cloud.bigquery.dbapi.exceptions.DatabaseError: 400 Invalid project ID 'None'. Project IDs must contain 6-63 lowercase letters, digits, or dashes. Some project IDs also include domain name separated by a colon. IDs must start with a letter and may not end with a dash.