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

yashojha1995
New Contributor

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 ?

Thanks,
Yash Ojha

RiyazAliM
Honored Contributor

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!

Riz