LLMate Product Document
  • Getting Started
    • 👋Welcome
  • Setting
    • Team
      • Members
      • Invitation
      • Leave Organization
    • API Key Management
      • View all API keys
      • Create a new API key
      • Editing an Existing API Key
      • Deleting an API Key
    • Model Management
      • OpenAI
      • ClaudeAI
      • VertexAI
      • Azure OpenAI
    • Data Pipeline Management
      • Connector Level
      • Table Level
    • Data Connection Management
      • Connection Level
      • Account Level
  • Datasource
    • Datasource - Overview
    • Creating Datasource
      • Structured
      • Third-Party Tool
      • Semi-Structured
    • Managing Datasource
      • Structured & Third Party Datasource
        • Schema Level Configuration Menus
          • Information
          • Table & Schema
          • Joins
          • LLM Settings
          • Manage Examples
          • Logs
          • Suggested Questions
        • Table-Level Configuration Menus
          • Information
          • Concepts
          • Preview
      • Semi-structured Datasource
        • Information
        • Setup
    • Querying Datasource
      • Datasource Response
      • Adding Datasource response to Dashboard
  • Assistant
    • Assistant - Overview
    • Creating Assistant
    • Managing Assistant
      • Assistant-Level Configuration
        • Information
        • LLM Settings
        • Datasources
        • Chat Threads
        • Suggested Questions
      • Connected Datasource-Level Configuration
    • Assistant Chat
      • Assistant Response
      • Adding Assistant's response to Dashboard
  • Reporting
    • Dashboard
      • Creating Dashboard
        • Adding widget
          • Collaborating with Datasource
          • Collaborating with Assistant
        • Adding Sections
          • Managing Section
      • Managing Dashboard
        • Editing Dashboard
        • Deleting Dashboard
        • Sharing & Publishing Dashboard
    • Notebook
      • Creating Notebook
      • Building Reports in Notebook
        • Adding Data Insights to Notebook
          • Collaborating with Data Source
          • Collaborating with Assistant
      • Managing Notebook
        • Edit Notebook
        • Save Notebook Edits
        • Delete Notebook
        • Publish Notebook
  • Integration Doc
    • Meta Ads
    • Google Ads
    • Google Analaytics - GA 4
    • Shopify
Powered by GitBook
On this page
  • SQL Output Window:
  • Editing and Running Queries:
  • Dataframe Output Window:
  1. Datasource
  2. Querying Datasource

Datasource Response

PreviousQuerying DatasourceNextAdding Datasource response to Dashboard

Last updated 2 months ago

When the datasource replies to your query, the response window is interactive and offers several buttons, each serving a distinct purpose.

SQL Output Window:

After entering your query, the generated SQL appears in the SQL output window.

Here, you have three key buttons next to the SQL:

  • Save: Save the current question, the steps taken, and the resulting SQL as an example. This helps LLMate learn from your queries for future reference.

  • Thoughts: Open a side drawer to see a detailed breakdown of how LLMate generated the SQL. This includes the reasoning steps and examples it used.

  • Error: If there was an issue generating the query, click this to view any error messages or logs.

Editing and Running Queries:

  • If the generated SQL isn’t quite right, you can directly edit the SQL in the output window.

  • After making changes, click the Run button to execute the updated query.

Dataframe Output Window:

Once the query runs successfully, results appear in a dataframe output window.

On this window, you can switch between:

  • Table View: See the results in a spreadsheet-like format.

  • Graph View: Visualize the data as a chart.

There are also three buttons on the right:

  • Change Graph Type: Modify the visualization style (e.g., bar chart, pie chart) and adjust which fields are displayed.

  • CSV: Download the data as a CSV file for offline use or further analysis.

  • Add to Dashboard: Save the current table or graph directly to one of your dashboards. When clicked, you’ll be asked to select the specific dashboard and section where you want to place this output.