18 - Updating Data Types

The Risk Premium property on your flight alert object is currently an Integer data type. Your team has let you know there may be instances where the value is not a whole number and the schema needs to be updated accordingly. This lesson will step you through the process of making this sort of schema edit.

🔨 Task Instructions

1. Open your “Training Pipeline Simulator” Pipeline Builder file.
2. In the right panel under your flight_alert_{yourname} dataset, click the Edit button.
3. Click on the 1.0 button right before risk_premium.
4. In the dropdown pop-up window, select Integer instead.
5. Then click on your flight_alert_{yourname} dataset in your data lineage to highlight it.
6. Click on the +, between you flight_alerts dataset and your flight_alert_{yourname} dataset, to insert transforms.
7. In the Transform path, enter Cast in your Search transforms and columns field and then click on the Cast option.
8. In the Cast window, select risk_premium as the Expression and Integer as the Type and then Apply.
9. Then go Back to graph using the button at the top right of your Transform path window.
10. A Transform path is now linked to your flight_alerts dataset on the data lineage.
11. Connect the Transform path to the flight_alert_{yourname} dataset by clicking and holding between the right Transform path node and the left flight_alert_{yourname} node.
12. You can now Save all changes and Deploy all pipeline outputs like you did previously.