Clickable link for any string field

I don't believe this is possible.

The field formatter will allow you to use the value of a field as part of a larger template. You can use this turn urls into images, or values into links, but it doesn't offer any way to process the field value, so you couldn't pull out part of the field value... and that wouldn't help in your case anyway.

You also can't use values from other fields. If you could, you might be able to use the id field to create a link to the single document view in Kibana, so that in the table in Discover you see the link to that view. But even then, that view would also just show the link, which doesn't help you.

I can't think of a way to hide that data in Discover (which you will almost certainly want to do anyway so to stop Kibana from processing that large amount of data) but have a view in Kibana that allows you to see it. At least not without writing some custom code, either a standalone field viewer app, or a Kibana plugin to do it for you. But even with that, I'm not sure how you'd link to that view from that field...