16.20 - Migrating Data to the JSON Type - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
You can migrate data to the JSON type following these steps:
  1. (Optional) If converting from XML to JSON, the XML data must be stored in CLOB or VARCHAR columns.
  2. Verify that the intended JSON data is well-formed and conforms to the rules of JSON formatting.
  3. Create new versions of the tables using the JSON type for columns that will hold the JSON data.
  4. Insert the JSON text (for example, the JSON constructor or string) into the JSON columns. See also, Loading JSON Data Using Load Utilities.