Add the comments in the Pre-processor Json

[Sekhar]

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.

[NM]

@Sekhar could you please elaborate on your use case.

[Sekhar]

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.

[NM]

@Sekhar try this 

-- or /*(start).  */(End)

[Sekhar]

I tried but, it is not working getting syntax error

Pasting the error below:

Thanks,

Sekhar

[rushikeshvartak]

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."
    ]
  }
}

[Sekhar]

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

[rushikeshvartak]

No there should be no change in performance