there may be multiple ways of going about this via the server interface, or querying the internal PG database, how repeatable do you need to make this? the easiest way may be to signon to the server and look at the tde folders within the dataengine directory.
Ideally, needs to provide an list that is easy to paste into Excel, or text format, showing all the extract names.
Any suggestions? in the PG database, I see historical data, is there a simple list of 'extracts'?
You can use the REST API to query datasources in tableau server and you can also specify the site in which you would like to do this.
It would be a GET request that looks something like this...
In the result, you will find a tag that specifies the datasource-type.
Here's the documentation about this request.
If you are unfamiliar with using the REST API, I would suggest starting with this demo here which uses POSTMAN to make HTTP requests. I find the provided collections really useful.
Hope this helps!
Open Desktop, connect to your Tableau Server db, and use this Custom SQL:
Select * from public.extracts ex inner join public.datasources ds on ex.datasource_id = ds.id
It's a small start.
For more comprehensive info please check this out:
Play with the Custom SQL. Create your own reports. If you get an answer let us know
hi Toby. I was playing with similar SQL, but it seems like this only gets me a list of published datasources and not necessarily the ones embedded within a workbook. Does it get all extracts for you?
from extracts a, datasources b where a.datasource_id is not null
and a.datasource_id = b.id
--and site_id = 1
1 of 1 people found this helpful
Select * from public.extracts ex left join public.datasources ds on ex.datasource_id = ds.id left join public.workbooks wb on ex.workbook_id = wb.id
I'm pretty sure that will get you both.
I created a simple workbook that may be helpful (see attached). Here's how I did it:
I used the "readonly" account to access Tableau's postgres database. I then joined the extracts and datasources tables via Datasource ID. Next, drag the following dimensions to the Rows shelf: data engine extracts, Db name, Name. I also dragged "dataengine extracts" to the filters pane and selected "true" to show only datasources that has an extract.Change marks color to white to hide the useless "abc" place holder quickly. You can export to excel by going to Worksheet > Export > Crosstab to Excel.
Hope this helps!
extract info.twbx 54.5 KB
Just a sneak peak that in a near-future release, you can use the REST API to get a list of schedules on server, and extract refresh tasks associated with them . Will this solve your use case?