Just wondering if there's any recommendations for ...
# troubleshootingj
jessica_fosler
06/09/2023, 3:19 AMJust wondering if there's any recommendations for GA4 -> Snowflake. We have already done the thing where you dump it all into BigQuery first. Is BigQuery -> Snowflake the next step? There's all those nested params in the bigquery database so wondering how that'd go.
u
user
06/12/2023, 1:35 PMI'm not familiar with the process of dumping it to BigQuery first but theres a thread going to get the GA tap updated and cleaned up for GA4 https://meltano.slack.com/archives/C01PKLU5D1R/p1686150947898559 with that you'd go directly from GA to Snowflake
j
jessica_fosler
06/15/2023, 11:24 PMYeah the data API itself suffers from rate limiting, which is why we went the BigQuery route.