FlyLow_MK on Tue, 13 Dec 2016 21:41:51
I have been using Elastic Queries (Preview) on SQL Azure which is equivalent Cross DB joins on SQL server.
I have some dependency on a app generated schema called stg.abc , schema is a two word separated by ‘.’
I am able to get this working in scenario 1: by creating External DataSource, External table, and use it in a view on DB1 referencing a table on DB2.
In scenario 2, I am facing issues
Msg 46823, Level 16, State 1, Line 22 Error retrieving data from #######.database.windows.net.DBname. The underlying error message received was: 'PdwManagedToNativeInteropException ErrorNumber: 46723, MajorCode: 467, MinorCode: 23, Severity: 16, State: 1, ErrorInfo: EventDescription, Exception of type 'Microsoft.SqlServer.DataWarehouse.Tds.PdwManagedToNativeInteropException' was thrown.'.
Has anyone faced this issue and is there any solution to this?
Alberto Morillo on Wed, 14 Dec 2016 03:00:10
Could you please take a look at the instructions provided on the following article about elastic queries with different schemas?
Hope this helps.
FlyLow_MK on Wed, 14 Dec 2016 21:20:38
thanks for your reply..
I forgot to update this thread. After some read up and little more troubleshooting, i figured out the solution.
solved it by creating [stg.abc] on DB1 and matching the schema names on both the DBs. Create External Table with the Same Schema as the source Table.