View & Edit Script

View & Edit Dataset Script

Access and modify the underlying SQL query directly in Tepun AI Report Builder.

Viewing the Script

1. Open the Dataset — Navigate to the dataset detail view
2. Click View Script — Opens the SQL query viewer
3. Review Components:
   • SELECT: Which columns are retrieved
   • FROM/JOIN: Tables and relationships
   • WHERE: Filter conditions
   • GROUP BY: Aggregation grouping
   • ORDER BY: Sort configuration

Editing the Script

1. Click Edit Script — Enable editing mode
2. Modify the Query:
   • Add columns: SELECT *, new_column
   • Add joins: LEFT JOIN related_table ON...
   • Add conditions: WHERE amount > 1000
   • Add calculations: price * quantity AS total
   • Add window functions: ROW_NUMBER() OVER(...)
3. Validate — Click Validate to check for syntax errors
4. Save Script — Apply changes to the dataset

Learn how to transform your data.