Building Data Dictionary /Business Glossary from large Tableau Workbooks

Question

I am trying to build tables from some large Tableau workbooks where the columns would ideally be: Worksheet- the worksheet name **Description **- the description under "sheet description" (ctrl E) that tells a description of the sheet Dashboard- which dashboards the sheets appear on (if none than Nan)

I have used the tableaudocumentapi (https://tableau.github.io/document-api-python/) to get a list of the dashboards and the worksheets but have not been able to map them to each other. Additionally, I have not been able to find descriptions anywhere. Has anyone else tried to do this?

Here is the sample code that I was trying to augment for my purposes, this can be fount on the github page:

############################################################
# Step 1)  Use Datasource object from the Document API
############################################################
from tableaudocumentapi import Workbook
from lxml import etree as ET

############################################################
# Step 2)  Open the .tds we want to explore
############################################################
sourceTWBX = Workbook('geocoding.twbx')

############################################################
# Step 3)  List out info from the TWBX
############################################################
print('----------------------------------------------------------')
print('-- Info for our .twbx:')
print('--   name:\t{0}'.format(sourceTWBX.filename))
print('--   CONTENTS')
print('--   dashboards:\t{0}'.format(len(sourceTWBX.dashboards)))
for dash in sourceTWBX.dashboards:
    print("--      {}".format(dash))

print('--   datasources:\t{0}'.format(len(sourceTWBX.datasources)))
for data in sourceTWBX.datasources:
    print("--      {}".format(data.name))

print('--   worksheets:\t{0}'.format(len(sourceTWBX.worksheets)))
for data in sourceTWBX.worksheets:
    print("--      {}".format(data))

print('--   shapes:\t{0}'.format(len(sourceTWBX.shapes)))
for shape in sourceTWBX.shapes:
    print("--      {}".format(shape))
print('----------------------------------------------------------')

worksheets = sourceTWBX.worksheets
for worksheet in worksheets:
    print("worksheet: {}".format(worksheet))
    for datasource in sourceTWBX.datasources:
        print("-- datasource: {}".format(datasource.name))
        for count, field in enumerate(datasource.fields.values()):
            if worksheet in field.worksheets:
                print(field)

Building Data Dictionary /Business Glossary from large Tableau Workbooks

0 Answers0