CODEWITHSUNDEEP
azuredata-warehouse
Mark Henry
Mark Henry

Reputation: 9

Cross Database Queries are possible

Can I do cross database queries from a Azure SQL Database to Azure SQL Data warehouse, I read somewhere that its possible around sql databases but can it be possible in azure datawarehouse and sql database.

Upvotes: 0

Views: 177

Answers (1)

jspinella
jspinella

Reputation: 2413

It is a "thing" with MS SQL databases, achieved via links using special credentials and external tables (which essentially map a foreign DB's tables to the local DB). It didn't used to be possible in Azure, but it is nowadays.

For more info, see here

Upvotes: 1

Related Questions