DEV Community

loading...

Accessing Tableau with Python

digitaldisorder profile image Jakub T ・1 min read

You can find the Tableau SDK Python docs: https://tableau.github.io/server-client-python/docs/

In order to be able to refresh the Datasources you need to get their ids:

import tableauserverclient as TSC


USERNAME = ''
PASSWORD = ''
SITE_ID  = ''


tableau_auth = TSC.TableauAuth(USERNAME, PASSWORD, site_id=SITE_ID)
server = TSC.Server('https://dub01.online.tableau.com')
server.auth.sign_in(tableau_auth)

datasources, _ = server.datasources.get()

tags_to_refresh = {'production'}

# We want to refresh only the datasources with the production tag

datasource_ids = [datasource.id for datasource in datasources if (datasource.tags & tags_to_refresh)]

for datasource_id in datasource_ids:
    item = server.datasources.get_by_id(datasource_id)
    result = server.datasources.refresh(item)
    print(result)

Discussion

pic
Editor guide
Collapse
aza profile image
Aza

Thank you!