You can now create a view that spans Amazon Redshift and Redshift Spectrum external tables. With late-binding views, table binding will take place at runtime, providing your users and applications with seamless access to query data. Late-binding views allows you to drop and make changes to referenced tables without affecting the views. With this feature, you can query frequently accessed data in your Amazon Redshift cluster and less-frequently accessed data in Amazon S3, using a single view. Simply archive historical data to Amazon S3, create an external table referencing the relevant files, and then create a view referencing both the Amazon Redshift and the Redshift Spectrum external tables.
from What's New http://ift.tt/2wvnEsy
No comments:
Post a Comment