Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/24/2024 11:32 PM
Hi Team,
I need to add description as comments about the query in the pre-processor JSON,
so can you please suggest the JSON syntax for this case.
Thanks,
Sekhar.
10/24/2024 11:42 PM
@Sekhar could you please elaborate on your use case.
10/24/2024 11:49 PM - edited 10/24/2024 11:50 PM
Hi @NM
I need to explain the each & every query in the pre-processor JSON.
{
"ADDITIONALTABLES": {
"USERS": "SELECT * FROM USERS",
"ACCOUNTS": "SELECT name,customproperty44 FROM ACCOUNTS",
"TATTR": "SELECT attribute1,datasetname,attribute2,attribute3 FROM DATASET_VALUES WHERE DATASETNAME
},
"COMPUTEDCOLUMNS": [
"SYSTEMUSERNAME",
"CUSTOMPROPERTY34"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA NU SET NU.SYSTEMUSERNAME=''",
//Comments//
"UPDATE NEWUSERDATA NU SET NU.CUSTOMPROPERTY34='ONR' where (COALESCE(NU.SYSTEMUSERNAME,'') ='' OR NU.SYSTEMUSERNAME IS NULL)"
]
}
Above JSON Syntax is not valid in validator tool.
I need valid JSON for adding the comments.
Thanks,
Sekhar.
10/24/2024 11:55 PM
@Sekhar try this
-- or /*(start). */(End)
10/25/2024 12:09 AM
I tried but, it is not working getting syntax error
Pasting the error below:
Thanks,
Sekhar
10/25/2024 07:50 AM
Below worked for me
{
"ADDITIONALTABLES": {
"USERS": "SELECT USERKEY, lastname, middlename, firstname FROM USERS"
},
"COMPUTEDCOLUMNS": [
"customproperty20"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET CUSTOMPROPERTY20 ='Workday'"
],
"COMMENTS": {
"PREPROCESSQUERIES": [
"Setting CUSTOMPROPERTY20 to 'Workday' for all new user data."
]
}
}
10/25/2024 01:04 PM
Hi @rushikeshvartak , Thank you for inputs.
As of now, full import takes 7hrs for completing the job, If we add comments in the Pre-Processor will it effects on performance?
Thanks,
Sekhar