I want to connect to two azure synapse analytics instances in paired regions. i want consul to be able to detect the outage or failure and failover to other instances
Check out this tutorial for registering external services into Consul and health checking them using Consul ESM.
You can then use prepared queries to failover to an instance in another region when the local service instance is unavailable.