Looker release 4.14 offers full support for Redshift Spectrum. To verify the version of Redshift that you are using you can run this command from psql: select version() ![]() In order to use Spectrum, you’ll need to be sure that you are running at least version of Redshift. As I write this, the cost is $5 per terabyte. Queries against data that is stored in S3 will be charged on a per-query basis. Pricing for data stored in and queried against your existing, relational Redshift cluster will not change. And, perhaps most importantly, taking advantage of the new Spectrum feature is a seamless experience for end-users. These resources are not tied to your Redshift cluster, but are dynamically allocated by AWS based on the requirements of your query. Spectrum now provides federated queries for all of your data stored in S3 and allocates the necessary resources based on the size of the query. ![]() Prior to Spectrum, you were limited to the storage and compute resources that had been dedicated to your Redshift cluster. You can even join S3 data to data stored in Redshift, and the Redshift optimizer will take care of maximizing your query performance, optimizing both the S3 and Redshift portions of your query. Spectrum significantly extends the functionality and ease of use of Redshift by letting users access data stored in S3 without having to load it into Redshift first. You can take full advantage of Redshift Spectrum’s amazing performance from within Looker. At the AWS Summit on Wednesday, April 19th, 2017, Amazon announced a new Redshift feature called Spectrum.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |