Working with External Data | SELECT SQL Statement | Teradata Vantage - Working with External Data - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

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: Cloudera, Cloudian HyperStore, Dell EMC/ECS, Hitachi Content Platform, IBM COS, MinIO, NetApp StorageGrid, RedHat Ceph, Scality Ring, VAST Data, and Vcinity VAccess.

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 store location. Use a foreign table to query and load CSV, JSON, and Parquet data stored in an external object store. See Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
  • 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.