This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
When I try to execute a script on Databricks 7.0 to write data to a table in Azure Synapse Analytics, I get an error: Parse error at line: 7, column: 30: Incorrect syntax near ''Managed Service Identity''.
I have useAzureMSI option equal to true. Using the Managed Service Identity for our storage account access is a hard requirement for us.
I worked around this by setting the spark conf to use polybase - spark.conf.set("spark.databricks.sqldw.writeSemantics", "polybase")
but I'd like to try out the new COPY command to load the data, if there is a workaround available for that. Anyone have any ideas or sample code to get the write command configured properly?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
hello @TomSmith-2777 ,
Our sincere apoliziges for not enagaging sooner . Can you please confirm if you are still facing this issue . Are you seeing similar behavior with different version of databricks ?
Thanks
Himanshu
Hello @TomSmith-2777,
We have not yet heard back from you on this and we are assuming that you have a resolution , we request you to share that with the community . If thats not the case
please do let us know .
Thanks& stay safe
Himanshu
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 40%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
Hi @HimanshuSinha-msft !
I can confirm that this is still happening. Everything except writing to Synapse works. It looks like the underlying SQL that is sent to the cluster via the JDBC has a syntax error. The fix the OP wrote was the only way I could get it to write after I changed cluster version.