Step 3: Add more transformations - AWS Glue DataBrew

Step 3: Add more transformations

In this step, you add more transformations to your recipe and publish another version of it. To refine our example, we use the information that not all chess games result in a clear winner; some games are played to a draw.

To add more recipe transformations and republish

  1. From the transformation toolbar, choose Filter, By Condition, Is not to remove the games that were played to a draw.

  2. Set these options as follows:

    • Source column - victory_status

    • Filter condition – Is not draw

    To add this transform to your recipe, choose Apply.

  3. Change the data in victory_status so that it's more meaningful. To do this, from the transformation toolbar choose Clean, Replace, Replace value or pattern.

  4. Set these options as follows:

    • Source column - victory_status

    • Specify values to replace – Value or pattern

    • Value to be replaced - mate

    • Replace with value - checkmate

    To add this transform to your recipe, choose Apply.

  5. Repeat the previous step, but change resign to other player resigned.

  6. Repeat the previous step, but change outoftime to time ran out.

  7. Choose Publish to save your work, at right on the recipe pane.