I probably could have skipped the API calls and just used Snowflake.
I could have used the IP_COMPANY
UDTF to get the unique domain of those IPs. Store that in a CTE, then use those domains to get their IP address ranges. That would have been easier, I think.