Skip to content

azureBlobStorage table function doc issues #3029

Open
@jpds

Description

@jpds

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    P2main-repo-transferredIssues which were transferred from the main repo

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions