Team, I m trying to add column level description f...
# troubleshoot
a
Team, I m trying to add column level description for a particular table and i m using post request for it
Copy code
mutation {
    updateDescription(
      input: {
        description:"testing description for mssql"
        resourceUrn: "urn:li:dataset:(urn:li:dataset:(urn:li:dataPlatform:glue,sam.testpipelinedata,PROD)",
        subResourceType:DATASET_FIELD,
        subResource:"serialnumber"
        
        
        })
}

but the post request is throwing an error of 
{
    "errors": [
        {
            "message": "An unknown error occurred.",
            "locations": [
                {
                    "line": 2,
                    "column": 5
                }
            ],
            "path": [
                "updateDescription"
            ],
            "extensions": {
                "code": 500,
                "type": "SERVER_ERROR",
                "classification": "DataFetchingException"
            }
        }
    ],
    "data": {
        "updateDescription": null
    },
    "extensions": {}
}

same error when i m adding tags in column level. But when i add tags to the table then it is working fine.
πŸ“– 1
πŸ” 1
l
Hey there πŸ‘‹ I'm The DataHub Community Support bot. I'm here to help make sure the community can best support you with your request. Let's double check a few things first: βœ… There's a lot of good information on our docs site: www.datahubproject.io/docs, Have you searched there for a solution? βœ… button βœ… It's not uncommon that someone has run into your exact problem before in the community. Have you searched Slack for similar issues? βœ… button Did you find a solution to your issue? ❌ Sorry you weren't able to find a solution. I'm sending you some tips on info you can provide to help the community troubleshoot. Whenever you feel your issue is solved, please react βœ… to your original message to let us know!
d
Hello Sam, could you confirm the urn and the column name is correct? (you can copy the exact urn using "Share > Copy URN") also, could you try something like this?
Copy code
mutation updatedescription {
    updateDescription(
      input: {
        description:"testing description for mssql",
        resourceUrn: "urn:li:dataset:(urn:li:dataPlatform:hive,sam.testpipelinedata,PROD)",
        subResourceType:DATASET_FIELD,
        subResource:"serialnumber"    
        }
    )
cf : https://datahubproject.io/docs/api/tutorials/modifying-dataset-descriptions/#add-description-on-column
a
yes the urn is correct. I'm able to add tags to this urn using addTag. But when I'm mentioning subresourcetype and subresource it's throwing this error.
d
okay that’s strange, can you please confirm a few other things? : β€’ the column name is correct? (it’s case-sensetive) β€’ what version of datahub are you using? could you try again with the latest version?)
a
and in properties it shows this spark.sql.sources.schema {"type":"struct","fields":[{"name":"pk","type":"string","nullable":true,"metadata":{}},{"name":"LastModifiedDate","type":"string","nullable":true,"metadata":{}},{"name":"changeType","type":"string","nullable":true,"metadata":{}},{"name":"commitUser","type":"string","nullable":true,"metadata":{}},{"name":"commitNumber","type":"long","nullable":true,"metadata":{}},{"name":"entityName","type":"string","nullable":true,"metadata":{}},{"name":"recordIds","type":"string","nullable":true,"metadata":{}},{"name":"commitTimestamp","type":"long","nullable":true,"metadata":{}},{"name":"changedField","type":"string","nullable":true,"metadata":{}},{"name":"changedFieldValue","type":"string","nullable":true,"metadata":{}},{"name":"dt","type":"date","nullable":true,"metadata":{}}]}
i tried subresource as recordIds and recordids both of it is throwing the same error
0.10.1 this is the datahub version
same way i tried add tags also it is throwing this error
Copy code
"Failed to update urn:li:dataset:(urn:li:dataPlatform:glue,cdc_test.sfdc_case_update_test1,PROD) & field recordids. Field recordids does not exist in the datasets schema."
Hey Hyejin,
please look into this
c
@adamant-car-44878 Did you ever resolve this?
s
Did you ever get help with this?