Checked
Some attributes are scalar but others are not
There are array of objects in a lot of places. will need to modify the schema to be completely scalar
Will run a local test & see how this goes. Thanks a lot!
Some attributes are scalar but others are not
There are array of objects in a lot of places. will need to modify the schema to be completely scalar
Will run a local test & see how this goes. Thanks a lot!
Now you have a two table schema with (at most) one join in a given query.
Check out Vertica. It does a great job at various forms of compression. In addition, DuckDB is an easy way to get started with efficient OLAP queries.