[ReDeiPirati]

It looks like you have a strong self-service requirement ("so people that don't know SQL can explore data, create/look at dashboards and export data"), in that case I would encourage looking for BI tools like Metabase, Superset, etc...

At my previous company, we self-hosted Metabase using terraform on AWS, and connected it to a read-only replica of our production db. We also connected all the 3rd parties sources (Intercom, Zendesk, etc...) using Segment by moving the data to Redshift, which was connected to Metabase as well.

We created a Cloudflare tunnel (legacy) so that only people from the org could have access to Metabase via their Google profile.

It was a quite simple setup, but it worked very well for us.