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
To view and update a generated SQL statement, click the More Options icon.
2. Open SQL
Click the Show SQL link.
3. Change SQL
Close the SQL view.
4. Change SQL
The SQL generated from the chatbot is displayed in a separate window. You can make changes to the SQL or overwrite it.
5. Save SQL
After changing the SQL, click the Save SQL button.
6. Open SQL Diagram
To view the SQL Diagram, click the SQL Diagram tab.
7. View SQL Diagram
The SQL Diagram displays the visual representation of the generated query as an Entity Relationship Diagram.
8. New SQL Displays
The new SQL data is displayed in the chatbot.
9. Open SQL
To revert to the original SQL, click the Show SQL link from the More Options icon.
10. 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.
