How do I view and update a generated SQL statement in Ask Your Data?
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.
Explore how to efficiently view, update, and manage your SQL statements to ensure you get the most accurate and relevant results from your data.
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.