SQL to get the sheet/column name dependency



  • Alan Mark

    Hi Trupti,

    In the 6.4 release that your organization is on - the columns are stored in JSON format within the database.  In higher releases we do maintain a separate table to make doing what you are asking here easier.

    The best way to do this in your release is create a Data Link to the dap.sheet table and ingest the record_schema column - which contains the JSON of all the columns.  You can use standard Datameer JSON functions such as JSON_ELEMENT and JSON_VALUE to pull the values you need out for comparison.

    If you have further questions - I'd encourage you to open a case with support.


    Comment actions Permalink
  • Trupti Bhutada

    Thanks Mark. I guess I can use API to get list of columns as well

    Comment actions Permalink

Please sign in to leave a comment.