topic Databricks sql using odbc issue in Data Engineering

Databricks sql using odbc issue

DBUser2 — Sat, 09 Sep 2023 20:02:57 GMT

Hi,

I'm connecting to a Databricks instance on Azure from a Windows Application using Simba ODBC driver, and when running SQL statements on delta tables, like INSERT, UPDATE, DELETE commands using Execute, the result doesn't indicate the no. of rows affected, it is always -1. Is there a way to get that information back when running the commands? Any help is greatly appreciated. Thanks!!

Re: Databricks sql using odbc issue

DBUser2 — Mon, 11 Sep 2023 16:33:38 GMT

Thx for replying. So, is there an alternative to using Execute to run DML statements and find out the no. of rows affected? For a DELETE command, Execute returns -1 in both cases, 1)when the cmd actually deleted some records, and 2) when those records didn't exist in the table.

so, it is really difficult to know if it is success.