**On January 27, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.**

The following example demonstrates how the `POW`

and `SQRT`

functions work together to compute the hypotenuse of a right triangle using the Pythagorean theorem.

`POW`

- X^{Y}. In this case, 10 to the power of the previous one. See POW Function .`SQRT`

- computes the square root of the input value. See SQRT Function.

The Pythagorean theorem states that in a right triangle the length of each side (x,y) and of the hypotenuse (z) can be represented as the following:

*z ^{2} = x ^{2} + y ^{2} *

Therefore, the length of z can be expressed as the following:

*z = sqrt(x ^{2} + y ^{2} )*

**Source:**

The dataset below contains values for x and y:

X | Y |
---|---|

3 | 4 |

4 | 9 |

8 | 10 |

30 | 40 |

**Transformation:**

You can use the following transformation to generate values for z^{2}.

**NOTE: **Do not add this step to your recipe right now.

Transformation Name | `New formula` |
---|---|

Parameter: Formula type | `Single row formula` |

Parameter: Formula | `(POW(x,2) + POW(y,2))` |

Parameter: New column name | `'Z'` |

You can see how column Z is generated as the sum of squares of the other two columns, which yields z^{2}.

Now, edit the transformation to wrap the value computation in a `SQRT`

function. This step is done to compute the value for *z*, which is the distance between the two points based on the Pythagorean theorem.

Transformation Name | `New formula` |
---|---|

Parameter: Formula type | `Single row formula` |

Parameter: Formula | `SQRT((POW(x,2) + POW(y,2)))` |

Parameter: New column name | `'Z'` |

**Results:**

X | Y | Z |
---|---|---|

3 | 4 | 5 |

4 | 9 | 9.848857801796104 |

8 | 10 | 12.806248474865697 |

30 | 40 | 50 |

This page has no comments.