I’m wanting to know if its possible to have a single extension access multiple bases concurrently?
My situation involves analyzing more than 50k records at a time and generating a graph based on those records. I will have 15+ bases and each are identical in structure. Each base has 50k records (pro plan). General structure of those bases is listed below (or you can see the base directly). The bases I am sharing just show a few rows (not 50k) to make this problem easier to review.
I know a synced table is what would generally allow you to sync multiple bases into 1. I’ve confirmed if I do that I can achieve the desired graphs/extensions in a single base (provided the record limit is not exceeded). But even with a pro plan I am limited to 50k records for the base, even if those records are synced. So this is not feasible.
Is there an alternative way that would work better? Right now I am considering using a local database to host and store my raw data. And then I would use Airtable to pull from and do analysis on that data. But my preference would be to have everything in Airtable.
Please let me know if there is a better community I should post this in!