How do I view and update a generated SQL statement in Ask Your Data?

[#1]

When you interact with Ask Your Data, your natural language queries are translated into SQL statements to retrieve the precise information you need. You have the capability to take control of this process by accessing and reviewing the SQL generated by the platform, which provides transparency into how your data is being queried. You can also modify or even completely overwrite these SQL statements to refine your queries or implement custom logic.

You will also be able to visualize the query structure through an SQL Diagram and, if necessary, revert any changes you've made back to the original system-generated SQL.

Note: Sub-account administrators can use Ask Your Data (AYD) directly within their own sub-accounts, where AYD is scoped to display only the data relevant to that specific sub-account.

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

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. Open SQL Diagram

To view the SQL Diagram, click the SQL Diagram tab.

6. View SQL Diagram

The SQL Diagram displays the visual representation of the generated query as an Entity Relationship Diagram.

7. New SQL Displays

The new SQL data is displayed in the chatbot.

8. Open SQL

To revert to the original SQL, click the Show SQL link from the More Options icon.

9. 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.