Podcast: Snowflake vs. Teradata

<p>Hi everyone! This is an update to my recent blog post on the final days of the legacy data warehouse (link below). </p><p>The topic of legacy data warehouses slowly fading away struck a chord with many readers. Now we have updates from Snowflake and Teradata.</p><p>On Aug 24, the same day I published “The Final Days of the Legacy Data Warehouse,” Snowflake announced its earnings for Q2 FY2023. Not surprisingly, a question about legacy systems came up during Snowflake’s earnings call. One financial analyst asked Snowflake CEO Frank Slootman about the level of activity of customers migrating from on-premises systems to Snowflake’s data cloud.</p><p>Slootman: <em>“In the last week, I've heard two very, very iconic names in two different industries that were staunch on-premises people, who would never ever go cloud, and that are now going [cloud]. So I just feel that the resistance is completely breaking….A lot of this is that they’re going to get left behind. You can’t take advantage of innovations that are only available on the cloud. We’re going to see acceleration out of this.”</em></p><p>Is he right? I have no doubt that he is.</p><p>According to Ocient, 59% of respondents to its survey are actively looking to switch data warehouse providers. They specifically named IBM, Cloudera, and Teradata as the top 3 legacy environments that data managers want to move away from.</p><p>Their reasons:</p><p>·      40% want to modernize their legacy platforms</p><p>·      42% feel their existing system isn’t comprehensive enough, and</p><p>·      36% say it’s not flexible enough</p><p>This explains why Snowflake, with its data cloud and data marketplace, has become such a tour de force. Other disruptors are Databricks, Firebolt, SingleStore, TileDB, Yellowbrick, and of course AWS, Google, and Microsoft.</p><p>I would include Ocient as well, with its hyperscale data warehouse platform, which is capable of analyzing trillions of records.</p><p></p><p>The old guard responds</p><p>Where does that leave traditional data warehou