Vantage supports reading and writing data in external object storage such as Amazon S3, Azure Blob storage (including Azure Data Lake Storage Gen2 in Blob Interop Mode), and Google Cloud Storage. Vantage on-premises object storage solutions include: Cloudera, Cloudian HyperStore, Dell EMC/ECS, Hitachi Content Platform, IBM COS, MinIO, NetApp StorageGrid, RedHat Ceph, Scality Ring, VAST Data, and Vcinity.
There are two ways to read and work with data in external object storage:
- You can create a foreign table. A foreign table acts as a registry that maps to an external object storage location. Use a foreign table to query and load CSV, JSON, and Parquet data stored in external object storage. See SQL Data Definition Language.
- You can use READ_NOS to perform ad-hoc queries directly from external object storage. READ_NOS reads data in CSV, JSON, and Parquet formats. READ_NOS also allows you to list all the objects and path structure of external object storage and discover the schema of the data.
To write data from Vantage tables to external object storage, use WRITE_NOS.