
AWS Launches Amazon Redshift Spectrum
New capability allows Amazon Redshift customers to run analytic queries quickly and inexpensively against exabytes of data in Amazon S3
SEATTLE--(BUSINESS WIRE)--Apr. 19, 2017-- Today, Amazon Web Services, Inc. (AWS), an Amazon.com company (NASDAQ: AMZN), announced Amazon Redshift Spectrum, a new feature that allows Amazon Redshift customers to run SQL queries against exabytes of their data in Amazon Simple Storage Service (Amazon S3). With Redshift Spectrum, customers can extend the analytic power of Amazon Redshift beyond data stored on local disks in their data warehouse to query vast amounts of unstructured data in their Amazon S3 data lake - without having to load or transform any data. Redshift Spectrum applies sophisticated query optimization, scaling processing across thousands of nodes so results are fast - even with large data sets and complex queries. To get started with Redshift Spectrum, visit https://aws.amazon.com/redshift/spectrum.
Amazon Redshift is one of AWS's fastest-growing services because it allows customers to perform complex queries on petabytes of structured data stored on high-performance local disks and get superfast performance - all for a tenth of the cost of traditional data warehouses. However, as the cost of data storage has continued to drop, customers are increasingly storing vast amounts of data in Amazon S3 data lakes, including unstructured data that may never make it into a data warehouse. Now, with Redshift Spectrum, analyzing all of this data is as easy as running a standard Amazon Redshift SQL query. Redshift Spectrum directly queries data in Amazon S3, with no loading or transformation required, using the open data formats customers already use, including CSV, TSV, Parquet, Sequence, and RCFile. Since Redshift Spectrum supports the same SQL syntax of Amazon Redshift, customers can run sophisticated queries using the same Business Intelligence (BI) tools they do today. They can also run queries that span both the frequently accessed data stored locally in Amazon Redshift and their full data sets stored cost-effectively in Amazon S3. Redshift Spectrum automatically scales query compute capacity based on the data being retrieved, so queries against Amazon S3 data run fast, whether processing just a few terabytes, petabytes, or even exabytes.
Customers such as Amgen, Boingo Wireless, Electronic Arts, Hearst, Lyft, Nasdaq, Scholastic, TripAdvisor, and Yahoo! are migrating to Amazon Redshift in droves because it leverages the scale of AWS to analyze petabytes of data with ten times the performance at one-tenth the cost of old guard data warehouses. Many of these customers have asked us to extend the speed and flexibility of Amazon Redshift beyond the data warehouse to analyze all of the data they have in Amazon S3, said Raju Gulabani, Vice President, Databases, Analytics, and AI, AWS. Redshift Spectrum does just this, offering the best of both worlds by making it incredibly easy to query exabytes of data in Amazon S3 directly from Amazon Redshift. We're excited to now make exabyte-scale analytics fast, simple and accessible to companies of all sizes.
Tokyo-based NTT DOCOMO is the largest mobile service provider in Japan, serving more than 68 million customers. Our data analysis platform collects tens of terabytes of log data each day from a variety of internal and external sources to help us improve our logistics and marketing operations. Migrating to Amazon Redshift two years ago allowed us to scale to over ten petabytes of uncompressed data with a ten times performance improvement over our prior on-premises system, said Mick Etoh, Senior Vice President and General Manager of Innovation Management Department, NTT DOCOMO. Redshift Spectrum will let us expand the universe of the data we analyze to 100s of petabytes over time. This is truly a game changer, and we can think of no other system in the world that can get us there.
Time Inc. is a leading content company that engages over 150 million consumers every month through its portfolio of premium brands across platforms. As a media company, we receive a large quantity of data from a number of ad serving providers. This data comes in a variety of formats and needs to be integrated with our own internal systems in order for our teams to be able to analyze it, said Vladimir Barkov, Director of Data Architecture and Engineering at Time Inc. Redshift Spectrum enables us to directly operate on our data in its native format in Amazon S3 with no preprocessing or transformation. Our data pipeline is much simpler now, and our execution time has been lowered significantly.
Edmunds offers detailed, constantly updated information about vehicles to 20 million monthly visitors. Amazon Redshift's scalability allows us to support our ever-growing data volumes, unlike our previous, on-premises data warehouse solution, said Ajit Zadgaonkar, Edmunds's Executive Director of Operations and Infrastructure. With Redshift Spectrum, we no longer need to think about what data to retain for analysis and what to throw away. We can now run real SQL queries directly on many years of data stored cost-effectively in Amazon S3. Redshift Spectrum's fast performance across massive data sets is unprecedented.
Redfin is the next-generation real estate brokerage, combining its own full-service agents with modern technology to redefine real estate in the consumer's favor across more than 80 metros in the US. With millions of users and hundreds of millions of property listings, our website and internal systems generate a vast amount of data. Our data analytics platform has been built from the ground up on AWS, using Amazon S3 for storage, Amazon Kinesis for streaming, Amazon EMR for data processing and real-time applications, and Amazon Redshift
Most recent headlines
04/09/2025
Monumental Sports & Entertainment (MSE), in collaboration with Dalet, has been a...
01/05/2025
WASHINGTON The Corporation for Public Broadcasting has filed a lawsuit to stop the Trump administration from firing three of its board members, claiming the pre...
01/05/2025
HONG KONG Riedel Communications today said it has opened a new office in Hong Kong, enhancing its presence in the Asia-Pacific region....
01/05/2025
MUMBAI, India & BALTIMORE In a development that could advance efforts to bring NextGen TV to cellphones, FreeStream Technologies, Lava International and HMD hav...
01/05/2025
01 05 2025 - Media release Screen Australia empowers 100 distinctive Australian narratives
All The Boys Are Here writer/director Goran Stolevski and It s All...
01/05/2025
How PFX Delivered 750 VFX Shots in Just Four Months For Anthony Hopkins Thriller...
01/05/2025
Careline's New Wave Makeup Commercial Shot With URSA Cine 12K LF
Brie Clayton May 1, 2025
0 Comments
CAD Studios relies on large format, full fram...
30/04/2025
Film elements held at the Deluxe warehouse in March of 2015. Photo by Luis Silva...
30/04/2025
EA SPORTS FC 25 fans in Australia and Saudi Arabia, get ready to immerse yourselves in the beautiful game like never before. Spotify is excited to announce a n...
30/04/2025
The past year has been nothing short of a whirlwind for Tucker Wetmore. After th...
30/04/2025
Mexico's love for podcasts is no longer a trend-it's a lifestyle. With m...
30/04/2025
Slam poet Huda the Goddess wins 2025 Les Murray Award
30 April, 2025
Media releases
Australia for UNHCR and SBS are proud to announce that Huda Fadlelmawla...
30/04/2025
SBS, NITV and NIDA partner to empower the next generation of screen creatives
30 April, 2025
Media releases
SBS, National Indigenous Television (NITV) and ...
30/04/2025
By Joyce JC Cataldo
The media and entertainment industry is evolving faster than ever. Technology is shifting the way we create, distribute, and experience c...
30/04/2025
An image of Valencia, Spain, in the OneAtlas Living Library...
30/04/2025
NEWPORT BEACH, Calif. WPSD-TV, the NBC affiliate in Paducah, Ky., has selected Bitcentral's Central Control playout system to upgrade the station's mast...
30/04/2025
AMSTERDAM Zero Density, a global provider of virtual studio productions and on-air graphics, has appointed Baris Zavaroglu as its new CEO. Zavaroglu succeeds Of...
30/04/2025
The Avit Group, a forward-thinking audio-visual technology company, is bringing over 50 years of combined experience in delivering audio-visual design and insta...
30/04/2025
NXTGENbps will be showcasing its latest sustainable battery power solutions at this year's Media Production & Technology Show (MPTS), appearing alongside pa...
30/04/2025
Van Dyke skates and operates on Shoresy | photo by Dave Ferguson
Toronto-based Cinematographer Brett Van Dyke (Heartland, Jann, Carter) stepped into the rink...
30/04/2025
Leading provider of media playout solutions PlayBox Neo will exhibit a vast array of significant upgrades to its range of smart media innovations at CABSAT from...
30/04/2025
ITV Studios is renowned for its award-winning productions, including the reality TV phenomenon I'm a Celebrity Get Me Out of Here! Produced by Lifted Ente...
30/04/2025
The UK's presence at this year's CABSAT brings together 20 innovative companies under the GREAT Britain and Northern Ireland banner. From advanced infra...
30/04/2025
Lightware continues to strengthen its Environmental, Social, and Governance (ESG) initiatives by fostering diversity, inclusion, and community engagement within...
30/04/2025
LiveU is demonstrating for the first time in the UK, its revolutionary technological breakthrough in IP-video transport, LiveU IQ (LIQ ) and bringing its expand...
30/04/2025
Stand: A40
Calrec has been putting sound in the picture for more than six decades and is still pushing the boundaries of audio broadcasting with a full range o...
30/04/2025
Buckinghamshire New University (BNU) has opened its new virtual production studio, designed and integrated by CJP Broadcast. The installation equips students wi...
30/04/2025
Independent news producer in India focuses on delivering stories
nxtedition has supplied a complete newsroom system to Collective Newsroom, based in New Delhi,...
30/04/2025
Connecting the present, building the future
FOR-A, a cutting-edge video broadcast technology company backed by more than 50 years experience, will showcase it...
30/04/2025
DAD by NTP Technology reports a successful NAB Show in Las Vegas where the company focused on upcoming expansion options in development for its Thunder | Core a...
30/04/2025
CVP and Canon UK & Ireland are proud to announce the winning projects from the third annual Stories in Motion Young Filmmakers Awards, which took place on the e...
30/04/2025
Leading video software provider, Synamedia, today announced that beIN MEDIA GROUP ( beIN'), one of the foremost global sports and entertainment broadcasters...
30/04/2025
The Canadian Premier League (CPL) today launched a new-look website and app, offering supporters of Canada's men's domestic professional soccer league a...
30/04/2025
WASHINGTON In a wide-ranging press conference, Federal Communications Commission Chair Brendan Carr had both good and bad news for broadcasters, stressing that ...
30/04/2025
TORONTO Cignal TV is relying on Quickplay's Shorts tool for its recently launched Pilipinas Live Shorts service, available to millions of users of Pilipinas...
30/04/2025
NEW YORK Steve Lanzano will retire as president and CEO of the Television Bureau of Advertising at year-end, the group said....
30/04/2025
The news production tech provider nxtedition is reporting that it supplied a complete newsroom system to Collective Newsroom, an independent news producer based...
30/04/2025
NEW YORK As part of a major push to advance the role that artificial intelligence (AI) plays in the advertising industry, the Interactive Advertising Bureau has...
30/04/2025
Uzbekistan Airways is the latest airline to choose SES's network, while Thai...
30/04/2025
Loaded Uses Blackmagic Design for shroud Subathon Live Streams
Brie Clayton April 29, 2025
0 Comments
Blackmagic Studio Cameras and Micro Studio Camer...
30/04/2025
Help shape the future of video creator tools with MIDiA
Brie Clayton April 29, 2025
0 Comments
After a successful debut in 2024, MIDiA is calling once...
30/04/2025
Tania Le n and Kelli O'Hara to be Honored at Boston Conservatory at Berklee&...
30/04/2025
Andr 3000 and Sara Bareilles to Receive Honorary Doctorates at Berklee College ...
30/04/2025
Damien Molony will head back to Jersey for a second series of Bergerac, written by Toby Whithouse alongside Ashley Sanders, Emilie Robson and Faebian Averies
D...
30/04/2025
Advancing multi-domain EW operations: Rohde & Schwarz unveils latest innovations...
30/04/2025
Rohde & Schwarz pioneers the future of automotive Ethernet using Analog Devices&...
30/04/2025
Wuppertal April 30, 2025
Riedel Communications Expands Asia-Pacific Presence with New Office in Hong KongRiedel Communications, a global leader in real-time v...
30/04/2025
Back to All News
Mad Unicorn' Trailer Reveals a Riveting Rags-to-Riches Sa...
30/04/2025
Back to All News
Get Ready to Get Wild: Netflix Announces Mating Season, a New ...
30/04/2025
SAN JOSE, Calif. - April 30, 2025 - Harmonic (NASDAQ: HLIT) today announced that...