Page tree

Trifacta Dataprep


On April 28, 2021, Google changed the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.


In this documentation, working examples are complete Wrangle  commands. Example:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula (2 + 3)
Parameter: New column name 'five'

All syntax commands use the following generalized structure:

Transformation Name [Search Term in Transform Builder]
Parameter: param1 param_value1
Parameter: param2 FUNCTION_NAME(arg1,[arg2])
Parameter: param3 (expression)
Parameter: param4 'param_value4'

  • Inputs:
    • For transformations, inputs are called parameters.
    • For functions, inputs are called arguments.
  • Function names are written in ALL CAPS.
  • Square brackets [like this] indicate optional parameters or arguments.
  • Parentheses are used:
    • To bracket function inputs
    • To bracket expressions, such as myCol >= 4. In some of these instances, parentheses may be optional. 
  • A vertical pipe (|) may be used between parameters or arguments that are paired. Typically, one of them may be used, but not both.

This page has no comments.