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 <[email protected]>
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"
