CreateDATASET Syntax - Analytics Database - Teradata Vantage

CreateDATASET (
  schema_expression,
  data_expression,
  { AVRO | CSV [ , { LATIN | UNICODE } ] }
)

Syntax Elements

schema_expression

Any expression that evaluates to the following Teradata data types conforming to the schema specifications:

• CHAR
• VARCHAR
• CLOB
• JSON
• BYTE
• VARBYTE
• BLOB

If the Schema parameter is null, it is assumed the instance is being loaded into a column with a column-based schema. If not, and you use the instance without providing a schema (for example, writing the instance out to a table, or searching using dot notation), an error occurs.

The schema data is provided as a CHAR/VARCHAR/CLOB in either the LATIN or UNICODE character set, or as a BYTE/VARBYTE/BLOB representing the UTF8 encoding of the schema. The schemas provided as BYTE/VARBYTE/BLOB data are not null-terminated.

data_expression

Any expression that evaluates to Teradata BYTE/VARBYTE/BLOB/CLOB data.

A BYTE/VARBYTE/BLOB containing the binary-encoded self-describing data value. Data can be specified in any way Vantage currently allows for function parameters. If validation is enabled, and a null value does not complete the specified schema, an error occurs. Otherwise, the data is accepted.

AVRO

CSV

Specify the name of the storage format. Any other value, including a null or omitted value, are invalid.

LATIN

UNICODE

The character set of the created CSV DATASET value, either LATIN or UNICODE. You can specify the character set only for the CSV storage format. If this parameter is omitted for a CSV value, the CSV value is created in the default server character set.