Skip to main content
Prequel Import anticipates the case where Source Dataset schemas do not perfectly match target Destination schemas without some mapping and transformation. To support bridging between the two, Prequel supports a number of mapping and transformation options.

​
Who’s responsible for performing the mapping?

Prequel Import provides tooling to support both the Destination owner (you) to perform the mapping, as well as to expose this experience to your users. If you plan to embed this experience for your customers, please see the Customer Experience guide.

​
Custom queries

At a full table level, custom SQL queries can be used to transform the Source data. This is a good solution for users that are comfortable with SQL, or who need aggregations or logic that spans multiple rows.

​
Column mapping

At the row (or “per record”) level, Source columns can be mapped to the target Destination field.

​
Column transformation

Transformations of single or multiple columns can also be defined and mapped to target Destination fields. For example, a Source may have first_name and last_name columns while the target Destination expects a single full_name field. A concatenation like CONCATENATE(first_name, " ", last_name) can be used to transform the Source fields into the expected target shape.