Using SUPER data type with materialized views - Amazon Redshift

Using SUPER data type with materialized views

Amazon Redshift extends the capability of materialized views to work with the SUPER data type and PartiQL in materialized views. SQL and PartiQL queries can be precomputed using incremental materialized views. For more information about materialized views, see Creating materialized views in Amazon Redshift.

Once you have stored your schemaless and semistructured data into SUPER, you can use PartiQL materialized views to introspect the data and shred them into materialized views.