Get IP address ranges from the RDNS database on Snowflake by looking up domains/websites

[Abdullah]

Lookup RDNS data from domain lookup.

IPinfo IP to RDNS Database— Snowflake Marketplace

WITH domains (website) AS (
    SELECT *
    FROM 
    (VALUES
        ('vercel.com'),
        ('netlify.com')
    )
)

SELECT rdns.*
FROM domains
JOIN ipinfo.public.IP_RDNS_DOMAINS rdns
ON rdns.domain=domains.website;