CODEWITHSUNDEEP
tableau-apiextract
sre
sre

Reputation: 689

Is it possible to programmatically create Custom SQL Tableau extracts that can be published and then refreshed on the server?

Given some Custom SQL, I want to create a Tableau Extract programmatically.

Is this possible?

Context of the process is:

  1. Generate SQL scripts for each extract (100+)
  2. Create the (100+) extracts from Step 1
  3. Publish the Extracts to Tableau Online
  4. Refresh them there on a schedule

Step 2 can be done manually using Tableau Desktop's Custom SQL. As seen here in this help doc, https://help.tableau.com/current/pro/desktop/en-us/customsql.htm

I want to do it (Step 2) programmatically, due to the number of extracts needed and the time it will take.

Upvotes: 0

Views: 392

Answers (2)

Bernardo
Bernardo

Reputation: 3348

Yes, you can programmatically create extracts with the Hyper API. Then you have the option to use either Tabcmd, Tableau REST API or Tableau Server Client Python library to publish the extract. If you go with Python to create the extract, then in the same script, you could use the Server Client to publish. Instead of tableau server refreshing it, you would schedule your script with some sort task scheduler, like in Windows Task Scheduler.

Upvotes: 1

cmcau
cmcau

Reputation: 557

Tableau can do Step 4, you just need to configure it.

Is the problem with steps 1-3 that you have the SQL and just need to automate that part ?

Upvotes: 0

Related Questions