update query in AEP query service

Question

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'

Balraj_Maskale · Accepted Answer

Hi @pareek1 , below is the query i used and it worked.

INSERT INTO dataset_name SELECT struct(customerid, first_name, lastname, email ) AS _spnam from
(
select 1 AS customerid, _spnam.first_name as first_name, _spnam.lastname as lastname, struct(_spnam.email.address as address) as email from dataset (from which you want to get the attributes)
)

Tof_Jossic · Answer

@balraj_maskale 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.

Sign up

Login with SSO

Login to the community

Login with SSO