I'm trying to query between databases.
Using the following documentation :
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-get-started
When I want to query the external table I created as below:
CREATE DATABASE SCOPED CREDENTIAL Myxxxxxx
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx';
CREATE EXTERNAL DATA SOURCE aaaaaaaaaaa
WITH
(
TYPE=SHARD_MAP_MANAGER,
LOCATION='xxxxxxxx.database.windows.net',
DATABASE_NAME='abc',
CREDENTIAL= Myxxxxxx,
SHARD_MAP_NAME='aaaaaaaaaaa'
);
CREATE EXTERNAL TABLE [dbo].[Dim_abcd]
(
[Col1] [bigint] NOT NULL,
[Col2] [char](9) NULL,
[Col3] [varchar](250) NULL,
[Col4] [varchar](17) NULL,
[Col5] [int] NOT NULL,
)
WITH
(
DATA_SOURCE = aaaaaaaaaaa,
DISTRIBUTION = ROUND_ROBIN
)
GO
While querying i get error message
Error Message :
Error accessing the shard map manager database.
Please verify that the shard map manager database is available.
If it is available, please verify that the definition and affiliated credential are correct for external data source xxxxxxxxxxxxx.
Note : Azure SQL Database is Server1 and Azure Synapse ( Azure SQL data warehouse) is in Server2


