Data Pipeline Transformation

Data Pipeline now includes a Transformation step — reshape incoming data using JavaScript before it lands in Fountain, with Dataset-based lookups for value translation. No external middleware required.

When source data doesn't match Fountain's expected format, teams have relied on external tools to clean and transform it first. Transformation brings that capability natively into the pipeline.

What's new

• JavaScript transformation step — add transformation scripts to handle non-1:1 inputs: reformat dates, change casing, split or concatenate fields

• Handle messy source data without middleware — pipelines no longer require near-perfect input to map to Fountain attributes

• Dataset-based lookups — reuse Datasets as lookup tables to translate incoming values into Fountain-expected formats

Why it matters

Integration teams frequently encounter format mismatches that have required a middleware layer to resolve. Transformation removes that dependency, enabling faster and more scalable integrations built entirely within Fountain.

Availability

Available to all Fountain customers.