tableau / community-tableau-server-insights

Community-built data sources for answering questions about Tableau Server
MIT License
127 stars 52 forks source link

Update data sources to use new projects_contents mapping table #74

Closed mcoles closed 1 year ago

mcoles commented 1 year ago

Determining which piece of content resides in a specific project is done via the project_id column in today's PostgreSQL schema. However, Tableau 2023.1 will change that, relying instead upon the projects_contents table. The database views built around these content tables should be updated to contain the correct mapping, which could be the best way for us to avoid breaking compatibility with older versions of Tableau by explicitly referencing the new table (I've avoided using the views at times in the past due to the fact that I needed columns that were not exposed in those views).

mcoles commented 1 year ago

This is a bigger pain in the butt than I had hoped. Still, prioritizing this work since 23.1 is out now.

mcoles commented 1 year ago

This is resolved with the 04.01 release. I did not implement this as stated; instead we directly joined to the projects_contents table for various reasons. So the 04.01 set is not backwards-compatible with versions of Tableau Server prior to 2023.1 (sorry).