Skip to main content

Support Azure Blob storage as a data source similar to S3

  • May 24, 2018
  • 2 replies
  • 11 views

DieterC
Forum|alt.badge.img+2

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

2 replies

Ben_Vandiver
Forum|alt.badge.img
  • Participating Frequently
  • May 24, 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_H
Forum|alt.badge.img+2
  • Participating Frequently
  • June 7, 2018

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