So, we are currently using Metabase and all the queries are defined & maintained in Metabase.
We also have multiple databases and working with combining data across them is difficult. We would want to use some data modelling before we write the end use queries and then create the dashboards these queries.
We would like to use DBT for Version Control, Peer Reviews of SQL/code, testing, and deployment of creation of SQL queries that power the dashboards.
If it is not possible to use Metabase, what are the best alternatives (we need to host them on our premise/AWS).