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.
New datasets available on the Registry of Open Data from University of Sydney, International Brain Laboratory, Taiwanese Central Weather Bureau, and others
Read below for 26 new or updated datasets from University of Sydney, International Brain Laboratory, Taiwanese Central Weather Bureau, and others are available on the Registry of Open Data in the following categories.