External File Format | CREATE FOREIGN TABLE | Teradata Vantage - External File Object Rules - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zws1595641486108.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage
External files must be in one of the following formats:
  • JSON
  • CSV
  • Parquet

Field names in CSV and JSON are case sensitive.

Unsupported files and compression types are skipped.

Records that contain errors are skipped. Errors can include mismatched quotation marks (" "), embedded line feeds, and so forth.

External files with UTF-8 BOMs (Byte Order Markers) are supported, but UTF-16LE, UTF-16BE, UTF-32LE, UTF-32BE BOMs are not supported.

Queries return results only for file formats where the format matches the format of the first file specified by the LOCATION option, including:
  • File type (JSON, CSV, or Parquet)
  • File compression (GZIP for JSON or CSV, SNAPPY for Parquet, or uncompressed)
  • Character encoding (LATIN or UTF-8)
  • Field delimiter (comma, tab, and so on)
  • Record delimiter (line feed)