View in #general on Slack
@Philip_Bell: Does Cube have a way to handle array fields in noSql DBs, like Mongo?
@Hassan_Khan: Hi @Philip_Bell
I’m not up-to-speed with MongoBI, but I know with BigQuery, I’d use
UNNEST() for this scenario. Not entirely sure what the equivalent in MongoBI would be though
@Igor_Lukanin: @Philip_Bell Please see this example: https://stackoverflow.com/questions/60419946/in-cube-js-how-would-i-query-over-contents-of-an-array
Stack Overflow: In cube.js, how would I query over contents of an array?
@Philip_Bell: @Igor_Lukanin @Hassan_Khan thank you for your suggestions, I figured out based on some buried documentation that Mongo actually flattens arrays into index tables and you have to do basic foreign key queries to marry the data
Sampling Type Conflicts — MongoDB Connector for BI