Extend

The extend operator creates calculated columns and appends them to the result set. To create a new column (is_female), use the query below:

Here are a few other examples to try:

• extend get_specific_month = getmonth(birth_date)
• extend IsIPv4Prefix = ipv4_is_in_range(ip_address) == true
• extend returns_clock_time = now(-5d)

To learn more, see the extend docs.