![]() ![]() ![]() Fortunately, the Tableau team was very responsive and quickly merged the pull request. Using Port as an example I was able to submit a pull request implementing the functionality. Glancing at the source code I could see that each of the properties of a connection was cleanly defined. After being faced with modifying thousands of workbooks to use query bands I decided to review the library and see if support could be easily added. The first version I used of Tableau’s Document API did not support modifying initial sql & query bands. 4) How does this relate to the TableauDocumentAPI I’ve personally used these features to stage temporary tables & tag each query (there are so many…) that tableau runs. ![]() Taking a step away from TDA for a moment Tableau has two less visible but still immensely useful features: Initial SQL & querybands. import TableauDocumentApi as tdaįor datasource in tableau_workbook.datasources:įor connection in nnections: For example if you needed to update the connection strings in a dozen local tableau files you could use the following script to update them all. TDA is written in Python so using it is as simple as pip install TableauDocumentApi and import TableauDocumentApi. Fortunately with the release of this tool it is now much less risky to modify workbooks without using Tableau Desktop. twb files could easily result in a corrupted workbook. Modifying tableau workbooks without using Tableau Desktop was possible before as tableau files. TDA allows users to easily programmatically modify tableau workbooks. With the release of Tableau 10, Tableau released a python utility called the Tableau Document API (or TDA for short). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |