Recently AWS announced the public preview of AWS Data Exchange for Amazon Redshift. This new feature enables customers to find and subscribe to third-party data in AWS Data Exchange to query in an Amazon Redshift data warehouse.
AWS Data Exchange is a service designed to make it easier for customers to find, subscribe to, and use data from external sources. And Amazon Redshift is a fully-managed, petabyte-scale data warehouse service that allows businesses to store all of their data in one location and then analyze it quickly and easily using Structured Query Language-based tools.
Now with AWS Data Exchange for Amazon Redshift, customers can combine their own data with the third-party datasets found in the AWS Data Exchange without worrying about the complex extract, transact, and load processes generally involved in data integration.
Furthermore, customers can:
- Access more than 3,600 third-party datasets in the AWS Data Exchange catalog, with categories such as financial services, retail, location and marketing, public sector, healthcare, manufacturing, and so on
- Benefit from directly querying provider data warehouses and can confidently use the latest data being offered
- Leverage automated entitlement, billing, and payment management. For example, access to Amazon Redshift data is granted when a data subscription starts and is removed when it ends, invoices are automatically generated, and payments are automatically collected and disbursed through AWS Marketplace.
Source: https://aws.amazon.com/redshift/features/aws-data-exchange-for-amazon-redshift/
In an AWS News blog post on AWS Data Exchange for Amazon Redshift, Jeff Barr, chief evangelist for AWS, wrote:
… it was cool to realize just how many existing aspects of Redshift, and Data Exchange played central roles. Because Redshift has a clean separation of storage and compute, along with built-in data sharing features, the data provider allocates and pays for storage, and the data subscriber does the same for compute. The provider does not need to scale their cluster in proportion to the size of their subscriber base, and can focus on acquiring and providing data.
Currently, AWS Data Exchange for Amazon Redshift is available for preview in its US East (N. Virginia), US East (Ohio), US West (Northern California), US West (Oregon), Asia Pacific (Seoul), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), Europe (Frankfurt), Europe (Ireland) and Europe (London) regions. In addition, more details are available in the documentation.
