{"id":15964,"date":"2024-03-14T03:05:58","date_gmt":"2024-03-14T10:05:58","guid":{"rendered":"https:\/\/www.pingcap.com\/?p=15964"},"modified":"2025-03-24T22:46:54","modified_gmt":"2025-03-25T05:46:54","slug":"ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud","status":"publish","type":"post","link":"https:\/\/www.pingcap.com\/ko\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/","title":{"rendered":"AI-Powered Data Exploration: Unpacking the Latest Innovations in TiDB Cloud"},"content":{"rendered":"<p>In early 2023, <a href=\"https:\/\/www.pingcap.com\/ko\/\">TiDB Cloud<\/a> introduced <a href=\"https:\/\/www.pingcap.com\/ko\/blog\/introducing-chat2query-an-innovative-ai-powered-sql-generator-for-faster-insights\/\">Chat2Query<\/a>, a new tool that leverages OpenAI&#8217;s capabilities to help explore and interact with databases through natural language. After a year of continuous improvements, we\u2019re excited to share that Chat2Query has now become even more powerful.<\/p>\n\n\n\n<p>In this blog, we dive deeper into three major improvements to Chat2Query that will make your data interactions easier and more efficient:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Improved Text2SQL for more accurate interpretation of natural language queries<\/li>\n\n\n\n<li>Expanded capability to handle large datasets for businesses with extensive data<\/li>\n\n\n\n<li>OpenAPI availability for seamless integration with existing systems<\/li>\n<\/ul>\n\n\n\n<p><strong>Note<\/strong>: For TiDB Dedicated users, make sure you have upgraded to TiDB version 6.5 or higher and obtained whitelist access to utilize the Chat2Query feature.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Enhanced_Accuracy_for_Text2SQL\"><\/span><strong>Enhanced Accuracy for Text2SQL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Text2SQL is the most fundamental feature of Chat2Query, reducing the barrier to data exploration. Over the past year, we&#8217;ve made significant strides in Text2SQL accuracy, leveraging prompt engineering and Retrieval-Augmented Generation (RAG) techniques.&nbsp;<\/p>\n\n\n\n<p>We conducted tests using the <a href=\"https:\/\/bird-bench.github.io\/\">BIRD benchmark<\/a>, a pioneering, cross-domain dataset that examines the impact of extensive database contents on text-to-SQL parsing.Our results ranked us among the top four. Furthermore, We also tested it against the <a href=\"https:\/\/yale-lily.github.io\/spider\">Spider benchmark<\/a>, a comprehensive, challenging dataset known for its extensive coverage of complex, cross-domain semantic parsing and text-to-SQL tasks. And achieved an impressive score of 86.30, marking a significant achievement in our ongoing pursuit of excellence in Text2SQL capabilities.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"882\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/28004302\/Ranking-on-Bird-Benchmark-1024x882.jpeg\" alt=\"\" class=\"wp-image-16232\" style=\"width:840px;height:auto\" srcset=\"https:\/\/static.pingcap.com\/files\/2024\/03\/28004302\/Ranking-on-Bird-Benchmark-1024x882.jpeg 1024w, https:\/\/static.pingcap.com\/files\/2024\/03\/28004302\/Ranking-on-Bird-Benchmark-300x259.jpeg 300w, https:\/\/static.pingcap.com\/files\/2024\/03\/28004302\/Ranking-on-Bird-Benchmark-768x662.jpeg 768w, https:\/\/static.pingcap.com\/files\/2024\/03\/28004302\/Ranking-on-Bird-Benchmark.jpeg 1302w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Figure 1. <em>Ranking on Bird Benchmark<\/em><\/em><\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"245\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/28010257\/image-34.png\" alt=\"Elevated Text2SQL - Spider Score\" class=\"wp-image-16239\" srcset=\"https:\/\/static.pingcap.com\/files\/2024\/03\/28010257\/image-34.png 1024w, https:\/\/static.pingcap.com\/files\/2024\/03\/28010257\/image-34-300x72.png 300w, https:\/\/static.pingcap.com\/files\/2024\/03\/28010257\/image-34-768x184.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Figure 2. Score on Spider Benchmark<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p>We will showcase the enhancement by comparing Chat2Query 1.0 and 2.0 in how they handle the following scenarios:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Valid queries with available data<\/li>\n\n\n\n<li>Invalid queries<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Accurate SQL Generation with Chat2Query 2.0 for Valid Queries<\/strong><\/h3>\n\n\n\n<p>For SQL queries that can be satisfied with the available data, Chat2Query 2.0 showcases superior accuracy. For example, take the inquiry, &#8220;How many bikes were available in 2015?&#8221; Addressing this requires adept schema linking\u2014correctly associating user queries with the appropriate database table and column. Chat2Query 2.0 precisely identifies the relevant table and column, leading to an accurate SQL query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SUM(`bikes_available`) AS `total_bikes_available` \nFROM `status` \nWHERE YEAR(`time`) = 2015;<\/code><\/pre>\n\n\n\n<p>Conversely, Chat2Query 1.0 struggles with schema linking, often generating incorrect SQL queries that fail to provide the correct answer:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT COUNT(*) AS `bike_count`\nFROM `status` s\nJOIN `trip` t ON s.`station_id` = t.`start_station_id`\nWHERE t.`start_date` LIKE '2015%'<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Handling Invalid Queries with Intelligence<\/strong><\/h3>\n\n\n\n<p>Chat2Query 2.0 can adeptly handle invalid queries\u2014those unrelated to the database data. For instance, when presented with the question, &#8220;What is the weather?&#8221; Chat2Query 2.0 responsibly prompts the user to provide a different instruction, preventing random and irrelevant responses. By contrast, Chat2Query 1.0 generates a random answer, which can confuse or mislead users.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"463\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/14023751\/image-5-1024x463.png\" alt=\"\" class=\"wp-image-15985\" srcset=\"https:\/\/static.pingcap.com\/files\/2024\/03\/14023751\/image-5-1024x463.png 1024w, https:\/\/static.pingcap.com\/files\/2024\/03\/14023751\/image-5-300x136.png 300w, https:\/\/static.pingcap.com\/files\/2024\/03\/14023751\/image-5-768x347.png 768w, https:\/\/static.pingcap.com\/files\/2024\/03\/14023751\/image-5.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Figure 3. Chat2Query 2.0: Prompt users to provide different instructions<\/em><\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"494\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/14023812\/image-6-1024x494.png\" alt=\"\" class=\"wp-image-15986\" srcset=\"https:\/\/static.pingcap.com\/files\/2024\/03\/14023812\/image-6-1024x494.png 1024w, https:\/\/static.pingcap.com\/files\/2024\/03\/14023812\/image-6-300x145.png 300w, https:\/\/static.pingcap.com\/files\/2024\/03\/14023812\/image-6-768x370.png 768w, https:\/\/static.pingcap.com\/files\/2024\/03\/14023812\/image-6.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Figure 4: Chat2Query 1.0: Answer randomly<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Optimized_for_Large_Datasets\"><\/span><strong>Optimized for Large Datasets<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Large datasets are characterized by either a vast number of columns in a single table or an overwhelming number of tables in a database. For Chat2Query 1.0, large datasets typically pose a significant challenge due to the limitations of the context window in OpenAI&#8217;s Language Model (gpt-3.5-turbo-16k). When attempting to process a large dataset, feeding all the information as context to the LLM might surpass this limit, leading to failures in Text2SQL. In practice, errors occur if the database includes<strong> <\/strong>more than 30 tables and the average number of columns per table exceeds 20.<\/p>\n\n\n\n<p>To counter this, we&#8217;ve implemented strategies like Embedding Similarity Search and MapReduce processing in Chat2Query 2.0, enabling it to handle large datasets often required by real-world business applications efficiently.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Version Comparison on Large Datasets&nbsp;<\/strong><\/h3>\n\n\n\n<p>When it comes to processing a large database (e.g., one with 75 tables and 688 columns), Chat2Query 2.0 shows its robustness by successfully generating SQL, whereas Chat2Query 1.0 often fails due to exceeding the context window limit of the underlying language model.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"354\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/13072003\/image-3.png\" alt=\"\" class=\"wp-image-15969\" srcset=\"https:\/\/static.pingcap.com\/files\/2024\/03\/13072003\/image-3.png 900w, https:\/\/static.pingcap.com\/files\/2024\/03\/13072003\/image-3-300x118.png 300w, https:\/\/static.pingcap.com\/files\/2024\/03\/13072003\/image-3-768x302.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption class=\"wp-element-caption\"><em>Figure 5. Chat2Query 2.0: SQL generated successfully<\/em><\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"254\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/13072007\/image-4.png\" alt=\"\" class=\"wp-image-15970\" srcset=\"https:\/\/static.pingcap.com\/files\/2024\/03\/13072007\/image-4.png 924w, https:\/\/static.pingcap.com\/files\/2024\/03\/13072007\/image-4-300x82.png 300w, https:\/\/static.pingcap.com\/files\/2024\/03\/13072007\/image-4-768x211.png 768w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><figcaption class=\"wp-element-caption\"><em>Figure 6. Chat2Query 1.0: Failed to generate SQL<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Accessible_via_OpenAPI\"><\/span><strong>Accessible via OpenAPI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>More and more users have expressed their desire to integrate our Text2SQL capabilities into their systems to improve user experience. However, they also have privacy and security concerns when exposing their sensitive business data to external systems. To address this, we&#8217;ve made the full capabilities of Chat2Query accessible via OpenAPI. This enables seamless integration into user systems without compromising data security.<\/p>\n\n\n\n<p>For a step-by-step guide on using OpenAPI to integrate Chat2Query with your application, please refer to our <a href=\"https:\/\/docs.pingcap.com\/tidbcloud\/use-chat2query-api\">API documentation<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The improved Chat2Query is highly accurate in converting text to SQL and capable of handling large datasets. This allows it to be a versatile tool for data exploration. Moreover, its accessibility via OpenAPI ensures that it can be seamlessly incorporated into existing systems, making it a powerful and user-friendly solution for a wide range of applications.<\/p>\n\n\n\n<p>As we look to the future, Chat2Query is poised for further innovation, enhancing its capabilities and user experience. Here&#8217;s what to expect:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Chat mode interaction<\/strong>: Chat2Query will offer a more conversational approach to interacting with Chat2Query. This enables users to engage in a chat-like dialogue to generate SQL queries.<\/li>\n\n\n\n<li><strong>Incorporation of<\/strong> <strong>domain knowledge<\/strong>: This feature provides Chat2Query with adaptive learning capabilities. Chat2Query will become more intelligent with use, offering increasingly sophisticated and accurate responses tailored to specific domain requirements.<\/li>\n<\/ul>\n\n\n\n<p>You can try out Chat2Query for free right now by<a href=\"https:\/\/tidb.auth0.com\/login?state=hKFo2SBWcDIwUE5ta08wV0hpa1lWUUlQQmRFX2lOTmNTQmIxNKFupWxvZ2luo3RpZNkgbHdtTEUtQ1N2OHRnanpwS0F0eGxmQktDZ1ViMXJCUEGjY2lk2SA2SVp0aENmbVJLSVBFblFTVDhhRGJ0TTdTR2RNbmlSbA&amp;client=6IZthCfmRKIPEnQST8aDbtM7SGdMniRl&amp;protocol=oauth2&amp;response_type=token%20id_token&amp;redirect_uri=https%3A%2F%2Ftidbcloud.com%2Fauth_redirect%3Fprev%3D%2Fconsole%2Fclusters&amp;scope=openid%20email&amp;nonce=xrTNDmUdkgpLnJSPm3B2pr-pIFKddAwK&amp;auth0Client=eyJuYW1lIjoiYXV0aDAuanMiLCJ2ZXJzaW9uIjoiOS4xOS4xIn0%3D\"> signing up for TiDB Cloud<\/a>. Additionally, try our demo for data analysis at <a href=\"https:\/\/www.tiinsight.chat\/\">TiInsight<\/a> to see Chat2Query in action.<\/p>","protected":false},"excerpt":{"rendered":"<p>In early 2023, TiDB Cloud introduced Chat2Query, a new tool that leverages OpenAI&#8217;s capabilities to help explore and interact with databases through natural language. After a year of continuous improvements, we\u2019re excited to share that Chat2Query has now become even more powerful. In this blog, we dive deeper into three major improvements to Chat2Query that [&hellip;]<\/p>\n","protected":false},"author":286,"featured_media":15987,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[13],"tags":[138,236,208],"class_list":["post-15964","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product","tag-ai","tag-tidb-dedicated","tag-tidb-serverless"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg","author_info":{"display_name":"Jway Wan","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/jwan\/"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Text2SQL Enhanced: Data Exploration with AI and TiDB Cloud<\/title>\n<meta name=\"description\" content=\"Find out how TiDB Cloud\u2019 latest upgrades to Chat2Query enhance Text2SQL processing, large dataset handling, and system integrations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Text2SQL Enhanced: Data Exploration with AI and TiDB Cloud\" \/>\n<meta property=\"og:description\" content=\"Find out how TiDB Cloud\u2019 latest upgrades to Chat2Query enhance Text2SQL processing, large dataset handling, and system integrations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T10:05:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-25T05:46:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1875\" \/>\n\t<meta property=\"og:image:height\" content=\"625\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jway Wan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jway Wan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\"},\"author\":{\"name\":\"Jway Wan\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/06ea291f0f85436ddc546a3c8a2a53fa\"},\"headline\":\"AI-Powered Data Exploration: Unpacking the Latest Innovations in TiDB Cloud\",\"datePublished\":\"2024-03-14T10:05:58+00:00\",\"dateModified\":\"2025-03-25T05:46:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\"},\"wordCount\":899,\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg\",\"keywords\":[\"AI\",\"TiDB Dedicated\",\"TiDB Serverless\"],\"articleSection\":[\"Product\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\",\"url\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\",\"name\":\"Text2SQL Enhanced: Data Exploration with AI and TiDB Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg\",\"datePublished\":\"2024-03-14T10:05:58+00:00\",\"dateModified\":\"2025-03-25T05:46:54+00:00\",\"description\":\"Find out how TiDB Cloud\u2019 latest upgrades to Chat2Query enhance Text2SQL processing, large dataset handling, and system integrations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg\",\"width\":1875,\"height\":625},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AI-Powered Data Exploration: Unpacking the Latest Innovations in TiDB Cloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/06ea291f0f85436ddc546a3c8a2a53fa\",\"name\":\"Jway Wan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"caption\":\"Jway Wan\"},\"url\":\"https:\/\/www.pingcap.com\/ko\/blog\/author\/jwan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Text2SQL Enhanced: Data Exploration with AI and TiDB Cloud","description":"Find out how TiDB Cloud\u2019 latest upgrades to Chat2Query enhance Text2SQL processing, large dataset handling, and system integrations.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/","og_locale":"ko_KR","og_type":"article","og_title":"Text2SQL Enhanced: Data Exploration with AI and TiDB Cloud","og_description":"Find out how TiDB Cloud\u2019 latest upgrades to Chat2Query enhance Text2SQL processing, large dataset handling, and system integrations.","og_url":"https:\/\/www.pingcap.com\/ko\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_published_time":"2024-03-14T10:05:58+00:00","article_modified_time":"2025-03-25T05:46:54+00:00","og_image":[{"width":1875,"height":625,"url":"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg","type":"image\/jpeg"}],"author":"Jway Wan","twitter_card":"summary_large_image","twitter_creator":"@PingCAP","twitter_site":"@PingCAP","twitter_misc":{"Written by":"Jway Wan","Est. reading time":"5\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#article","isPartOf":{"@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/"},"author":{"name":"Jway Wan","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/06ea291f0f85436ddc546a3c8a2a53fa"},"headline":"AI-Powered Data Exploration: Unpacking the Latest Innovations in TiDB Cloud","datePublished":"2024-03-14T10:05:58+00:00","dateModified":"2025-03-25T05:46:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/"},"wordCount":899,"publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg","keywords":["AI","TiDB Dedicated","TiDB Serverless"],"articleSection":["Product"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/","url":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/","name":"Text2SQL Enhanced: Data Exploration with AI and TiDB Cloud","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg","datePublished":"2024-03-14T10:05:58+00:00","dateModified":"2025-03-25T05:46:54+00:00","description":"Find out how TiDB Cloud\u2019 latest upgrades to Chat2Query enhance Text2SQL processing, large dataset handling, and system integrations.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg","contentUrl":"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg","width":1875,"height":625},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"AI-Powered Data Exploration: Unpacking the Latest Innovations in TiDB Cloud"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]},{"@type":"Person","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/06ea291f0f85436ddc546a3c8a2a53fa","name":"Jway Wan","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/","url":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","caption":"Jway Wan"},"url":"https:\/\/www.pingcap.com\/ko\/blog\/author\/jwan\/"}]}},"grav_blocks":false,"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/ai-powered-data-exploration-unpacking-the-latest-innovations-in-tidb-cloud\/\"><div class=\"card-resource__image-container\"><img class=\"card-resource__image\" alt=\"Text2SQLv2-banner\" src=\"https:\/\/static.pingcap.com\/files\/2024\/03\/14024358\/Text2SQLv2-banner.jpeg\" loading=\"lazy\" width=1875 height=625 \/><\/div><div class=\"card-resource__content-container\"><div class=\"card-resource__content-head\"><div class=\"card-resource__category\">Product<\/div><\/div><h5 class=\"card-resource__title\">AI-Powered Data Exploration: Unpacking the Latest Innovations in TiDB Cloud<\/h5><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/15964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/286"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=15964"}],"version-history":[{"count":12,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/15964\/revisions"}],"predecessor-version":[{"id":23935,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/15964\/revisions\/23935"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/15987"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=15964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=15964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=15964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}