datasetID to dataSet tableName mapping in QueryService

[Pradeep-Jaiswal]

Is there a way using queryService to find the mapping of dataSetIDs and dataSetTableName using queryService ?

I can try getting this from API, but what if its already available in the any of the table that can be accessed via queryService ?

[itsMeTechy · Accepted solution]

Hey Pradeep

there was a system.datasets, which hold this information, but it is no longer available, as it is deprecated.

You can get this mapping using API, or in UI.

But if you have requirement to get it from query service for any automated process, then i can only think of creating a simple table to hold this mapping (should be quick and simple) and use it in query service whenever you need them.

[Devyendar]

You can get the Table Names and Dataset IDs using "SHOW TABLES" command in Query Service.