datasetID to dataSet tableName mapping in QueryService | Community
Skip to main content
Pradeep-Jaiswal
Pradeep-Jaiswal
Level 5
October 14, 2025
Solved

datasetID to dataSet tableName mapping in QueryService

  • October 14, 2025
  • 2 replies
  • 286 views

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 ?

    Best answer by itsMeTechy

    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.

     

    2 replies

    itsMeTechy
    itsMeTechyAccepted solution
    Level 4
    October 15, 2025

    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
      Devyendar
      Level 6
      October 22, 2025

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

        Terms & ConditionsAccessibility statement

        Loading footer...