• Home
  • Latest
  • Fortune 500
  • Finance
  • Tech
  • Leadership
  • Lifestyle
  • Rankings
  • Multimedia

Exclusive

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

An hour in the Oval Office with President Trump Fortune Editor-in-Chief: Alyson Shontell sat down with President Trump in the Oval Office for an hour. Tariffs, Intel, AI, Boeing, Iran—and the question every CEO eventually has to answer: who's next?

TechBig Data

Exclusive: This Startup Says It Can Determine Which Data Warehouse Is Best for You

Barb Darrow
By
Barb Darrow
Barb Darrow
Down Arrow Button Icon
Barb Darrow
By
Barb Darrow
Barb Darrow
Down Arrow Button Icon
October 9, 2017, 10:28 AM ET

You may not know what a data warehouse is, but chances are your company relies on one.

This critical piece of business software, as the name implies, acts as a repository for all sorts of data—sales totals, customer service records, employee information—you name it. Putting all that diverse information into a super database makes it easier to analyze the information and find patterns that could boost sales or improve customer service.

An example of a fairly common reporting task is to see how many people came to a company’s web site, signed up for something, and then renewed a year later.

Traditionally, data warehouses from Teradata (TDC), Oracle (OCLCF), or SAP (SAP) ran on a company’s internal servers. But in the past few years, businesses have started to use cloud-based data warehouses like Amazon Redshift, Google BigQuery, or Snowflake. These data warehouses run on third-party cloud infrastructure—RedShift and Snowflake on Amazon Web Services, for example, and Google BigQuery on Google (GOOGL) cloud.

To help potential customers suss out which of those cloud options is fastest or cheapest, startup Fivetran came up with some benchmark tests to compare them. Fivetran, Oakland, Calif., sells technology that “cleans up” data and pumps it into a cloud data warehouse. Since it works with all three options, it can claim neutrality.

Related: Larry Ellison Says Oracle’s Next Database Will Beat Amazon

“We have no dog in this fight,” co-founder and CEO George Fraser tells Fortune. For the benchmark, outlined in a Fivetran blog post, the company used 99 standard queries that are designed for testing data warehouses.

Google BigQuery turned out to be the priciest option in this benchmark. “It was shocking that BigQuery was more expensive than the other options,” Fraser says. Although Fraser said he had heard anecdotally this might be the case, he had no hard evidence until now.

The price comparison is difficult given that Redshift and Snowflake charge by the hour while the warehouse runs. BigQuery, on the other hand, charges per query. To even things out, Fivetran estimated how much idle time would occur with Redshift and Snowflake and factored that in. Having done that, BigQuery was roughly twice as expensive as its two rivals with a median query cost of $0.041 compared to $0.023 for Redshift and $0.017 for Snowflake.

Related: This Data Crunching Startup Just Got $100 Million in Funding

Even then, Fraser maintains that all three options offer excellent price performance. The upside of BigQuery, he notes, is it is very easy to manage. “You put in a query and you get results,” he says.

In terms of query processing speed, the difference between the three warehouses was tiny, in Fraser’s view. BigQuery was fastest with a median execution time of 5.3 seconds. Snowflake was next at 5.8 seconds, and Redshift was third at 7.7 seconds. “For most users anything under 10 seconds is fine,” he says.

Get Data Sheet, Fortune’s technology newsletter

Fraser says it was a bit surprising that Redshift was slower than Snowflake. Because Snowflake is more of a managed service—meaning that the user has to do less set-up and tweaking, he expected it to show a performance hit. That was not the case.

Note: (Oct. 9, 2017 11:20 a.m. EDT) This story was updated to add detail about the benchmark’s format.

About the Author
Barb Darrow
By Barb Darrow
See full bioRight Arrow Button Icon

Latest in Tech

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025

Most Popular

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Fortune Secondary Logo
Rankings
  • 100 Best Companies
  • Fortune 500
  • Global 500
  • Fortune 500 Europe
  • Most Powerful Women
  • World's Most Admired Companies
  • See All Rankings
  • Lists Calendar
Sections
  • Finance
  • Fortune Crypto
  • Features
  • Leadership
  • Health
  • Commentary
  • Success
  • Retail
  • Mpw
  • Tech
  • Lifestyle
  • CEO Initiative
  • Asia
  • Politics
  • Conferences
  • Europe
  • Newsletters
  • Personal Finance
  • Environment
  • Magazine
  • Education
