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.
![Open More Options](https://static.guidde.com/v0/qg%2F3Rcx4toKQja0NtaHm0AF68PlSJF2%2Fge6Vge1YCFuzDHwgXu2Lxn%2FhV2adn8Xrb4ZzZLKmxMVTL_doc.png?alt=media&token=1bdc1b02-c8e5-4f8c-a04b-df715f94fe6e)
2. Open SQL
Click the Show SQL link.
![Open SQL](https://static.guidde.com/v0/qg%2F3Rcx4toKQja0NtaHm0AF68PlSJF2%2Fge6Vge1YCFuzDHwgXu2Lxn%2F84jfydLUfCwBumeJkMMoYW_doc.png?alt=media&token=a0db8817-cf96-478e-b4b5-398260a044f5)
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.
![Change SQL](https://static.guidde.com/v0/qg%2F3Rcx4toKQja0NtaHm0AF68PlSJF2%2Fge6Vge1YCFuzDHwgXu2Lxn%2FhCQ85f5bHf8A5XwAVKiZ5n_doc.png?alt=media&token=d00fbd88-c30a-459c-b309-214d37a944a7)
4. Save SQL
After changing the SQL, click the Save SQL button.
![Save SQL](https://static.guidde.com/v0/qg%2F3Rcx4toKQja0NtaHm0AF68PlSJF2%2Fge6Vge1YCFuzDHwgXu2Lxn%2FwFPgGtcn9xSKaRrwNWuYiy_doc.png?alt=media&token=0ba27802-3a2e-4d4b-a348-f4a56df4f248)
5. New SQL Displays
The new SQL data is displayed in the chatbot.
![New SQL Displays](https://static.guidde.com/v0/qg%2F3Rcx4toKQja0NtaHm0AF68PlSJF2%2Fge6Vge1YCFuzDHwgXu2Lxn%2F3LrrqjgF997tPcH6dKmAVM_doc.png?alt=media&token=7771d2d3-2d06-4114-96ea-54a9326b1e20)
6. Open SQL
To revert to the original SQL, click the Show SQL link from the More Options icon.
![Open SQL](https://static.guidde.com/v0/qg%2F3Rcx4toKQja0NtaHm0AF68PlSJF2%2Fge6Vge1YCFuzDHwgXu2Lxn%2FmCJjvWhK4J1FET5XApDSsQ_doc.png?alt=media&token=fd6b91d8-a95b-46d3-88a9-b560843d75d3)
7. Revert to Original SQL
Then, click the Revert to Original SQL button.
![Revert to Original SQL](https://static.guidde.com/v0/qg%2F3Rcx4toKQja0NtaHm0AF68PlSJF2%2Fge6Vge1YCFuzDHwgXu2Lxn%2FjRSZU9eZz3nmhVzVPnbiJp_doc.png?alt=media&token=90ce15f8-64e7-4bde-bad9-26e411e39754)
This guide covered how to view and update a generated SQL statement in Ask Your Data.