-
Hey there! It sounds like you have quite the Matryoshka doll of data on your hands! Just a heads up, the best practice for this kind of situation is to flatten your BigQuery GA4 export before you even export it. Basically, you want to simplify that json data in your event property/custom dimension column so you don’t have to worry about it later. A common approach is to create a unique column for each event property or custom dimension.
Then, once everything’s all organized and simplified like that, you can go ahead and shift your data into the SQL server tables. It’s a relatively straightforward move at that point. If you decide to transform the data any further, it’ll mostly depend on your specific requirements. Just keep in mind that ETL logic can get a bit hefty as you make modifications over time. But no worries, it’s all part of refining and improving your data, right?
I hope that helps! Feel free to reach out if you have any other data dilemmas you need a hand with.
