topic Re: Error while running update statement using delta lake linked service through ADF in Data Engineering

Error while running update statement using delta lake linked service through ADF

yashojha1995 — Fri, 11 Apr 2025 07:39:06 GMT

Hi All,

I am getting the below error while running an update query in a lookup activity using the delta lake linked service:

ErrorCode=AzureDatabricksCommandError,Hit an error when running the command in Azure Databricks. Error details: <span class='ansi-red-fg'>SyntaxError</span>: EOL while scanning string literal (<command--1>, line 1).

Can anyone help in this ?

Re: Error while running update statement using delta lake linked service through ADF

RiyazAliM — Thu, 17 Apr 2025 07:07:38 GMT

Hi @yashojha1995

EOL while scanning string literal hints that there might be a syntax error in the update query.
could you share your update query here, and any other info such as how are you creating a Linked service to your delta lake? Does it mean you're connecting to Databricks or any bucket/container?

Looking forward, cheers!