Hi Team,
We are trying to build a detailed dashboard that shows data source–wise field information, including all columns and calculated fields for published data sources on Tableau Server.
From the PostgreSQL repository (workgroup database), we are using the fields table to fetch metadata. However, we observed the following issue:
- Some calculated fields are visible in the fields table
- But many calculated fields are missing / not reflecting
Because of this, we are unable to build a complete dashboard covering all calculated fields across all data sources.
Our Questions:
- Why does the PostgreSQL repository (fields table) not return all calculated fields?
- Are there any limitations or filters in the Tableau repository schema that exclude certain calculated fields?
- Is there any alternative table or approach in PostgreSQL to get all calculated fields?
- If PostgreSQL cannot provide complete metadata, what is the recommended approach to extract all field-level details (including calculated fields)?
#Tableau Server #Tableau #Tableau APIs & Embedding #Tableau Desktop & Web Authoring #Tableau Cloud #Tableau Community Updates
Hi, as Diego said, the official go-to for metadata information is the Tableau MetaData API. For MetaData, the old approach to rely on Postgres schema "recommendations" or "nlp" doesn't work anymore since respectively 2023.1 and 2024.2, as these tables (like nlp.fields) are based on features that have retired.
If you are absolutely focused on Postgres approach only, then you can read the workbook or datasource xml from the Postgres Blobs directly, but that's not supported and at your own risk. Here is an old answer of mine:
https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000kQj0G0AS
Though for lineage you can still use the asset tables like database_assets, table_assets, column_assets, table_asset_sources.
