title: Azure SQL Managed Instance Routing Tables
body: <p>I have created a new instance of an Azure SQL Management instance which also create a default routing table as described within <a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-connectivity-architecture#user-defined-routes" rel="nofollow noreferrer">this document</a>.</p>
  
  <p>What our client is trying to achieved is to route all traffic through a CheckPoint firewall so that it can be inspected as shown in the diagram below.</p>
  
  <p><a href="https://i.stack.imgur.com/fPymO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fPymO.png" alt="enter image description here"></a></p>
  
  <p>To achieve this we would need to add a new route that overrides the existing routes to force a next hope for all traffic to the firewall load balancer. Something along the lines of the below.</p>
  
  <blockquote>
    <p>DefaultRoute --> 0.0.0.0/0 --> Firewall Load balancer IP Address</p>
  </blockquote>
  
  <p>Is this something that is supported and if so am I able to remove all other route table entries without adversely effecting the Managed Instance?</p>