Customer Support
  • Frequently Asked Questions
  • Customer Service Portal
  • Privacy Policy
  • Terms Of Use
  • Single Issues For Purchase
  • International Print
Commercial Services
  • Advertising
  • Fortune Brand Studio
  • Fortune Analytics
  • Fortune Conferences
  • Business Development
  • Group Subscriptions
About Us
  • About Us
  • Press Center
  • Work At Fortune
  • Terms And Conditions
  • Site Map
  • About Us
  • Press Center
  • Work At Fortune
  • Terms And Conditions
  • Site Map
  • Facebook icon
  • Twitter icon
  • LinkedIn icon
  • Instagram icon
  • Pinterest icon

Latest in Tech

Google’s I/O conference showed how the company is being completely rebuilt for AI—for better or for worse
Big TechGoogle
Google’s I/O conference showed how the company is being completely rebuilt for AI—for better or for worse
By Alexei Oreskovic and Sharon GoldmanMay 19, 2026
2 hours ago
Bolt CEO Ryan Breslow
Workplace CultureFortune Workplace Innovation
Bolt CEO says he let go of his entire HR team for creating problems that didn’t exist: ‘Those problems disappeared when I let them go’: 
By Preston ForeMay 19, 2026
3 hours ago
Svenja Gudell, Chief Economist, Indeed
SuccessFortune Workplace Innovation
Indeed chief economist says the sectors most exposed to AI are seeing a big growth in job demand
By Emma BurleighMay 19, 2026
3 hours ago
A Pizza Hut workers prepares an order for delivery.
LawFood and drink
Pizza Hut franchisee claims $100 million losses from ‘cascading operational breakdowns’ in AI adoption gone wrong
By Sasha RogelbergMay 19, 2026
4 hours ago
Santora gestures towards himself
Future of WorkGen Z
WeWork and Upwork CEOs confirm the Gen Z hiring nightmare is real—but it’s nothing new
By Jacqueline MunisMay 19, 2026
6 hours ago
U.S. President Donald Trump speaking at a podium flanked by signs that say "Winning the AI Race."
NewslettersEye on AI
The times they are a-changin’: Washington suddenly warms to regulating AI
By Jeremy KahnMay 19, 2026
6 hours ago

Most Popular

While Trump insisted the Iran war would end ‘soon,’ an account in his name was buying millions in oil, defense, and gold
Economy
While Trump insisted the Iran war would end ‘soon,’ an account in his name was buying millions in oil, defense, and gold
By Eva RoytburgMay 18, 2026
1 day ago
The Bezos family just donated $100 million to help achieve one of Mayor Zohran Mamdani’s top campaign promises
Politics
The Bezos family just donated $100 million to help achieve one of Mayor Zohran Mamdani’s top campaign promises
By Jake AngeloMay 12, 2026
7 days ago
EXCLUSIVE: An hour in the Oval Office with the CEO-in-Chief, President Trump
Politics
EXCLUSIVE: An hour in the Oval Office with the CEO-in-Chief, President Trump
By Alyson ShontellMay 18, 2026
2 days ago
Current price of oil as of May 18, 2026
Personal Finance
Current price of oil as of May 18, 2026
By Joseph HostetlerMay 18, 2026
1 day ago
Current price of silver as of Monday, May 18, 2026
Personal Finance
Current price of silver as of Monday, May 18, 2026
By Joseph HostetlerMay 18, 2026
1 day ago
Employers are quietly pausing 401(k) matches again. The last time this happened was the 2008 recession and Covid
Personal Finance
Employers are quietly pausing 401(k) matches again. The last time this happened was the 2008 recession and Covid
By Courtney Vinopal and HR BrewMay 18, 2026
1 day ago

© 2026 Fortune Media IP Limited. All Rights Reserved. Use of this site constitutes acceptance of our Terms of Use and Privacy Policy | CA Notice at Collection and Privacy Notice | Do Not Sell/Share My Personal Information
FORTUNE is a trademark of Fortune Media IP Limited, registered in the U.S. and other countries. FORTUNE may receive compensation for some links to products and services on this website. Offers may be subject to change without notice.