# \[Announcement\] IPinfo’s Extended Databases are now available on Snowflake ❄

**URL:** <https://community.ipinfo.io/t/announcement-ipinfo-s-extended-databases-are-now-available-on-snowflake/696>\
**Category:** Announcement\
**Tags:** database, snowflake, extended-database, ip-geolocation-exten, privacy-extended\
**Created:** [May 30, 2023, 7:39pm UTC](https://community.ipinfo.io/t/announcement-ipinfo-s-extended-databases-are-now-available-on-snowflake/696 "2023-05-30T19:39:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abdullah](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.ipinfo.io/abdullah/32/4973_2.png) [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Post date:** [May 30, 2023, 7:39pm UTC](https://community.ipinfo.io/t/announcement-ipinfo-s-extended-databases-are-now-available-on-snowflake/696/1 "2023-05-30T19:39:16Z")

</div>

# IPinfo’s extended database for geolocation and privacy detection is available on Snowflake

IPinfo’s extended databases provide insights into our data methodology and grant users additional levels of context to our database. Like all our data on Snowflake, these databases come with their own UDTF solutions for optimized IP address lookup operation.

Currently, we have launched the following databases:

- [IPinfo IP to Geolocation Extended database](https://github.com/ipinfo/sample-database/tree/main/IP%20Geolocation%20Extended)
- [IPinfo IP to Privacy Detection Extended database](https://github.com/ipinfo/sample-database/tree/main/Privacy%20Detection%20Extended)

### IPinfo IP to Geolocation Extended Database

IPinfo’s IP to Geolocation extended database comes with the “ **radius”** field that provides an accuracy confidence metric. The radius field provides context to how precise the geolocation data we provide is to their IP geolocation geographic coordinate. It also comes with the `geoname_id` field that provides geolocation context that can be derived from [geonames.org](http://geonames.org)

The UDTF for this database is: `ip_location_extended`

🔗 [Database Schema: IP to Geolocation extended database](https://github.com/ipinfo/sample-database/tree/main/IP%20Geolocation%20Extended)

### IPinfo IP to Privacy Extended Database

The IPinfo IP to Privacy extended database opens up our IP privacy detection models. The database shows what methods we use to identify an IP address to be associated with an anonymous IP service. Going beyond our standard [IP to Privacy Database](https://ipinfo.io/products/anonymous-ip-database), this extended database shows anonymous detection methodology such as:

- Census
- Anycast
- Device Activity
- WHOIS
- VPN Configruation
- Census Port

The UDTF for the IP to Privacy Extended database is: `ip_privacy_extended`

🔗 [Database Schema: IP to Privacy extended database](https://github.com/ipinfo/sample-database/tree/main/Privacy%20Detection%20Extended)

Both of these databases come with our custom-built UDTF functions that facilitate efficient IP address lookups and IP database operations.

## Documentation

🔗 [Community docs on Snowflake](https://community.ipinfo.io/docs?tags=snowflake)

🔗 [IPinfo’s Snowflake Integration](https://ipinfo.io/developers/integrations)

## Request the data

The extended databases are available on the [All in One IP database listing](https://app.snowflake.com/marketplace/listing/GZSTZ3VDMCR/ipinfo-ipinfo-all-in-one-ip-address-database) or can be requested through our [Personalized database listing](https://app.snowflake.com/marketplace/listing/GZSTZ3VDMG3/ipinfo-ipinfo-personalized-ip-address-database).

Reach out to us at [Snowflake@ipinfo.io](mailto:Snowflake@ipinfo.io) to learn more.