Hello, We are experiencing an error when attempting to create a temp table and then insert into the permanent table in Synapse. The error we're receiving: pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Not able to validate external location because The remote server returned an error: (409) Conflict. (105215) (SQLExecDirectW)') So far I've checked all the blobs for leases, which there are none Since the script is generated in Python, I copied the created SQL and ran it directly in Synapse, both the copy into and insert into - ran flawlessly The only salient info from searching the web is that it might be a versioning issue with the blob, but since I've run the other blobs successfully I doubt that is it Any help would be appreciated. Thanks

Unable to load data to Synapse Dedicated pool from Gen2 datalake blob(s) - Python

Nikita Thomas 1

Hello,

We are experiencing an error when attempting to create a temp table and then insert into the permanent table in Synapse. The error we're receiving:

pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Not able to validate external location because The remote server returned an error: (409) Conflict. (105215) (SQLExecDirectW)')

So far I've checked all the blobs for leases, which there are none
Since the script is generated in Python, I copied the created SQL and ran it directly in Synapse, both the copy into and insert into - ran flawlessly
The only salient info from searching the web is that it might be a versioning issue with the blob, but since I've run the other blobs successfully I doubt that is it

Any help would be appreciated. Thanks

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2022-12-06T08:00:49.33+00:00

Hi @Nikita Thomas ,

Thank you for posting query in Microsoft Q&A Platform.

Could you please share the sample code which you are trying? Are you trying to read data from some storage in to Temp table and then loading that to dedicated SQL pool table? If yes, could you please share your implementation details once so that I can try to repro and see how it behaves.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2022-12-22T09:56:18.873+00:00

Hi @Nikita Thomas - Just checking if you get chance to share updates? Thank you.