Skip to main content

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.

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.

img Generated SQL

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:

  1. The table's columns, along with some sample data
  2. The no-code transformations we performed
  3. 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, including:

  • Basic Math
  • Text Functions
  • Date Functions
  • Logical Functions
  • Financial Functions
  • Statistical Functions
  • Lookup and Reference Functions
  • Information Functions
  • Smart Functions

The exact number supported is 88 formulas. The Excel Formula Reference Section has a list of all the formulas supported by Visitran.