What type of data or size limitation will we have

What type of data or size limitation will we have

We are currently developing two projects using Google Firebase.

1. Over a million records with about 10 different API endpoint that we are adding and updating data.
2. Much smaller, we are bringing in data from 2-3 endpoints for each customer, 4x a year, and generating a report.  Volume is rather small.  We handle this now with Google Sheets for about 200 customer and we are importing data.  

Since I am not anything close to someone that can work in Firebase but once was pretty good with Airtable, what is being described here seems to be more my speed assuming it can handle the volume.

Thanks,

Bill