Vantage supports reading and writing data in external, cloud-based 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 store solutions include: Hitachi Content Platform, MinIO, Dell EMC/ECS, NetApp StorageGrid, and IBM COS.
There are two ways to read and work with data in external 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 an external object store.
- You can use READ_NOS to perform ad-hoc queries directly from an external object store. READ_NOS reads data in CSV, JSON, and Parquet formats. READ_NOS also allows you to list all the objects and path structure of an object store and discover the schema of the data.
To write data from Vantage tables to external storage, use WRITE_NOS.
You can create an error table against a foreign table for error diagnosis. For information about the CREATE ERROR TABLE statement, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144 and Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.