Hi
My goal is to track the events data for analysis purposes. Bigquery has a limit of capturing 1 million events per day and my data exceeds this by a huge amount. Also bigquery has a huge processing costs.
The approach which i am trying to apply is to import the events data directly from GA4 to Google cloud storage without invloving bigquery as a warehouse at all. And from cloud storage. I can connect MySQL and use that for analysis purposes
My questions:
1) Is this approach valid? If yes then how to proceed with this?
2) What would be cost of storing data in the Google Cloud Storage?
3) Would there be any other costs I would incur when MySQL will fetch data from google cloud storage?