How do you unpivot GA4 (Google Analytics 4) event_params (JSON) in SQL Server?
We are exporting GA4 (Google Analytics 4) data from Big Query via a built-in Microsoft connector. Everything is coming through, but the event_params is in a very unusual JSON format. I have unpivoted numerous other arrays from different sources with…