I built an insert query in the query library for a databricks database. The insert query runs and writes the data to the database, but it throws an error: "A ResultSet was expected but not generated from query". How can I get around this error?
@malcantara This is an issue similar to the "MERGE INTO" error. The problem is that insert query doesn't return any result, and we treated that as error. It's a bug on our side, you could treat this error as query success and actually query Databricks again to confirm that data is inserted. We're revamping the Databricks connector; hopefully this issue will be fixed in the near future.
2 Likes