LogoLogo
codatum.comSign InStart for free
  • Introduction
  • Getting Started
    • Quick Start
    • Concept (Further reading)
      • Why did we a choose Block Editor over Cell-based Editor?
  • Connect and Manage Data
    • Connection
      • Sync Table Metadata
    • Supported Warehouses
      • BigQuery
      • Snowflake
      • Other Warehouses
    • Catalog
    • Search
  • Data Exploration
    • Data Exploration Overview
    • Notebook
      • Doc Page
      • Grid Page
      • SQL Block
      • Version
      • Notebook FAQ
    • Chart
    • Explorer
    • Parameter
    • (Appendix) Cache
  • AI Assist
    • SQL Assistant
  • Sharing
    • Sharing Overview
    • Teamspace
    • Shared Notebook
    • Report
    • Public Link
    • Signed Embed
      • How to Set Up Signed Embed
  • Account Management
    • Account
    • Account Settings
  • Workspace & User Management
    • Workspace
  • User Management
    • Invitation
    • Group
  • Security
    • Security Overview
  • Audit logs
  • IP Access Control
  • Access control
    • Access Control Overview
    • Access Control for Workspace
    • Access Control for Resources
      • Access Control for Group
      • Access Control for Teamspace
      • Access Control for Notebook
      • Access Control for Connection
      • Access Control for Report
  • [Under Construction] Plan and Billing
    • Limit and usage
    • Downgrade and cancel
  • Best Practices
    • Advanced Control Structures in SQL
  • Other considerations
    • System requirements
Powered by GitBook

Reference

  • Privacy policy
  • Terms of service
  • JP Docs Site
On this page
  • How to Set Up
  • Key Features and How to Use
  • Data Privacy

Was this helpful?

  1. AI Assist

SQL Assistant

Powerful assistant for SQL generation, modification, fixing, and completion with LLM

Previous(Appendix) CacheNextSharing Overview

Last updated 6 months ago

Was this helpful?

SQL Assistant is a feature that understands your intent and generates the necessary SQL for you.

By telling the analysis you want to perform or the SQL you want to generate in natural language, SQL Assistant generates or modifies SQL accordingly.

How to Set Up

Navigate to Workspace settings > Codatum AI and enable it. After enabling it, you can use SQL Assistant by choosing an SQL Block and clicking the top right corner of it.

Key Features and How to Use

  • SQL Generation:

    • After creating an SQL Block, select the table to be referenced by the Assistant and specify the analysis you want to perform.

  • SQL Modification:

    • Select the SQL Block you want to modify and instruct the Assistant on how to modify it.

  • SQL Auto Fix:

    • By selecting "Auto fix" on an SQL Block that has an error, the Assistant will perform corrections based on the SQL statements that need fixing and the error messages.

Data Privacy

These requests are sent to each LLM platform you choose but are not used for training purposes.

The data included in key features are as follows:

  • SQL statement within the SQL block

  • The schema of the referenced table and the schema of the result of the SQL execution, as specified in:

    • Tables and SQL Blocks referenced within the SQL block

    • Tables explicitly referenced in the GUI

  • Request messages input by the user

To use SQL Assistant feature with your own API key, please contact us via chat or [email protected]