Changing the Bigquery project in a datasource

[stocksnut]

It would be great to be able to change the Bigquery project in a datasource - to facilitate automation of the publishing from dev - test -prod environments. Basically I have 3 google projects - each with identical datasets and tables - and I would like to change the workbook to change Google projects each time it switches environments. Can I use the tableaudocumentapi to do this? So far I haven't found a way - I don't see the Google project name as an attribute on ConnectionItem. But I wanted to see if anyone else had found a way using the api. Thanks!

[Ninlin]

I have the same question/request, and was not able to figure out a solution yet.

[BramVe]

@stocksnut is this still relevant? Could you provide a dump of the .twb file, specifically the datasource part of the XML tree?

I don't have access to a google project so I'm unable to look into this. Most properties are however easy to adjust in the XML tree.

[florent-guinard]

Hi,

We're also interested in this enhancement: we'd like to update the "Project" field of our Google BigQuery datasources and be sure that the updated datasource is still working properly. Example with a datasource based on the demo/public BigQuery data:

Thanks !