Hello community,
I work for a large tech services company.
I am currently researching data warehouse solutions. Which solution do you prefer: Oracle Exadata or Snowflake? Which solution performs better and has more cost savings?
Thank you for your help.
This is a large and complex question and depends on the use case and scale. Each platform has its advantages and there are significant pros and cons for each platform. I am an independent consultant; I teach courses about these platforms and how to select one; and I advise clients.
If you would like to have a discussion about your requirements, the tradeoffs, and how to go about getting the best platform for your business, please email me at richard@wintercorp.com or book me online (no charge) at solvethepuzzle.biz
While the choices largely remain driven by the commercials and skills available... I would recommend Azure Synapse .. given the flexibility it has to scale and also for the skills available in the market to support or enhance..
Exadata is by far the most appropriate fit-for-purpose solution for Dataware House, although it is expansive. But performance, scalability, and availability is the key you must consider when going to Oracle Exadata. Also, a good Field Deliver Support team to attend when needed. And you can run your business on-premise cloud or a public one.