A client of mine in Education Services is uploading a large amount of data published by NYS Department of Education about some 7,000 schools & hierarchical entities related (Districts, Charter Schools, Charter Operators) in NY State.

The ETL professional in me likes large numbers. But the SF Admin in me is wondering about a performance hit. Also, hoping to upload this to an Enterprise org I have with Einstein Analytics licenses for the soothing transformations when selecting subsets of the data. Stay tuned.

We still have a few more child objects off the account to go, and I’m wondering if this is a good case for using Big Objects or an external data source. Suggestions welcome!