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
  • What It Covers:
  • How to Connect
  • Select Your DB or CSV:
  • Choose Your Schema and Tables:
  • Auto-Generated Definitions:
  1. Datasource
  2. Creating Datasource

Structured

PreviousCreating DatasourceNextThird-Party Tool

Last updated 3 months ago

What It Covers:

SQL-based databases (Snowflake, BigQuery, PostgreSQL, etc.) or CSV files.

How to Connect

Select Your DB or CSV:

  • For a database, provide read-only credentials (host, username, password).

  • For a CSV, simply upload the file.

Choose Your Schema and Tables:

  • LLMate detects available schemas and tables automatically.

  • Pick the specific tables or columns you want to connect.

Auto-Generated Definitions:

  • LLMate uses AI to assign field types (text, numeric, date, etc.) and estimate key metrics (sums, counts, averages).

  • After creation, you can refine these definitions at any time.

Note: Once you select your schema and tables, LLMate will immediately create the datasource. If something isn’t correct, don’t worry—you can edit it afterward.