Feedloop AI
  • GETTING STARTED
    • Discover Feedloop AI
    • Authentication
      • Sign Up
      • Login
    • Platform
      • Workspace
      • Project
      • People
      • Usage
  • WHAT IS AGENT
    • What is Agent
      • ⚪Manage Agent
    • Basic Agent
      • ⚪Instruction
        • Who
        • What
      • ⚪Training
        • Rules
        • Example
      • ⚪Skill
        • Knowledge
        • Analys
      • ⚪Style
    • Procedures
    • Advance Reasoning
      • ⚪Creating New Agent
      • ⚪Advance Agent Activation
      • ⚪Deleting Agent
      • ⚪Advance Agent Managing Existing
  • AGENT SETTINGS
    • Instruction
      • Who
      • What
      • Additional Instruction
    • Training
      • Chat Rules
      • Retrieval
      • Answering
    • Context
      • Primitive Context
      • Array
    • Tools
      • Knowledge
      • API - Call
        • Manage API Call
        • Basic Configuration
        • Header
        • Body Field
          • Input Binding
            • Page 2
          • Output Binding
        • Testing API Call
        • Trouble Shooting
        • Example Implementation
          • API Call Covid
      • Data Connector
    • Card
      • Intro & Summary Text
      • Data Visualization Card
      • Analyze Card
    • Procedure Basic Info
      • Activation Condition
      • Goal
      • Action
    • Procedures Interaction
      • Procedures Step
      • Procedures Context
      • Procedures Tools
  • AGENT UTILITY
    • Resource
      • Document PDF
        • Preparing your PDF
      • Data Connector
        • Create new data connector
        • Configure dataset, table, and column
        • Using Data Playground
        • Dataset in Data Playground
        • Training in Data Playground
        • SQL generation and modification
        • SQL Execution
    • Apps
      • Chat Widget
      • Web App
    • Testing
    • Monitoring
      • Customer Chat
      • Context
      • Document
  • TASK
    • ⚪Image Analyzer
      • Building Analyzer
      • ID Identifier
    • ⚪Document Analyzer
      • Contractual Document Analyzer
    • ⚪Database Analyzer
    • ⚪Additional Solution
      • Text Sentiment Analyzer
      • Customer Complaint Analyzer
  • For Developer
    • API Chat
      • Chat Initialization
      • Chat Message
      • Chat History
      • Error Handling
    • Embed Widget
      • Embedding the Widget
      • Identity Attributes
      • Widget Attribute Details
Powered by GitBook
On this page
  • SQL Generation
  • SQL Modification
  1. AGENT UTILITY
  2. Resource
  3. Data Connector

SQL generation and modification

PreviousTraining in Data PlaygroundNextSQL Execution

Last updated 7 months ago

SQL Generation

After filling in relevant questions within the context, in this case, healthcare, you can press the 'Generate' button to proceed. After generating questions, the system will automatically generate SQL, which will then appear in the SQL column.

As a result, we have the following SQL query:

SELECT * FROM "stagging-qore-data-potato-712352".test
WHERE lokasi = 'Bandung'

SQL Modification

After filling in relevant questions within the context, proceed by pressing the 'Execute' button. Following the generation of questions, the system will automatically generate SQL. However, if we wish to modify the SQL query, simply click the SQL section and then make the necessary changes to the SQL query.

We can modify the generated SQL query from the previous questions by clicking on the SQL section. Afterward, we can edit the SQL according to our specific needs.

You can try modifying the existing SQL query in the box according to your needs. For example, you can change the location you want to retrieve by replacing 'Bandung' with 'Semarang'.

SELECT * FROM "stagging-qore-data-potato-712352".test
WHERE lokasi = 'Bandung'

We can modify the query to retrieve data from the location 'Semarang' look like this.

SELECT * FROM "stagging-qore-data-potato-712352".test
WHERE lokasi = 'Semarang'