Built-in IP and CIDR functions are generally available on Databricks Runtime 18 LTS+

Databricks now ships native SQL, PySpark and Scala functions for IPv4 and IPv6 addresses and CIDR blocks: parsing, canonicalizing, inspecting, converting to binary, and ip_cidr_contains for containment joins. try_ variants return NULL on bad input instead of failing. They are generally available on Databricks Runtime 18 LTS and above.

Read the original