joaolcorreia / google-analytics-bigquery-data-export Goto Github PK

Hi @joaolcorreia, thank you so much for putting this together, this is great. I've modified my version some from your original query.

One question. I'm trying to export all 200 dimensions and metrics. Right now we aren't currently using all of them, but I'd like to future proof the query and include the fields if possible.

When I run the query, I get the error: Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex..

I think it has to do with all of the (SELECT MAX(IF(index=XXX, value, NULL)) FROM UNNEST(hits.customMetrics)) AS metricXXX type of queries for custom dimensions and custom metrics.

Any ideas if there is a way around this? Perhaps I should join on fullVisitorId and timestamp?