The following table lists the available DATASET functions and a description of their purpose.
| Function | Description |
|---|---|
| AVRO_CHECK | The AVRO_CHECK function allows you to validate BYTE/VARBYTE/BLOB/DATASET STORAGE FORMAT AVRO data using the Avro specification, and to check the data validity. |
| CreateDATASET | The CreateDATASET function allows for creating DATASET data type instances composed of self-describing data when the schema and data are not included in the data payload. |
| DataSize |
Returns the data length in bytes of any of the following Teradata variable maximum length complex data types:
|
| SchemaEqual | The SchemaEqual function compares CHAR/VARCHAR/CLOB/JSON types representing a self-describing schema for equality. |
| SchemaMatch | The SchemaMatch function compares CHAR/VARCHAR/CLOB/JSON types used to represent a schema for compatibility. |
Note that DATASET Function calls by default do not include the database name (i.e., TD_SYSFNLIB) as a qualifier for the function name. However, if the option is checked on the Variable Creation analysis parameters tab to Include Embedded Services Database, the DATASET function name is qualified by the database name.