Thanks for the video... Unfortunately it did not work for me... Did you configure something else? I get this error : com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server or error: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Customer'.
Yes for me also delete query is not working from azure databricks when trying to excute delete query on azure synapse using read api with option "query". Any other way to execute delete query from databricks notebook. Thanks
How to read multiple tables from sql server?
Thanks for the video... Unfortunately it did not work for me... Did you configure something else?
I get this error : com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server
or error: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Customer'.
may be you have given the wrong table name. because it says "Invalid object name 'Customer'."
@@DataCafe4u Thanks Data Cafe but I watched your other video and now is working fine. Great work and thanks for your tutorial!
Select is working for me
But when i write delete query it is not working. Is this a supported operation?
yes.
@@DataCafe4u but it always gives exception. Can u show some sample tested case?
Yes for me also delete query is not working from azure databricks when trying to excute delete query on azure synapse using read api with option "query". Any other way to execute delete query from databricks notebook. Thanks
valuable tutorial!!!
Thank you !!!