6 months from now: We are moving our warehouse off of Trino + HogLake to newer technology XXX.

This is ridiculous. Why can you not foresee such issues? Do you not do testing with mock data at the size you need? Migrating production between stacks so often means you are not getting new features in. This is pure churn.