We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Support Azure Blob storage as a data source similar to S3 — Vertica Forum

Support Azure Blob storage as a data source similar to S3

Hi forum,
is there a way to COPY data into Vertica from Azure Blob storage similar to what we can do with AWS S3?`

I am searching for the Azure analogon of
=> COPY t FROM 's3://AWS_DataLake/*' ORC;

Please advise
Thank you
Dieter

Comments

  • Ben_VandiverBen_Vandiver Employee
    edited May 2018

    Not yet. If you wanted to build something, writing a UDSource SDK function based on the Azure Blob C++ SDK could be fruitful.
    Edit: Worth noting, sadly the UDSource won't work with ORC.

  • Bryan_HBryan_H Vertica Employee Administrator

    You could try an S3 API wrapper for Azure, e.g. https://minio.io/azure.html

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file