Metadata API: getting started and extracting metadata into a Tableau workbook

[@xavierrocabado3031]

Incredible work man, props

[@devyx]

Thanks, Xavier!

[@sayalipotdar3799]

Nice explanation, really helpful!

[@AliTwaij]

Excellent thnakyou

[@naamahanael3447]

Hey, very nice! but try to understand what is the benefit agianst/above the built in site status?

[@sureshkadiyam5338]

Can we get the Tableau datasource connection details by using graphql ?

[@SivanarulN]

Hi there, Along with database,schema,table names how to get roles and warehouse used for that particular(eg snowflake) database?

[@aravindreddy2495]

hello Devyx, i am trying to get tableau datasources information using the below graphQL query.. { publishedDatasources { id name luid } } i am wondering if there is any paramter i can use to get the location of the data source in the tableau..(more like in which folder the data source is available)..? love how you showcase your hardwork btw🙂

[@Srini-yz8qk]

Its a great video I am trying to get workbook owner name and its throwing error that 'The request exceeded the 20000 node limit' If I take out owner then I am getting all the other info. Please share any advice ?

[@enriquealcoreza2913]

Great video, very helpful! Q: using GraphQL, could I access data on which users are viewing a specific dashboard?

[@devyx]

Hey Enrique, currently the Metadata API doesn't include view counts and usage metrics. However, the internal PostgreSQL database (AKA: Tableau Repository) has some tables and views you might find helpful. For sure the view counts are stored there. Server logs will also have an enormity of information about who clicked what, how long it took to load, etc.

[@xavierrocabado3031]

Wait, you need to purchase de Data Management Add On to access the external assets menu right? Is there a way to access GraphQL without purchasing this license?

[@devyx]

Everything explored in this tutorial has been done without the Data Management Add On. There are some features related to the Metadata API that are exclusive to the DMAO but to query the API via GraphQL, you should be good to go so long as your server is 2019.3+ (or Tableau Online) and you have the REST API and Metadata API enabled in your environment. I recommend giving this documentation a quick read regarding permissions, specifically the paragraph "permissions on metadata": help.tableau.com/current/online/en-us/dm_perms_assets.htm Hope that helps!

[@rachelllll3219]

thanks, but I have a question about how Metadata in workbook and how I can use Metadata API to extract data in data source?

[@rachelllll3219]

I means without GraphQI, how I can use Metadata API in workbook, then classify data source?

[@devyx]

Hey Rachel, I'm not understanding the question. Can you help clarify with an example of what you are aiming for?

[@rachelllll3219]

@@devyx thanks very much. In tables, there are two csv files called"Metadata_APi_xxxx" under the first CSV file, I don't know how I can do it so that create two files.

[@devyx]

@@rachelllll3219 I'm still not clear on the question -- are you asking how to connect two different CSV files (named "Metadata_API_" at the same time in Tableau Desktop? Are you trying to generate two different Metadata API files from the Metadata API output?

[@Jay.05]

Great Content and Thank you for sharing this.. I got 2 clarifications: 1. How can we run it on a specific site since meta data API URL does not have reference on site name and only contain server name. 2. Is there a way we can query all the workbooks referencing a specific database table using metadata API. Thanks again

[@devyx]

Hey Jayakumar, thanks! 1) If using the UI through Tableau Server or Tableau Online to interact with the Metadata API, you will be querying against the site you are currently logged into. You would need to switch sites via the UI to query against a different site. Similarly, if querying the Metadata API via the REST API, your queries will be executed against the site you established a connection with. You would need to sign in or switch sites (both can be done using API endpoints) to query various sites. 2) Yes you can build such a query -- I do not know the exact query you need off the top of my head and I recommend the Tableau community forums if you need help. I would start my GraphQL query at the table level and then query downstream workbooks from there.

[@prashantsrivastava9862]

Hey great video. Can you please guide me how to create a hierarchy from explore page to a particular workbook?

[@devyx]

Hey Prashant, I'm not sure what you mean. If you want a hierarchy in terms of content, you'll want to create a nested project structure. If you have the appropriate permissions (depends on nuances of your environment unless you are a server/site admin) then you can create projects. If you wanted a hierarchy such as: Home >> Dev Area >> Project A >> Workbook X Then your top-level project would be "Home", next would be "Dev Area", next "Project A", and "Workbook X" would be published to the "Project A" project. Hope that helps!

[@prashantsrivastava9862]

@@devyx Can you please guide me with a query by how to go through these in the sequence that you told?

[@devyx]

​@@prashantsrivastava9862 You wouldn't need to query projects in sequence to get information about a specific workbook as you can tap into metadata about workbooks directly. I don't have enough information to give an example query, can you explain your desired outcome?

[@prashantsrivastava9862]

@@devyx is there some way I can contact you? This way I'm unable to completely explain

[@ritika11898]

I don't see this external assets function in my tableau server ,where can i find it? Please help.

[@devyx]

Hey Ritika, talk to your Tableau admins about enabling the Tableau Catalog: help.tableau.com/current/server/en-us/dm_catalog_enable.htm

[@surbhiagrawal5202]

{ "data": null, "errors": [ { "message": "Can't run the query because the Metadata API has not been enabled yet. Run the 'tsm maintenance metadata-services enable' command to enable the Metadata API or contact the Tableau administrator.", "extensions": { "severity": "ERROR", "code": "FEATURE_DISABLED" } } ] } I am getting this error when i am trying on my tableau server

[@devyx]

Hey Surbhi, reading the error message you have shared it appears your environment does not have the Metadata API enabled. If your Tableau admins (or your security team) don't allow the Metadata API, then unfortunately you won't be able to make use of it in your workflows.

[@SivanarulN]

Hi there, Along with database,schema,table names how to get roles and warehouse used for that particular(eg snowflake) database?