How do I view and update a generated SQL statement in Ask Your Data?
How do I view and update a generated SQL statement in Ask Your Data?
How do I view and update a generated SQL statement in Ask Your Data?
1. Open More Options
Click the More Options icon.
2. Open SQL
Click the Show SQL link.
3. Change SQL
The SQL generated from the chatbot is displayed in a separate window. You can make changes to the SQL or overwrite it.
4. Save SQL
After changing the SQL, click the Save SQL button.
5. New SQL Displays
The new SQL data is displayed in the chatbot.
6. Open SQL
To revert to the original SQL, click the Show SQL link from the More Options icon.
7. Revert to Original SQL
Then, click the Revert to Original SQL button.
This guide covered how to view and update a generated SQL statement in Ask Your Data.