Query Optimization and Dimensional Modeling are Dying Arts, and it isn't a good use of company time

Web: https://www.reddit.com/r/datascience/comments/se0o3u/query_optimization_and_dimensional_modeling_are/

I believe that companies are waking up to the fact that the time of Data Engineers is better spent on creating assets and building pipelines, not maintaining a dimensional model or optimizing a SQL query. There are many cloud products (GCP, AWS, Azure) that have optimization algorithms that can outperform any human. I think that dimensional models like star schemas, are going the way of the cube. Soon to be relegated to outdated technology. Cloud compute has gotten so cheap, …

arts company datascience good modeling optimization time