Canvas Guides (English)Canvas GuidesIntelligent Insights GuideAsk Your DataHow 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?

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.

Open More Options

2. Open SQL

Click the Show SQL link.

Open SQL

3. Change SQL

Close the SQL view.

Change SQL

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.

Change SQL

5. Save SQL

After changing the SQL, click the Save SQL button.

Save SQL

6. Open SQL Diagram

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

Open SQL Diagram

7. View SQL Diagram

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

View SQL Diagram

8. New SQL Displays

The new SQL data is displayed in the chatbot.

New SQL Displays

9. Open SQL

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

Open SQL

10. Revert to Original SQL

Then, click the Revert to Original SQL button.

Revert to Original SQL

This guide covered how to view and update a generated SQL statement in Ask Your Data.