Tableau Tip: Programmatically accessing Favorites

The Tableau REST API does not offer a method for retrieving a user’s Favorites.

However, I learned from Tableau Support that the Tableau internal Postgres database contains this information in the asset_list_items table. Note that Favorites aren’t mentioned anywhere in the documentation.

Here’s a query for my Favorites for a particular site. Join the results to the “workbooks” and “views” tables to get more information on the results.

select *
from asset_list_items ali
join asset_lists al
on ali.asset_list_id =
join _users u on al.owner_id =
join sites s on al.site_id =
where = 'Default'
and = 'eva'