Display INT as IPv4 Dot-decimal notation INET_NTOA

Get Help
1

Metabase version v0.37.4
MySQL

My DB stores ipv4 addresses an integer. INET_ATON
In Metabase how do I easily convert the integer to ipv4 dot-decimal notation when displayed in a question result?

Ideally, I would like to be able to click the column drop-down for the IP Address column > Formatting > INET_NTOA

If this is not the right way to use Metabase, I would appreciate some guidance on what I am doing wrong.

2

Hi @metabong
It would require something like this to be implemented, so custom formatting could be applied:
https://github.com/metabase/metabase/issues/14054 - upvote by clicking :+1: on the first post
Very related: https://github.com/metabase/metabase/issues/10640

Until then, you would have to create a database View, so Metabase just received the IP-address.

1 Like