Amazon Redshift now supports late-binding views referencing Amazon Redshift and Redshift Spectrum external tables
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.
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.
Late binding views is available in US East (N. Virginia), US East (Ohio), US West (N. California), US West (Oregon), EU (Frankfurt), EU (Ireland), EU (London), Asia Pacific (Singapore), Asia Pacific (Tokyo), Asia Pacific (Sydney), Asia Pacific (Seoul), Asia Pacific (Mumbai), Canada (Central), and South America (São Paulo) Regions.
Amazon Redshift Spectrum is available in the US East (N. Virginia), US East (Ohio), and US West (Oregon) Regions. To learn more, please visit aws.amazon.com/redshift/spectrum.