CSV_TO_JSON Syntax - Analytics Database - Teradata Vantage

DATASET Data Type

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
bka1628112240653.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ekk1458586304878
lifecycle
latest
Product Category
Teradata Vantageā„¢
CSV_TO_JSON ( ON
  ( SELECT CSV_expression select_stmt_options )
  [ USING { SCHEMA ( schema ) | AGGREGATE ( {'Y'|'N'} ) } ]
)

Syntax Elements

CSV_expression
Any expression that evaluates to character data in the CSV format or a DATASET STORAGE FORMAT CSV value.
select_stmt_options
The select_stmt_options are the allowable or necessary options in Vantage for a SQL SELECT statement.
USING
Variables used as input to the SQL statement specified by select_stmt_options.
schema
The CSV schema.
AGGREGATE
Specify AGGREGATE for the output instances to be composed of one row of input data.