We are currently funneling our Google Analytics 4 (GA4) data into BigQuery, and then connecting to BigQuery with 'Google BigQuery Service Connector' in Domo. We are partitioning using date keys and bringing in the past 3 days of data (to account for attribution in GA4) with an append. However, our daily updated rows ranges between 1MM - 2MM+ every day - which is not the best for consumption purposes. Has anyone experienced similar issues, and if so, how did you optimize? Any/all recommendations would be helpful here! Thank you!