Enable SQL DW as data source for external tables in SQL DB
Querying SQL DW from SQL DB via external tables currently does not work due to an implicit SET LANGUAGE statement issued by the elastic queries component. It sets the Language to N'us_english' (not supported) vs. us_english (supported I guess). Same for SET NUMERIC_ROUNDABORT, set to OFF (not supported). While you can explicitly set the NUMERIC_ROUNDABORT to ON at run-time, you cannot do SET LANGUAGE us_english on SQL DB. Maybe other issuesd are to be found but this scenario is important.
This scenario is currently supported. Currently you can externally query SQL DW instances from SQL Database. Can you be more specific about the issue here?
Ivan Fokin commented
Seriously though, Is there a work around?
Work a round available yet?