Abstract: The present disclosure relates to systems, non-transitory computer-readable media, and methods for generating derived dimensions within ingested data collections. In particular, in one or more embodiments, the disclosed systems generate derived dimensions that modify or correct one or more organizational schemas of an ingested data collection when querying the ingested data collection. For example, the disclosed systems receive a user-defined definition, and generates a fallback expression based on the user-defined definition and aligned to the schema of a particular ingested data collection. In at least one embodiment, the disclosed systems generate the derived dimension by identifying and modifying one or more existing dimensions in the schema based on the fallback expression when reading data from the ingested data collection.

Abstract: Solar powered aquarium with a water holding vessel suitable for use as a table top aquarium powered by one or more solar cells. The aquarium vessel includes a secondary bottom held up from the main bottom by a side wall. A small cylinder is mounted between the main bottom and the secondary bottom. A downwardly extending skirt houses a DC motor mounted below the main bottom. A ferrous metal plate mounted to the shaft of the DC motor causes a magnetic spinning member located within the small cylinder to rotate. Apertures in the small cylinder and the side wall of the secondary bottom allow water to be drawn into the small cylinder and out the side wall. Gravel located in the bottom of the vessel traps debris as the water is drawn through it. Outwardly attached solar cells provide power for recharging circuit and attached motor.