CSV External Files | CREATE FOREIGN TABLE SQL Statement | Teradata Vantage - CSV External Files - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
jjn1567647976698.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage

Optionally, you can create a schema for CSV data that lacks a header row to specify field (column) names and field delimiter characters. For more information about schemas, see CSV File Headers and Schemas.

You can also specify non-standard field delimiters by using the ROWFORMAT parameter of the USING clause. However, if a field delimiter is also specified in an associated CSV schema, the schema specification takes precedence.

Make sure CSV values that will be used or cast as numeric values are not enclosed in quotes. If you cast a value enclosed in quotes to a numeric, it returns a null value or a skipped record error.

External CSV files can be compressed in GZIP format. Other forms of file compression are not supported.