Hi,
I am trying to explore a ways to find the database.tablename.fieldname structure for specific fields in tableau cloud.
I was able to fetch the datasource name in which the field is being used by utilizing graphiql but unable to find the database name and tablename from where it is coming from.
Any suggestions/ leads would be highly appreciated.
Thanks in Advance!!
Regards,
Raju
Hi @raju Prasad
To retrieve the database, table, and field names for specific fields in Tableau Cloud, you can utilize the Metadata API's GraphQL interface. By querying the `DatasourceField` object, you can access the `upstreamTables` attribute, which provides information about the tables associated with each field. This approach allows you to map fields to their corresponding tables and databases. For detailed guidance on constructing such queries, refer to the Metadata API documentation. https://www.tableau.com/developer/learning/metadata-api
Best regards,
Olga Ignateva
