Transform agent
View how to explore and transform your data in plain English, without writing SQL or waiting on another team.
How the transform agent works in Drivetrain
Pick a dataset from any of your connected sources, and you’re ready to go. Everything below works from there.
Open a connected dataset to inspect it
- Pick any connected data source and open one of its datasets.
- See the columns and rows in a spreadsheet-like table before you change anything.
Explore data by asking Drive AI in plain English
- Ask a question about the dataset in plain English, such as which customers have the largest contracts.
- Drive AI filters, ranks and sorts the table to answer it, and explains each change it made.
Refine results with follow-up prompts
- Ask a follow-up question, and Drive AI keeps the context of the one before it.
- Drive AI updates the same result rather than starting over.
Review and remove changes to the data
- Every prompt is recorded as a change, described in plain English along with the logic behind it.
- Remove a change, and the table goes back to how it looked before.
Add a calculated column with a plain English prompt
- Describe the column you need, and Drive AI builds the formula and applies it to every row.
- Drive AI explains what the new column shows and how it can be used.
Check the generated SQL and refine the logic
- Open the new column to see the SQL that Drive AI generated for it.
- Describe the logic more precisely, such as which dates to compare, and Drive AI updates the calculation.
- Save the changes once the dataset is ready for analysis.
How Drivetrain simplifies data transformation
Add calculated columns by describing the logic in plain English, without writing SQL.
Get data ready for analysis yourself, without waiting on data or engineering teams.
See every change made to your data, with the logic behind it, and remove any you don't need.
FAQs
Can Drivetrain transform data without SQL?
Yes. You describe the change in plain English, and Drive AI writes the SQL and applies it to the dataset. You can open the generated SQL at any time to check it.
Can Drivetrain answer questions about a dataset in plain English?
Yes. Ask a question such as which customers have the largest contracts, and Drive AI filters and sorts the table to answer it. Follow-up questions keep the context of the earlier ones.
Can Drivetrain add a calculated column to a dataset?
Yes. Describe the column you need, and Drive AI builds the formula and applies it to every row. If the result isn't quite right, describe the logic more precisely and Drive AI updates the calculation.
Can Drivetrain show what has changed in a dataset?
Yes. Every change is listed in plain English along with the logic behind it. You can remove a change, and the data goes back to how it looked before.
Which data sources can Drivetrain transform data from?
Any connected data source. Sources such as Google Sheets, Salesforce, BambooHR and NetSuite appear alongside datasets already in Drivetrain, and each dataset can be explored and transformed the same way.
See Drivetrain in action
Fewer spreadsheets, faster planning, better decisions.
