Reply To: Techniques for transforming GA4 event_params (JSON) into rows in SQL Server

[Pham]

Hey, I totally feel you! I’ve had the exact same issue with GA4 data. After a ton of research, what I found is that you can actually select the column and then go to the transformation tab and click on ‘Analyse JSON’. This will give you an option to expand the column.

But, I won’t lie – despite doing this, dealing with the resulting header columns can be a bit tricky and might not offer the best solution you’re looking for.