Changing the Bigquery project in a datasource

tableau / document-api-python

Create and modify Tableau workbook and datasource files

https://tableau.github.io/document-api-python/

MIT License

331 stars 177 forks source link

Changing the Bigquery project in a datasource #165

Open stocksnut opened 5 years ago

stocksnut commented 5 years ago

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 commented 5 years ago

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

BramVe commented 4 years ago

@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 commented 2 years ago

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 !