Amazon Redshift native support for JSON and semi-structured data is now generally available. It is based on the new data type ‘SUPER’ that allows you to ingest and store semi-structured data in your Amazon Redshift data warehouses. Amazon Redshift also includes support for PartiQL for SQL-compatible access to relational, semi-structured and nested data. Using the SUPER data type and PartiQL in Amazon Redshift, you can perform advanced analytics that combine classic structured SQL data (such as string, numeric, and timestamp) with the semi-structured SUPER data (such as JSON) with superior performance, flexibility, and ease-of-use.
Source:: Amazon AWS