External Table in ADX
Hi, I'm trying to create an external table in ADX which uses a Synapse Analytics (SA) database view (called undelivered). The undelivered view itself is query data from a Cosmos analytical store I've create a user defined idenity Added the identiy to the ADX cluster, SA and Cosmos Updated the ADX database: .alter-merge cluster policy managed_identity[ { "ObjectId": "a3d7ddcd-d625-4715-be6f-c099c56e1567", "AllowedUsages": "ExternalTable" } ] Created the database users in SA -- Create a database user for the ADX Managed Identity CREATE USER [adx-synapse-identity] FROM EXTERNAL PROVIDER; -- Grant read permissions ALTER ROLE db_datareader ADD MEMBER [adx-synapse-identity]; GRANT SELECT ON OBJECT::undelivered TO [adx-synapse-identity]; From within SA I can "SELECT * FROM undelivered" and the correct information is returned But when I come to create the external table in ADX: .create-or-alter external table MyExternalTable ( Status: string ) kind=sql table=undelivered ( h@'Server=tcp:synapse-xxxxx.sql.azuresynapse.net,1433;Database="Registration";ManagedIdentityClientId=<key>;Authentication=Active Directory Managed Identity;' ) with ( managed_identity = "<key>" ) I get the error: Managed Identity 'system' is not allowed by the managed_identity policy for usage: ExternalTable So even with me specifying the managed identity I want to use it is still trying to use the system one. How can I get the external table created with the correct managed identity? Any questions please just ask Thanks
Cost of Azure Synapse Analytics when using Azure Synapse Link question
Hi, I'm planning to use Azure Synapse Link to connect to our Dataverse. This is to copy data to a Data Lake so we can export the information later. The link is at https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-synapse. The prerequisites are to get a Data Lake (storage) account and Azure Synapse workspace. I tried to get the pricing info from the Azure calculator (https://azure.microsoft.com/en-ca/pricing/calculator), but wasn't sure if I need all the features it includes. I only need it to transfer data and don't need the analytics part of it. I was wondering roughly how much Synapse would cost if I use it only for the Azure Synapse Link? Jason
