You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@superset.apache.org by di...@apache.org on 2023/04/04 11:16:52 UTC

[superset] branch feat/sqllab-natural-language updated: Update prompt

This is an automated email from the ASF dual-hosted git repository.

diegopucci pushed a commit to branch feat/sqllab-natural-language
in repository https://gitbox.apache.org/repos/asf/superset.git


The following commit(s) were added to refs/heads/feat/sqllab-natural-language by this push:
     new fe802b942b Update prompt
fe802b942b is described below

commit fe802b942bcd5eef78b299413ee9968aed1577f7
Author: geido <di...@gmail.com>
AuthorDate: Tue Apr 4 13:16:37 2023 +0200

    Update prompt
---
 superset/sqllab/api.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/superset/sqllab/api.py b/superset/sqllab/api.py
index c138df6228..6351f2aa47 100644
--- a/superset/sqllab/api.py
+++ b/superset/sqllab/api.py
@@ -168,7 +168,7 @@ class SqlLabRestApi(BaseSupersetApi):
             prompt += "The 'COMMAND' given above is a natural language command that you must transform into one SQL query.\n"
             prompt += "In order to generate the SQL query properly, follow the instructions below:\n"
             prompt += "1. Only SELECT statements are allowed\n"
-            prompt += f"2. Use the SQL dialect {database_backend}\n"
+            prompt += f"2. The query should run successfully on a {database_backend} database\n"
             prompt += "3. Use all table definitions above\n"
             prompt += "4. Respond solely with the SQL query\n"
             prompt += "\n{{ SQL_QUERY }}\n"