IPinfo.io Snowflake UDFs

udf.sql

create or replace secure function IPINFO.PUBLIC.to_join_key(ip text) returns integer as
\$\$
AS_INTEGER(PARSE_IP(CONCAT(ip, '/16'), 'inet'):ipv4_range_start)
\$\$
;

create or replace secure function IPINFO.PUBLIC.to_int(ip text) returns integer as
\$\$
AS_INTEGER(PARSE_IP(ip, 'inet'):ipv4)
\$\$
;

CREATE OR REPLACE SECURE FUNCTION IPINFO.PUBLIC.to_ip(ip integer) RETURNS text AS
\$\$
 (BITAND(BITSHIFTRIGHT(ip,24),255)::text || '.'
 || BITAND(BITSHIFTRIGHT(ip,16),255)::text || '.'
 || BITAND(BITSHIFTRIGHT(ip,8),255)::text || '.'
 || BITAND(ip,255)::text)
\$\$
;