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 Continue reading “Redshift Spectrum finally supports Enhanced VPC routing” »

A "spectrum_enable_enhanced_vpc_routing" parameter has appeared in Redshift.

Is AWS about to enable Redshift Spectrum with Enhanced VPC Routing?

AWS is knocking it out of the park at the moment with loads of new services and features coming out every week.  Indeed, it can be hard to keep up with the degree of change.  But, while working on one of our Redshift clusters today we spotted a potential scoop that would remove a key blocker for one extremely useful service, Redshift Spectrum.

Up until now it’s only been possible to use Spectrum if you don’t have Enhanced VPC Routing enabled on your Redshift cluster.  There are so many benefits to using Enhanced VPC Routing (reduced data transfer cost, control, security) that it’s hard to see why anyone wouldn’t be using it, especially if you move data between Redshift and S3 a lot.

But we spotted a new parameter being applied to one of our clusters when we made some maintenance changes to a parameter group.  There’s now a parameter named spectrum_enable_enhanced_vpc_routing showing, which hints that Amazon may be about to remove this crucial limitation.

 

Continue reading “Is AWS about to enable Redshift Spectrum with Enhanced VPC Routing?” »

Power BI support for Amazon Redshift data source

Redshift connectivity officially announced for Power BI Service

Last year, Microsoft added a preview connector enabling Power BI to query Amazon Redshift.  This wasn’t publicised as an “official” data source, and took some steps in order to be able to even see the connector in Power BI Desktop.  Crucially, you could only use this connector in Power BI Desktop, not when workbooks are deployed to the cloud.  Yesterday, Microsoft announced the connector is now available within the Power BI Service, which means that workbooks containing Redshift data connections can now be deployed to the cloud.  I’ve been working a lot with Redshift over the past year or so, and Power BI’s still my go-to data-viz solution, so I’m delighted to see the this announcement, as it means that Redshift-based workbooks can now be shared with others via powerbi.com. Continue reading “Redshift connectivity officially announced for Power BI Service” »

Amazon Quicksight now in General Availability!

Late last night, Amazon announced that their proprietary AWS data visualisation tool, Quicksight was now generally available in the US and Ireland.  Quicksight aims to be a PowerBI-esque drag and drop visualisation tool, that allows you to access your data from AWS (and other sources) in seconds, regardless of scale.  I’ve had a very quick go this morning, and visualised some data from a modest 1TB Redshift cluster after just a few minutes.  The biggest challenge was finding out the correct IP range for Quicksight to enable access to my VPC (Thank you serverfault).

More to follow…In the meantime, try Quicksight for yourself here: https://quicksight.aws.amazon.com

Power BI iOS app

Impressions of Microsoft’s new-look Power BI

A couple of months ago, Microsoft’s new-look Power BI Preview rolled out globally.  Ditching the Office 365/Sharepoint Online requirement, the new Power BI is a streamlined, simplified version of the product that attempts to lose some of the bloat and give users a focussed, easy-to-use, self-service BI platform.

So has it worked?

Continue reading “Impressions of Microsoft’s new-look Power BI” »