Binary field not showing up through BI Connector

[Ryan Louie]

Hi there,

We have a MongoDB collection in which there is an Object field `model` containing two binary fields `model` and `vectorizer` (screenshots 1 and 2). Using the BI Connector we can access fields of other data types (string, int) in the Object field, but the Binary fields do not show up in the BI Connector schema (screenshot 3). So obviously when we try to select one of the binary fields we get: ERROR 1054 (42S22): Unknown column 'model.vectorizer' in 'field list'

We have regenerated the BI Connector schema by restarting mongosqld with sampleSize=0 and sampleRefreshIntervalSecs=60, yet the fields still do not show up.

Is this a known issue: that binary fields are not compatible with the BI Connector? Is there a config we need to add? We can access every other data type field in the database, but only have issue retrieving binary fields. Please let me know if there is any more information I can provide.

Thank you for any insight,

Ryan

[Stephen Steneker]

Hi Ryan,

This is a known issue, but I couldn't find mention of it in the current documentation outside of the release notes. The MongoDB Connector for BI does not (as at v1.11) support querying generic binary values (aka BinData in BSON). Fields only containing unsupported values will be ignored when the schema is generated.

I'll add a docs suggestion to note that more prominently.

Regards,

Stennie