Advertising routes by hostname

Has anyone figured out a way to dynamically update advertised routes by resolving a hostname? Something akin to OpenVPNs allow-pull-fqdn.

One of our vendors (Snowflake) claims that they do not use stable IPs and instead only guarantees a stable hostname. I would like to set up a tunnel to route traffic to this vendor through a specific endpoint without making that endpoint an exit node. Best I could come up with is a script that resolves the hostname and calls the tailscale CLI to advertise an updated route, but I can’t find any documentation on how frequently I should be running it or if there are better alternatives for what I am trying to accomplish.