Cannot have a large number of properties

Velir / dbt-ga4

dbt Package for modeling raw data exported by Google Analytics 4. BigQuery support, only.

MIT License

289 stars 128 forks source link

Cannot have a large number of properties #269

Closed wesleyyee closed 7 months ago

wesleyyee commented 9 months ago

When specifying 40 properties, the query is too large. The maximum standard SQL query length is 1024.00K characters. Is there any way to work around this to allow more properties?

adamribaudo-velir commented 9 months ago

Congrats! You're the first to use this many properties :)

Can you be specific about which query/model is failing? Given this edge case, I would appreciate if you could take a first pass at a PR to resolve. I'm happy to review.

adamribaudo-velir commented 7 months ago

Closing until more details arrive.