Chain-of-Table: How to Talk to Your Data Directly? 🙀

The idea of Text2SQL isn’t groundbreaking: instead of crafting SQL queries yourself, you pose a regular English question, and AI translates it into SQL queries customized to your database’s data frame and schema. This translation process is facilitated by Large Language Models (LLMs).

We successfully deployed Text2SQL internally at our previous company, promoting data self-service and facilitating the onboarding process for new data scientists. This implementation showed substantial potential in reducing the workload for the data BI team.

In addition to Text2SQL, there are alternative methods for interacting with your data without manual coding or relying on BI tools. One such method is through the use of the DataDM tool, which we’ve previously introduced:

DataDM: Your Private Data Visualization Assistant 💁

In today’s discussion, we’ll introduce the latest solution, using the “Chain-of-Table” technique. This approach enables a step-by-step table reasoning process, allowing operations like adding columns, row selection, grouping, and sorting. It mirrors the concise data representation methods used by data scientists. 👇

What is Chain-of-Table?