Use BigQuery. With Supermetrics you can store historical UA data there and connect it to GA4 as well. Do keep in mind that UA and GA4 will give you completely different data output, so mixing the two might be a little hard. But you will have both UA and GA4 data stored at the same place, which is already something I guess.