Our SQL Serverless installation has sporadic failures to our blob container in Azure. The blob container is locked down to a vnet, and we are using the private endpoint to enable serverless access. It will work fine for several hours, and then show the error below. Stopping and starting the warehouse resolves the issue. This only started about last week. Is this a known issue, and are there any workarounds?
FAILED_PRECONDITION: HTTP error: 400 body:
"error": "code":"AccountRequiresHttps","message":"The account being accessed does not support http.
This is an external table using abfs://
delta.autoOptimize.autoCompact=true
delta.autoOptimize.optimizeWrite=true
delta.columnMapping.maxColumnId=37
delta.columnMapping.mode=name
delta.minReaderVersion=2
delta.minWriterVersion=5
delta.tuneFileSizesForRewrites=true