Editing SQL

Each generated insight is backed by an SQL query, automatically constructed based on the natural language input provided by the user. This allows users to fine-tune their insights by directly modifying the SQL, enabling them to adjust data parameters, apply additional filters, or include more attributes for a more customised analysis.

‼️For security and system integrity, only read-only SQL statements are permitted. Any attempt to execute modification statements (such as INSERT, UPDATE, or DELETE) will be blocked by the system to ensure data safety.

Editing SQL in BetIntel.ai – Step-by-Step Guide

1. Open the SQL Editor

   • Click on the database icon to access the SQL query behind the generated insight.

2. Review Available Tables & Attributes

   • At the bottom of the screen, a list of tables and attributes is displayed.
   • Each attribute includes a definition, helping users understand how it is used in the SQL.

3. Modify the SQL Query

   • Edit the query to change data parameters, add filters, or include additional attributes.
   • Ensure that only read-only SQL statements are used, as modification statements (e.g., INSERT, UPDATE, DELETE) are blocked by the system.

4. Apply Changes

   • Once the necessary modifications are made, click Apply to update the insight.

5. Save the Insight

   • To make the changes permanent, click Save to ensure the updated query is retained.