im not convinced you are working with large databases frequently from your comments. there is no simple option to harvest diverse legacy production database into some shiny new faster BI platform, that's consulting golden-handcuffs snake-oil. how would you move a 300 gigabyte relational database to bigquery or amazon for instance?