Model
Model Your Data Without Code
Empower anyone to clean and transform data from disparate sources without friction.
No credit card required.
Loved by 100+ data teams across all industries






Loved by 100+ data teams across all industries






INCREASE DATA TRUST
No/Low Code Editor any team can run
- Cooperate on operational analytics with any team
- Ever-growing list of functions (SQL, NoSQL, Python)
- Build, sync and automate your data flows in one tool

hands-on toolkit
Built-in functions to cover all Use Cases
- Combine, clean, aggregate and transform all your data
- Whether technical or not, run data models autonomously
- Documentation, Slack community and In-App Support


BETTER INSIGHTS
Data Processing to Data Activation
- A transformation layer on top of your data sources
- Use Data Preview & Logs at each modeling's step
- Save and automate your models in a couple of clicks
How Does It Work?
Set up your pipelines thanks to our ever-growing library of functions.

Step 1
Enter a name for your Pipeline
Add a description to your pipeline to collaborate easily with teammates.

Step 2
Source: Select a Connector as Source
Drag-and-drop the Input operation to select sources and tables to be used in your data model.
Combine, mix or aggregate multiple sources by using the Join operation.

Step 3
Model: No Code Editor to Transform your data
Use Drag-and-drop (SQL, NoSQL & Python) operations to clean and transform your input data in actionable data models.Â

Step 4
Preview your data at any transformation step
Click on Play button to run your pipeline and see the results of your transformations.

Step 5
Destination: Select a Connector as Destination
Drag-and-drop the Output operation to select connectors and tables to be used as Destinations at the end of your data model.

Step 6
Click on Run button to compute and sync the entire pipeline.
Once your run completed, click on Logs to see what happened in your pipeline.
Full Capabilities
Get easily started with a wide range of built-in features to get the most out of your data models
No Code editor
Use drag-and-drop functions to be empowered with SQL, NoSQL and Python capabilities at full throttle.
Preview mode
Our preview mode provides you with the query results at each transformation step.
SQL alternative
A full SQL editor is also available for proficient users to easily create their data models.
Reusable pipelines
Just duplicate the pipelines (data models) and share them with relevant teams.
Versioning
Choose the draft or production mode for each data model to test, iterate and validate with confidence.
Access and sharing panel
Enterprise-grade panel to control and share access to the right users.
Functions
Find out the functions you need to activate your data.
- All
- Table Operations
- Column Operations

Abs
Returns the absolute value of the column values.

Add Column
Returns new column with "value."
 

Add Date
Returns new column by adding days, months or years.

Array Elemt At
Returns the element at the specified array index.

Between
Returns boolean if columnInput is between intervals.

Capitalize
Returns the string with the first letter in capital.

Cast
Returns the column input in the newType.
 

Cast To Date
Returns the string Input in Date format.
 

Cubic Root
Returns the cubic root of the column values.
 

Ceil
Returns the integer greater than the column values.

Column Name
Returns the name of the column at the index position.

Column Number
Returns the index of the columnInput.
 

Concatenation
Returns the concatenation of the 2 operand.
 

Convert Date
Converts field in selected date type.
 

Convert String To Array
Returns array for each string element of the inputColumn.

Convert String To Structure
Returns structure (JSON object) for each string element of the inputColumn.

Correlation
Returns the correlation between the 2 operand column.

Correlation Matrix
Returns the correlation matrix between all input columns.

Count
Returns the disctinct values in the selected column.

Create Date
Returns the date in the initialDateType.
 

Cube
Returns a GroupBy with subtotals for all combinations of grouping columns.

Date Diff
Returns the difference between the 2 operand Date in days or months or years.Â

Decode
Decode the inputColumn (binary data) in the charset type.

Divide
Returns the operand 1 divide by operand 2.
 

Drop Column
Returns the Dataframe without the selected column.

Drop Duplicates
Returns the table without the duplicated element in columnInput.

Drop NA
Returns the table without the NA rows for the columnInput.

Encode
Encode inputColumn in binary data.
 

Except
Returns A - B Table, where A is the left input and B the right one.

