Posted On: Mar 8, 2018

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.  

Redshift Spectrum, a feature of Amazon Redshift, enables you to use your existing Business Intelligence tools to analyze data stored in your Amazon S3 data lake. For example, you can now directly query JSON and Ion data, such as client weblogs, stored in S3 to gain deeper insights from the data. To learn more about how to leverage the new data formats, visit the Amazon Redshift documentation.

JSON is an open-standard file format commonly used for asynchronous browser-server communication. Ion is a data serialization format developed by Amazon nearly a decade ago to provide unambiguous semantics for long-term preservation of data. The Ion text format is a superset of JSON; thus, any valid JSON document is also a valid Ion document. 

Amazon Redshift Spectrum is available in AWS Regions US East (Northern Virginia), US East (Ohio), US West (Northern California), US West (Oregon), Canada (Central), EU (Frankfurt), EU (Ireland), EU (London), Asia Pacific (Seoul), Asia Pacific (Singapore), Asia Pacific (Sydney), and Asia Pacific (Tokyo).