Example: Publishing Table Columns - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
des1556232910526.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢

In this example using DATASET STORAGE FORMAT Avro, not all of the table columns are published.

SELECT * FROM DATASET_PUBLISH
(
	ON (SELECT empName, empDept FROM employeeTable)
	RETURNS (data DATASET STORAGE FORMAT Avro)
) AS avroFiles;

data
7B2274797065223A226172726179222C226974656D73223A7B2274797065223A227265636F7264222C226E616D65223A227265635F30222C226669656C6473223A5B7B226E616D65223A22656D704E616D65222C2274797065223A22737472696E67227D2C7B226E616D65223A22656D7044657074222C2274797065223A22737472696E67227D5D7D7D0006001847656F72676520536D697468144163636F756E74696E67021C5061756C696E65204B72616D6572044852041853746576656E204D617A7A6F16456E67696E656572696E6700

This example uses DATASET STORAGE FORMAT CSV:

SELECT * FROM DATASET_PUBLISH
(
	ON (SELECT empName, empDept FROM employeeTable)
	RETURNS (data DATASET STORAGE FORMAT CSV)
) AS csvFiles;
fileSchema fileData
Null

empName,empDept

George Smith,Accounting

Pauline Kramer,HR

Steven Mazzo,Engineering