/

Data modeling

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

INCREASE DATA TRUST

No/Low Code Editor any team can run

hands-on toolkit

Built-in functions to cover all Use Cases

BETTER INSIGHTS

Data Processing to Data Activation

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.