Transformation script workflow

At a high level, creating a transformation script and running it against your project data set involves the following steps:

  1. Create a transformation script using transforms and optionally custom transform functions.
  2. Use preview to debug your transformation and view its effects on your data.
  3. Save the transformation to your transformation script.
  4. Edit your transformation script by rearranging, modifying, and deleting individual transformations.
  5. Run your script against the project data set. This updates your copy of the project data set and makes it available in Discover area of Studio.
  6. Optionally, create a new data set based on the transformed data. This makes the transformed data set available in the Catalog for other Studio users. See Creating a new data set from the transformed data.
  7. Optionally, publish the transformation script to share it with other Studio users who are working with similar data sets. See Publishing a transformation script.