Azure-Samples / Azure-Samples/azure-sql-db-openai
calling sp_invoke_external_rest_endpoint for a private endpoint
- Dominant language
- TSQL
- Stars
- 94
- Forks
- 43
- PR merge metrics
- No merged PRs in 30d
Description
Not sure if this is available and not documented, or an unsupported configuration, but I'd like to be able to use sp_invoke_external_rest_endpoint against a private endpoint rather than the public endpoint for my Azure openai service.
With public endpoints disabled, and a private endpoint available, a sql server in the same vnet hits the services public endpoint and there doesn't seem to be any well documented mechanism to specify outbound routing - all network config options relate to inbound
Is there any way to achieve this?
Contributor guide
Research direction
Start by investigating the named sp_invoke_external_rest_endpoint procedure and Azure private endpoint and outbound-routing documentation. Determine whether Azure SQL can reach the private Azure OpenAI endpoint with public access disabled, and whether the supported configuration is documented. Done means establishing a documented supported approach or confirming that the capability is unavailable.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- cloud, database, networking
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100