# Lookup RDNS information from IP addresses from IPinfo’s IP RDNS database on Snowflake

**URL:** <https://community.ipinfo.io/t/lookup-rdns-information-from-ip-addresses-from-ipinfo-s-ip-rdns-database-on-snowflake/1135>\
**Category:** Integrations & Platforms\
**Tags:** snowflake, rdns\
**Created:** [June 20, 2023, 2:42pm UTC](https://community.ipinfo.io/t/lookup-rdns-information-from-ip-addresses-from-ipinfo-s-ip-rdns-database-on-snowflake/1135 "2023-06-20T14:42:12Z")\
**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:** [June 20, 2023, 2:42pm UTC](https://community.ipinfo.io/t/lookup-rdns-information-from-ip-addresses-from-ipinfo-s-ip-rdns-database-on-snowflake/1135/1 "2023-06-20T14:42:12Z")

</div>

On Snowflake, all of our listings come with their own unique UDTF (_**[User Defined Table Functions](https://docs.snowflake.com/en/developer-guide/udf/sql/udf-sql-tabular-functions)**_) that is designed to enrich your IP database in the most efficient way possible. You should exclusively use these UDTFs if you are doing bulk IP data enrichment using our database.

🔗 Please refer to our **[Snowflake Listing Technical Guide](https://ipinfo.io/developers/snowflake_integration)** to learn more.

🔗 **[IPinfo’s Listings on Snowflake Marketplace](https://ipinfo.io/snowflake)**

🔗 **[IPinfo IP to RDNS Database— Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZSTZ3VDMET/)**

## Using the `IP_RDNS_DOMAINS` UDTF for our IPinfo RDNS database

Let’s say your table containing the IP addresses is called `LOGS`, and the column containing the IP address is called `IP`. Based on this, use the provided `IP_RDNS` UDTF from the `public` schema of your IPinfo shared database.

```sql
SELECT *
FROM logs l
LEFT JOIN TABLE(ipinfo.public.IP_RDNS_DOMAINS(l.ip));

```

Please note that, the `ipinfo` on the `ipinfo.public.IP_ASN` can be different for you. It depends on the name you gave to our listing when you purchased it.

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/ipinfo/original/1X/2fcd031bbac6434f7ae954895b75b3cea6c37643.png)

The UDTF format is:

```auto
SELECT <column_containing_ip_addresses>
FROM <input_table> <table.alias>
JOIN TABLE(<data_share_name>.public.<UDTF_name>(<table_alias.column_name>))

```

The UDTF will return the RDNS-related information for IPs which includes:

- Number of domains hosted on the IP based on RDNS data
- Primary domain of the IP

For invalid IP addresses or IP addresses that aren’t included in our database, the outputted table will not include their information

If you want to learn about the technical aspect of how we came up with these UDTFs and the process behind their efficiency, read this article: [How to get IP Data in Snowflake](https://ipinfo.io/blog/ip-address-data-in-snowflake/)