RamiAwar / dataline

Chat with your data - AI data analysis and visualization on CSV, Postgres, MySQL, Snowflake, SQLite...
https://dataline.app
GNU General Public License v3.0
346 stars 26 forks source link

S13.1 - Fix data linking issue #156

Closed anthony2261 closed 3 weeks ago

anthony2261 commented 1 month ago

Selected tables results are not easy to link to sql results:

anthony2261 commented 1 month ago

Reopening as the temporary fix only addresses a small part of the issue

RamiAwar commented 1 month ago

What remains of this issue? @anthony2261

anthony2261 commented 1 month ago

If the user requests multiple things in a single message, the openAI tool call might call the InfoSQLDatabaseTool more than once in a single shot (good for parallelization). It then becomes hard to know which call to the InfoSQLDatabaseTool corresponds to which generated sql

@RamiAwar This one isn't addressed yet. Some selected tables results might even be linked to the wrong generated sql results

anthony2261 commented 1 month ago

One idea I had was to combine all the selected tables results together, and place the aggregated result at the top just below the message content. But I'd like to explore other solutions as well

RamiAwar commented 3 weeks ago

Makes sense. I like just grouping selected results and being done with it. I get many results where I have 3+ selected tables results and it just looks super weird.

Any updates on other solutions? I say we just throw them together for now.