Set up key for Query across cloud databases

Question

Does the database scoped master key and credentials need to be set up on the source database?
elastic-query-vertical-partitioning

Answer 1

You need to do that on the origin database not in the remote database. Imagine you need to query from an Azure SQL database named OriginDatabase a table on another database named RemoteDatabase. You create the master key and the database scoped credential on the OriginDatabase only.