clickhouse-docs icon indicating copy to clipboard operation
clickhouse-docs copied to clipboard

azureBlobStorage table function doc issues

Open jpds opened this issue 1 year ago • 0 comments

The azureBlobStorage table function guide in its current form has several errors:

  1. If I run this with what appears to be the three required function parameters:
SELECT * FROM azureBlobStorage("https://mystorage.blob.core.windows.net/", "mycontainer", "myblobpath")

I am simply told:

"This is no named collection https://mystorage.blob.core.windows.net/"

  1. azurite references should not be used in this document, because port numbers, for example, are not a thing in Azure Blob Storage. Instead maybe one of the open datasets should be used as an example: https://learn.microsoft.com/en-us/azure/open-datasets/dataset-catalog

  2. I had no idea what a named collection was, I was initially confused that it was some Azure storage I had never heard about. Until I took a quick look at the S3 document - there needs to be a link to the named-collections page

  3. I was eventually able to create a named collection like this for Azure:

CREATE NAMED COLLECTION azurebucket AS
storage_account_url = 'https://mystorage.blob.core.windows.net',
container = 'mycontainer',
blob_path = 'myfile.json',
account_name = 'mystorage',
account_key = 'sjdfklsdjflsk3423kledjrql...=='

However note that some of there parameters do not correspond to what's in the documented function call.

jpds avatar Sep 12 '24 22:09 jpds