A "spectrum_enable_enhanced_vpc_routing" parameter has appeared in Redshift.

Redshift Spectrum finally supports Enhanced VPC routing

What seems like an age ago, I spotted a setting on one of our Redshift clusters that suggested Enhanced VPC routing support for Redshift Spectrum might be on the way.  After waiting a while, and waiting some more, and then waiting some more, it seems that Amazon have finally released this into the wild, and Redshift Spectrum now works with clusters that have Enhanced VPC routing available!

As of Build 1.0.4349 or Build 1.0.4515, this functionality will be available in Redshift.  It hasn’t made it into the official announcements yet, but it has popped up on the Redshift forums here: https://forums.aws.amazon.com/ann.jspa?annID=6197

My previous post covers the details about Redshift Spectrum, and Enhanced VPC Routing, and what they are, so check that out if you’re unsure why this is big news: https://picnicerror.net/development/aws/is-aws-about-to-enable-redshift-spectrum-with-enhanced-vpc-routing-2018-01-18/

Has anyone out there tried this yet?  If so, let me know if the comments below how you’ve been getting on.

Solutions Architect at Indicia. More years than I care to remember wrangling SQL Server and .NET, now mainly AWS. Data geek, football fan, and Xbox gamer. Check out my gaming blog if you're into that sort of thing.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.