In my previous post, l wrote about how to create linked server between On-premise and Azure SQL database.
In this post, let us see how to create linked server between On-premise and Azure SQL data warehouse and after establishing linked server, how we can query Azure SQL data warehouse tables from local On-premise SQL Server.
I have created Azure SQL data warehouse in my previous post and for this example I have created table "dwtable1" within azure sql dw.
Below are the steps to publish linked server connection between On-premise and azure sql dw.
In this post, let us see how to create linked server between On-premise and Azure SQL data warehouse and after establishing linked server, how we can query Azure SQL data warehouse tables from local On-premise SQL Server.
I have created Azure SQL data warehouse in my previous post and for this example I have created table "dwtable1" within azure sql dw.
Below are the steps to publish linked server connection between On-premise and azure sql dw.