Skip to content

NLP to SQL Notebook Cell #1200

Open
Open
@ehynd

Description

@ehynd

Description

We need to create a cell within the notebook that will translate NLP into SQL and then return the output. This will be especially helpful for low code / no code users.

Design

Design will be completed via #1199.

Figma: https://www.figma.com/design/Qj4tWPsniFOJ6qSLfxOaBT/Drag-And-Drop---Design?node-id=16959-225935&t=xHEmw41Z1uRfHIh1-0

Requirements

What are more specific requirements that needs to take to consider this issue resolved.

  • Create new cell type "Text to SQL"
    User will select a database from dropdown. It will show only dbs they have access to.
    User will select a Model from dropdown. Dropdown will show all models the user has access to
    Cell will contain an area for text input where the user will be able to type (Ex: show me records of people over age 50)
    User will be able to change name / type of frame output (Like on Import Data cell)
    User will then run the cell normally. This will trigger a call to this Reactor: NLPQuery3Reactor
    After the cell is run, the user's input will show up, the generated SQL will populate within the cell, and the output table will show the data from the SQL query.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

No labels
No labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

    Development

    Participants

    @bannaarisamy-shanmugham-kanini@ehynd

    Issue actions

      NLP to SQL Notebook Cell · Issue #1200 · SEMOSS/semoss-ui