JSON

JSON (JavaScript Object Notation) is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays (or other serializable values).

It is a common data format with diverse uses in electronic data interchange, including that of web applications with servers.

Greenplum

data types we support

Integral
bigint
int
decimal
decimal
double
float
text
ntext
Binary
binary (graphic)
varbinary (varbin, binary varying)
Date/Time
timestamp
Large objects
byte array
ntext
Other
boolean
timespan