Explode
Returns a new row for each element in the given array or map column.

Explode Outer
Like Explode Function but if the array/map is null or empty then null is produced.

Exponential
Returns the exponential of the column values.
 

Fill NA
Returns the table where NA value is replaced by "value".

Filter SQL
Returns the element that match with filter SQL.

Floor
Returns the integer les or equal to the column values.

Group by
Combines rows into groups based on matching values in specified columns.

Handle Array Structure
Returns one column for each element in array InputColumn (depends of depth).

Input
Load your connected data as sources in your pipelines.

Intersect
Returns all records which are in both tables.
 

Is Lower
Returns True if all cased characters in the string are lowercase.

Is Numeric
Returns true if the element in the columnInput is numeric.

Is Unique
Returns true if the element is unique in columnInput.

Is Upper
Returns True if all cased characters in the string are uppercase.

Join
Returns all records that have matching values in both tables.

JSON Normalize
Returns one column for each element in object InputColumn (depends of depth).

Left Trim
Removes the space character from the start of a string.

Length
Returns length of the element in the columnInput.

Limit
Returns the table with "nrows" number of rows.

Log
Returns the logarithm of the column values.
 

Logical AND
Returns true when both of the columns are true, otherwise returns false.

Logical NOT
Returns new column with true if false and false if true.

Logical OR
Returns true when either of the columns is true, Returns false when both are false.

Logica XOR
Returns true when one of the columns is true. Returns false when both are false or are true.

Lower
Return the string in lowercase letter.
 

Minus
Returns the substraction of the 2 operand.
 

Modulo
Returns the result of the operand 1 modulo operand 2.

Multiply
Returns the multiplication of the 2 operand.
 

Normal DistributionDFOP
Returns table with the normal distribution N(mean,std) for each columnOutput.

Normal DistributionOP
Returns array with the normal distribution N(mean,std).

Order
Returns the table with sorted columnName.
 

Outliers Detection Interquartile
Returns boolean, if the field is between the interquartile range.

Outliers Detection_Quantile
Returns boolean, if the field is between the interval defined by quantile (min and max).

Outliers Detection_Std
Returns boolean, if the field is between the interval [mean - (nSTD); mean + (nSTD)].

Pivot
Transform selected column in multiple column for each different value.

Plus
Returns the addition of the 2 operand.
 

Power
Returns the power of the column values.
 

Quotient
Returns quotient of the division of operand1 by operand2.

Random Column
Returns new column with rand number between low and high.

Regex Match
Returns column with regular expression if match or not.

Regex Replace
Returns the columnInput values and replace the regular expression with replaceValue.

Rename Column
Returns the columnInput with the newName.
 

Rigth Trim
Removes the space character from the end of a string.

Rollup
Like Cube function but Roll up does not create all possible grouping sets.

Round
Returns rounded values with "position" number after comma.

Sample
Returns sample of the table where each rows have "fraction" probability to be displayed.

Select Column
Returns the selected columns.
 

Sequence
Create a sequence between 1 and NROW (the number of rows).

Slice
Returns partition of the table based on the 4 values.

Sort Columns
Returns the table with sorted columns.
 

Split String
Returns the string separate by "," (the string is split with the sep parameters).

Square Root
Returns the square root of the column values.
 

Subs (Array, Object...)
Creates an Array or Object.
 

Substring
Returns new column with the subString.
 

Trim
Removes the space character from the start or end of a string.

Trunc
Truncates a number to a whole integer or to a specified decimal place.

Uniform Distributiondfop
Returns table with the uniform distribution U(min,max) for each columnOutput.

Union
Returns the row-concatenation of the 2 inputs results.

Unique
Returns array with the uniques values of the inputColumn.

Unpivot
Returns rotating columns of a table-valued expression into column values.

Upper
Returns the string in capital letter.
 

Windowing Aggregation
Perform a calculation over a group of records called window.

Windowing Analytical
Computes values over a group of rows and returns a single result for each row.

Windowing Ranking
Assigns a rank to each row within a partition of a result set.
Build better data pipelines
With RestApp, be your team’s data hero by activating insights from raw data sources.