Question for those of you using GA4 data - just discovering the pitfalls of trying to replicate 'users' metrics, deduplication in BI tools. Has anyone managed to get the raw Bigquery GA4 exports into another dwh, either with meltano or via some other way?

Yep! https://medium.com/@rfrankel_8960/incredible-bigquery-extract-performance-3432b9cd83fe https://github.com/MeltanoLabs/tap-bigquery/pull/24

I'm wary of progressing too far down this route and still not being able to recreate GA4 metrics as the actual DAX measures would be too complex or the data too difficult to understand. Did you end up building any workable BI measures/metrics off the raw data

No, sorry - that work was for a customer who just wanted their large amount of raw GA4 data landing somewhere.

No worries, think I will just settle for disappointing the marketing department then 🙂