BQ get_relations_by_pattern gives Unexpected string literal "table_type" error

[joellabes]

Describe the bug

From the community Slack

Steps to reproduce

Expected results

Not to get an error

Actual results

An error Unexpected string literal "table_type"

Screenshots and log output

System information

The contents of your packages.yml file:

Which database are you using dbt with?

• postgres
• redshift
• bigquery
• snowflake
• other (specify: ____________)

The output of dbt --version:

dbt Cloud 1.0

Additional context

This is my fault - #525 changed this, and the original author called out that quoting the column caused this error. Unfortunately, at the last moment I re-quoted it to avoid a Snowflake issue (#484 (comment))

This can be handled by creating a BQ-specific override that doesn't quote the resulting column.

Are you interested in contributing the fix?

Extremely

[cambalzer]

Thanks @joellabes. Confirming that the two affected models are using that macro: get relations by pattern