Mongo DB SQL Issue - Advanced Options

[NancySharma]

I am trying to upload the data from Mongo DB using Advanced option of ODBC Connector.

The problem i face is that it can pick basic queries but not for nested documents.

The query i am running is

SELECT _id, [extValues.MP_PRIM_VENDOR_ID]
FROM product;

extValues. MP_PRIM_VENDOR_ID is a field in nested document aligned in Mongo under Column extvalues.

How can we query nested documents using Advance options SQL Statement when i connect via OBDC?

[v-chuncz-msft]

@NancySharma,

You may check if R script could be an alternative.