2 of 2 people found this helpful
Try running this query on your postgres
SELECT server, dbclass, username, password, dc.name, dbname,
owner_type as "dc owner type", dc.owner_id as "dc owner id", caption as "dc caption",
dc.keychain as "dc keychain", w.repository_url as "workbook repository url",w.name as "workbook",su.friendly_name,p.name as "project"
FROM data_connections dc
join workbooks w on w.id = dc.owner_id
join projects p on p.id = w.project_id
join system_users su on su.id = w.owner_id
The dbname has the 'source' of the file being referenced and we use this query to list the workbooks with the connections that aren't published data sources on Tableau server.
Awesome! This is what I exactly need! Thanks Donna.
Thanks Aaron. If my answer resolves your issue, please mark it as correct so others can benefit too.