v.23.8Improvement

Updated Azure Blob Storage Connection String Handling

Updated check for connection string in azureBlobStorage table function as connection string with "sas" does not always begin with the default endpoint and updated connection URL to include "sas" token after adding Azure's container to URL. #51141 (SmitaRKulkarni).
Improved handling of connection strings with SAS tokens in the azureBlobStorage table function, allowing connection URLs that do not start with the default endpoint and correctly appending the SAS token after the Azure container URL.

Why it matters

This update addresses scenarios where the SAS token connection string does not begin with the default Azure endpoint. By enhancing the connection string check and appending the SAS token properly, it ensures reliable and flexible authentication when accessing Azure Blob Storage through ClickHouse, improving compatibility and usability.

How to use it

When using the azureBlobStorage table function, provide the connection string including the SAS token even if it does not start with the default endpoint. The function now correctly processes such connection strings without additional user configuration.