update query in AEP query service

[BalrajMa]

While using update statement in query service getting the below error before the dataset, Please could anyone have solution?

What is MODEL here?

 ErrorCode: 42601 queryId: 9fad4729-3cf8-4832-ba50-65763ca26fd8 Syntax error encountered. Reason: [line 1:8: missing 'MODEL'

[Tof_Jossic]

@BalrajMa I looked into previous tickets and internal references and ErrorCode: 42601 seems usually a syntax error. I saw an example where a user was using a SELECT on 'userAgentString' where 'Model' was a device name / brand but I guess the 'Model' in question will very much depend on the nature of your query. 

I also found https://experienceleague.adobe.com/en/docs/experience-platform/query/sql/syntax where data model is mentioned a few times, see if that helps. If not, I'd advise you raise a Support ticket with the full query so the team can take a closer look.