Skip to main content

Support Azure Blob storage as a data source similar to S3

  • May 24, 2018 2:16 PM UTC
  • 2 replies
  • 15 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 2:19 PM UTC

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
  • Jun 7, 2018 1:36 AM UTC

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