GUI Mode option not showing up

[malcantara]

I am trying to make a query to write back to the database, but the GUI-Mode option does not show in the application.

[dcartlidge]

hi, welcome to the forum

to better help understand the problem can you share a screenshot or describe what kind of query and resource you're trying to use to write the data?
I'm expecting something that looks like this:

[malcantara]

Hello Dave,
this is what I see:

[dcartlidge]

Ah, I believe that the GUI mode is only available to SQL commands and database resources, which databricks isn't

[malcantara]

Can I write data to the database without GUI mode?

[dcartlidge]

yes, the GUI mode is purely to assist you and help writing CRUD statements easier but is entirely optional

[malcantara]

I ran an insert query. I can see that the data made it into the table, but I get this error in retool: "A ResultSet was expected but not generated from query". How can I avoid the error?

[dcartlidge]

Not familiar enough with using databricks to answer that one myself, sorry

[malcantara]

Thanks Dave, I appreciate the help. I will dig into that one. I do not get that error when running the query directly in databricks. I only get that error when running the query from retool

[kbn]

Just noting that this seems related to these 2 other Databricks related topics

Issue with MERGE INTO on Databricks

@jbc Thank you for reporting! The MERGE INTO queries don't usually return any result. Even though it shows the error "A ResultSet was expected but not generated from query", the query should succeed. I've filed a task for the team to improve the UX around this error, meanwhile you can continue using the query!

Insert query error (Databricks)

@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.

I'm also adding a +1 indicating your interest in the feature request internally to add GUI mode for the databricks resource. We can keep you updated on whether that gets prioritized!