Forum Discussion
QUESTION::COPY DATA::UPSERT FAIL
You will not be able to use the SQL Server endpoint of the LH as the Copy activity destination, as that endpoint is read-only. Please refer to the doc T-SQL surface area - Microsoft Fabric | Microsoft Learn
I always get confused between the SQL endpoint and the lakehouse in the dropdown list and assume that if a SQL endpoint is provided, then it means that under the hood all SQL operations are emulated on delta tables so that the user can manipulate delta tables like traditional DB tables with the expectation of achieveing the same result as if working with a SQL DB (both for DDL and DML).
That does not seem to be the case, which is a pity, especially since there is a Python API for Databricks and DeltaTable, one would think that under the hood a translation layer could be implemented to take as input any SQL DDL or DML and translate that to the equivalent Databricks/DeltaTable instruction set.