Best way to use Analytics data (from Google Analytics)

Hey ! Im mostly using Bigquery but it is getting cut by the hierarchy, how can we transfer the data or use it with another data warehouse ? As there are thousand of nested tables, it is quite complexe and a lot of tool don't have enough compute capacity