.png){kind=icon}
Combine data from multiple sources, join tables, manipulate data, cast data types, and craft new calculated fields, measures etc.
.png){kind=small}
Write code with ease, with the editor highlighting keywords and suggesting relevant options as you type.
.png){kind=small}
Test specific parts of your query by selecting them and running it allowing you to iterate and refine your transformations
Also you can track jobs for both successful queries and any errors encountered.
Easily search for tables, view column details, and add them directly to your queries with a simple double-click.
Define local and global variables to hold reusable values, keeping your code organised, efficient and reducing redundancy.
Schedule your SQL transforms to run automatically at predefined intervals, such as hourly, daily, weekly, or at a custom interval ensuring always up-to-date data for analysis.
%201.png)
View a detailed history of all actions performed on your SQL transforms, including creation, editing, execution, and any errors encountered.
Track all actions, identify who made changes, and foster effective collaboration within your team.
SQL Transform offers a range of advanced settings to tailor your data manipulation process to your specific needs.
Working with external tables?
Utilise the Cleanup feature to automatically remove existing data before executing your script and recreate it afterwards, maintaining data integrity.
Dropping tables to refresh data in query can disrupt reports that rely on those tables.
With Managed Data Loading, Sprinkle handles data transfer between a temporary table and your final table, ensuring that reports remain functional during transformations.
For large datasets, leverage Incremental Processing.
This feature focuses on updating only new or changed data, significantly reducing processing time and resource usage.
Some of the most memorable reviews we have received from our customers.
Balkrishna Jeph
VP Engineering (ML/AI) @ BrightMoney
Nikita Gupta
Senior data analyst @ LeadSquared
.jpeg)
Joel Dominic Pereira
Operations Specialist @ Yulu
