Hi team, i'm having an issue with target bigquery as it's trying to create a clustered table with more than 4 columns. It seems that there was a fix for this issue, it can be seen here: https://github.com/jmriego/pipelinewise-target-bigquery I'm using meltano 2.2.0 and wanted to be able to upgrade only the target-bigquery plugin. Is that possible? I've tried to remove and install it again, with the hope that it could install a more recent version, but i'm still facing the same issue. Thanks in advance. (i've raised this issue on another channel https://meltano.slack.com/archives/C01TCRBBJD7/p1668558093785209)

this looks like a fork that has the fix. You can update your pip_url to point to this repo

pip_url: git+<https://github.com/jmriego/pipelinewise-target-bigquery.git>

and then reinstall

@taylor rather than a fork, the

pipelinewise-target-bigquery

repo was moved from the

transferwise

org to the maintainer’s namespace. So we should probably update the plugin’s metadata. That said, overriding the

pip_url

is still the best workaround until the maintainer makes a release. EDIT: asked the dev if they could make a new release https://github.com/jmriego/pipelinewise-target-bigquery/issues/146

Hi guys, thanks for the feedback. I ended up with a workaround where i've created manually the table on bigquery with clustering and after that the etl process executed correctly.

I made an issue to get that updated https://github.com/meltano/hub/issues/1014