• Home
  • Latest
  • Fortune 500
  • Finance
  • Tech
  • Leadership
  • Lifestyle
  • Rankings
  • Multimedia
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

robots
InnovationRobots
‘The question is really just how long it will take’: Over 2,000 gather at Humanoids Summit to meet the robots who may take their jobs someday
By Matt O'Brien and The Associated PressDecember 12, 2025
11 hours ago
Man about to go into police vehicle
CryptoCryptocurrency
Judge tells notorious crypto scammer ‘you have been bitten by the crypto bug’ in handing down 15 year sentence 
By Carlos GarciaDecember 12, 2025
12 hours ago
three men in suits, one gesturing
AIBrainstorm AI
The fastest athletes in the world can botch a baton pass if trust isn’t there—and the same is true of AI, Blackbaud exec says
By Amanda GerutDecember 12, 2025
12 hours ago
Brainstorm AI panel
AIBrainstorm AI
Creative workers won’t be replaced by AI—but their roles will change to become ‘directors’ managing AI agents, executives say
By Beatrice NolanDecember 12, 2025
13 hours ago
Fei-Fei Li, the "Godmother of AI," says she values AI skills more than college degrees when hiring software engineers for her tech startup.
AITech
‘Godmother of AI’ says degrees are less important in hiring than how quickly you can ‘superpower yourself’ with new tools
By Nino PaoliDecember 12, 2025
15 hours ago
C-SuiteFortune 500 Power Moves
Fortune 500 Power Moves: Which executives gained and lost power this week
By Fortune EditorsDecember 12, 2025
15 hours ago

Most Popular

placeholder alt text
Economy
Tariffs are taxes and they were used to finance the federal government until the 1913 income tax. A top economist breaks it down
By Kent JonesDecember 12, 2025
21 hours ago
placeholder alt text
Success
Apple cofounder Ronald Wayne sold his 10% stake for $800 in 1976—today it’d be worth up to $400 billion
By Preston ForeDecember 12, 2025
17 hours ago
placeholder alt text
Success
At 18, doctors gave him three hours to live. He played video games from his hospital bed—and now, he’s built a $10 million-a-year video game studio
By Preston ForeDecember 10, 2025
3 days ago
placeholder alt text
Success
40% of Stanford undergrads receive disability accommodations—but it’s become a college-wide phenomenon as Gen Z try to succeed in the current climate
By Preston ForeDecember 12, 2025
16 hours ago
placeholder alt text
Success
Palantir cofounder calls elite college undergrads a ‘loser generation’ as data reveals rise in students seeking support for disabilities, like ADHD
By Preston ForeDecember 11, 2025
2 days ago
placeholder alt text
Economy
For the first time since Trump’s tariff rollout, import tax revenue has fallen, threatening his lofty plans to slash the $38 trillion national debt
By Sasha RogelbergDecember 12, 2025
12 hours ago
Rankings
  • 100 Best Companies
  • Fortune 500
  • Global 500
  • Fortune 500 Europe
  • Most Powerful Women
  • Future 50
  • World’s Most Admired Companies
  • See All Rankings
Sections
  • Finance
  • Leadership
  • Success
  • Tech
  • Asia
  • Europe
  • Environment
  • Fortune Crypto
  • Health
  • Retail
  • Lifestyle
  • Politics
  • Newsletters
  • Magazine
  • Features
  • Commentary
  • Mpw
  • CEO Initiative
  • Conferences
  • Personal Finance
  • 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
About Us
  • About Us
  • Editorial Calendar
  • Press Center
  • Work At Fortune
  • Diversity And Inclusion
  • Terms And Conditions
  • Site Map

© 2025 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.