Universal Analytics

I am pulling universal analytics data and storing it in BigQuery.
I need to pull till 2007 and which sync method you think will work for me?

In my experience so far everything works fine at the beginning but as I pull a couple of years of data then the system gets heavy and everything gets slow.

Now I am facing this
Screenshot from 2023-07-05 19-45-38