Amazon Redshift, a fully-managed cloud data warehouse, announces preview of native support for JSON and semi-structured data. It is based on the new data type ‘SUPER’ that allows you to store the semi-structured data in Redshift tables. Redshift also adds support for the PartiQL query language to seamlessly query and process the semi-structured data. This functionality enables you to achieve advanced analytics that combine the classic structured SQL data (such as strings, numerics, and timestamps) with the semi-structured SUPER data with superior performance, flexibility, and ease-of-use.
Source:: Amazon AWS