Inspecting the Generated SQL
Though Visitran is an Agentic platform and is no-code, Visitran, under the hood, generates SQL queries for all the transformations that are performed, and you can always view the generated SQL queries in the Visitran UI as you define your transformations in a no-code fashion.
Follow-along video
Viewing the Generated SQL
Every no-code model has a Generated Query tab, where you can view the SQL queries that Visitran is generating for you. Let's look at the generated SQL for the dev_payments model.
As you can see, for both the transformations we performed, Visitran has generated a single SQL query to cover them. In the screenshot above you can see 3 things:
- The table's columns, along with some sample data
- The no-code transformations we performed
- The generated SQL query
Excel Formulas to SQL
Though you used Excel Formulas to define transformations, Visitran does the heavy lifting of converting them to SQL for you, keeping your data transformation workflow simple and intuitive. Not only that Visitran takes care of generating the correct dialect of SQL for the data warehouse you're working with.
Supported Excel Formulas
Visitran supports a wide range of Excel Formulas organized into categories, including:
- Mathematical Operations - Basic calculations, rounding, and numeric operations
- String Operations - Text manipulation and processing
- Date & Time Functions - Working with temporal data
- Logical Operations - Conditional logic and business rules
- Statistical Functions - Data aggregation and analysis
- Data Cleaning & Formatting - Text standardization and formatting
- Data Type Conversion - Converting between data types
- Data Validation - Quality checks and type validation
- Trigonometric Functions - Angular and geometric calculations
- Bitwise Operations - Binary data manipulation
There's support for over 100 Excel formulas, which cover a wide range of data transformation tasks. The Excel Formula Reference Section has a complete list of all the formulas supported by Visitran.