Amazon Redshift Spectrum Now Supports Scalar JSON and Ion Data Types March 9, 2018 By admin You can now use Amazon Redshift Spectrum to directly query scalar JSON and Ion data types stored in external tables in Amazon S3 – without loading or transforming the data.