External table has some great beneficials in different cases, one of the important scenario is with external table you’ll be able to run query in multiple databases. As you know in Azure SQL server you only can run the query for the database that you connected, it means the