Data Prep Recipe REST API Developer Guide

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
Data Prep Recipe REST API Overview
Examples
Resources
Requests
Responses
Abstract Bucket Algorithm
Aggregate
Aggregate Node
Aggregate Parameters
Append Mapping
Append Node
Append Parameters
AppendV2 Node
Bucket Date Argument
Bucket Date Bucket
Bucket Dimension Bucket
Bucket Field
Bucket Measure Bucket
Bucket Node
Bucket Parameters
Bucket Setup
Bucket Source Field
Bucket V2
Bucket Term
Bucket V2 Node
Bucket V2 Parameters
Bucket
Cluster Node
Cluster Parameters
Compute Relative Node
Compute Relative Parameters
Compute Relative Sort Parameters
Data Object Category
Detect Sentiment Node
Detect Sentiment Parameters
Discovery Contributor
Discovery Node
Discovery Parameters
Discovery Source
Export Limits
Export Node
Export Parameters
Extension Node
Extension Parameters
Extract Field
Extract Node
Extract Parameter
Extract Parameters
Filter Expression
Filter Node
Filter Parameters
Flatten Field
Flatten Node
Flatten Parameters
Format Date Node
Format Date Parameters
Format Date Pattern
Formula Node
Formula Parameters
Join Node
Join Parameters
Load Analytics Dataset
Load Connected Dataset
Load Data Lake Object
Load Data Model Object
Load Dataset
Load Node
Load Parameters
Legacy Formula Field
Legacy Formula Parameters
Measure To Currency
Optimized Append Node
Optimized Append Parameters
Optimized Update Node
Optimized Update Parameters
Output D360 Fields Mapping
Output D360 Node
Output D360 Parameters
Output Data Cloud Fields Mapping
Output Data Cloud Node
Output Data Cloud Parameters
Output External Field Mapping
Output External Node
Output External Parameters
Pivot
PivotV2
Predict Values Field
Predict Values Input Field
Predict Values Node
Predict Values Parameters
Predict Values Setup
Recipe Collection
Recipe Configuration Collection
Recipe Configuration Fiscal
Recipe Configuration Fiscal Offset
Recipe Configuration
Recipe Conversion Detail
Recipe Definition
Recipe Name Label
Recipe Node
Recipe Notification
Recipe Validation Detail
Recipe
Recommendation Node
Recommendation Parameters
Sample Parameters
Save Dataset
Save Node
Save Parameters
Schema Field Format Symbols
Schema Field
Schema Field New Properties
Schema Field Type Properties
Schema Node
Schema Parameters
Schema Slice
Split Node
Split Parameters
SQL Filter Node
SQL Filter Parameters
SQL Formula Date Field
SQL Formula Field
SQL Formula Parameters
SQL Formula Multivalue Field
SQL Formula Numeric Field
SQL Formula Text Field
Streaming Parameters
Target Field
Time Series Node
Time Series Output Confidence Interval High Low
Time Series Parameters
Time Series V2 Algorithm Parameters
Time Series V2 Forecast Info
Time Series V2 Node
Time Series V2 Parameters
Typecast Node
Typecast Parameters
Typographic Cluster
Update Node
Update Parameters
Appendices
PDF

SQL Formula Field

The base SQL formula field for a recipe node.

Properties

Inherited by SQL Formula Date Field, SQL Formula Multivalue Field, SQL Formula Numeric Field, and SQL Formula Text Field.

Property Name Type Description Filter Group and Version Available Version
default​Value String The default value for the field. Small, v51.0 51.0
formula​Expression String The formula expression. Small, v51.0 51.0
label String The formula label. Small, v51.0 51.0
name String The formula name. Small, v51.0 51.0
type Recipe​Data​Type The recipe data type. Valid values are:
  • Date​Only
  • Date​Time
  • Multivalue
  • Number
  • Text
 Small, v51.0 51.0