question

CharlieThompsonHill-7191 avatar image
0 Votes"
CharlieThompsonHill-7191 asked SaurabhSharma-msft commented

Cannot enable azure synapse link for cosmos DB

To enable azure synapse analytics Link in a cosmosDB account you need to also enable "Diagnostic Full-Text query". If you try and enable it by enableing the synapse link, ARM says it completed but it remains turned off. If you try deploying the Diagnostic Full-Text query I get the following:
117495-image.png


When I try to deploy the resource via ARM using the API version it specifies you get the following:
117496-image.png



This means I cannot use Azure Synapse link.

Does anyone have a solution to this issue because it looks like this is very broken in my tenant.

azure-cosmos-db
image.png (31.0 KiB)
image.png (47.3 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @charliethompsonhill-7191,

Thanks for using Microsoft Q&A !!
I have tried enabling it from Azure Portal for both CosomosDB for existing SQL and MongoDB and it worked fine.
117567-image.png
117438-image.png

Are you following any other documentation ? Can you please share the template you are using as well ?

Thanks
Saurabh

0 Votes 0 ·
image.png (18.5 KiB)
image.png (33.8 KiB)

Hi @charliethompsonhill-7191,
I have not heard back from you. Please let me know if you still have issues.

Thanks
Saurabh

0 Votes 0 ·

Hi @charliethompsonhill-7191,

Please let me know if you still are facing this issue and needs help.

Thanks
Saurabh

0 Votes 0 ·
Show more comments

1 Answer

RodrigoSouza-0745 avatar image
1 Vote"
RodrigoSouza-0745 answered SaurabhSharma-msft commented

Hello everyone.


I confirm that:

  • Synapse Link has no relation with Diagnostic Full-Text query and this option isn't a pre-req to use Synapse Link.

  • The Features tab isn’t working for Synapse Link. We are working on the hot fix.

  • The workarounds are to enable it using the Enable Synapse Link button in the Data Explorer or using CLI:

az cosmosdb update --enable-analytical-storage true --name <database-account-name> --resource-group <resource-group-name>

Tks



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you @rodrigosouza-0745.

@CharlieThompsonHill-3784 Please let me know if you have any questions. Also, please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh


1 Vote 1 ·