Is there any way that we can provide BI to our customers using an OSS tool? Our databases store all our users data. I'm thinking of using something like pgsync

Is there any way that we can provide BI to our customers using an OSS tool? Our databases store all our users data. I'm thinking of using something like pgsync to sync all database postgres to a new postgres and then having redash or metabase set up to connect. Alternatively using locked filters on metabase and embedded questions. All our data for our users are in postgres and they very much want BI insights. Not sure how easiest way for this...