Private link config for cosmos DB should be set to "sql" and not "cosmosdb" for private appservice deployments

[ivanthelad]

This issue is for a: (mark with an x)

- [ x] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Deploy the demo with the following config

• usePrivateEndpoint = true
• deploymentTarget = appservice

This will result in failure as the groupid defined in the main.bicep is not a valid groupid for private endpoints
*https://github.com/Azure-Samples/azure-search-openai-demo/blob/main/infra/main.bicep#L1097

List of group ids for databases

• https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-dns#databases

The privateendpoint config should look like this

      {
        groupId: 'sql'
        dnsZoneName: 'privatelink.documents.azure.com'
        resourceIds: (useAuthentication && useChatHistoryCosmos) ? [cosmosDb.outputs.resourceId] : []
      }

Any log messages given by the failure

Expected/desired behavior

Private link for cosmos db, SQL, is correctly setup
To fix this, modify the line https://github.com/Azure-Samples/azure-search-openai-demo/blob/main/infra/main.bicep#L1097
to sql instead

      {
        groupId: 'sql'
        dnsZoneName: 'privatelink.documents.azure.com'
        resourceIds: (useAuthentication && useChatHistoryCosmos) ? [cosmosDb.outputs.resourceId] : []
      }

OS and Version?

N/A

azd version?

azd version 1.11.0

Versions

[pamelafox]

Thanks for filing! I've made a PR here:
#2226

Please comment on that if that looks good.