Unable to see collections of MongoDB connection using Drill

Database Support
, , ,
#1

Hello Helical Team,

I am using Helical Insight 4.0. I have created a MongoDB storage on Apache Drill and connected to Helical Insight. I am unable to see the collections of my database. There is no error. How can I fix this?

Thank You,
Snow.

#2

Hello Snow,

Please check the following:

  1. The database name should be in lowercase. Apache Drill uses only lower case while querying the DB.

  2. The user with which you are connecting to MongoDB must have access to the admin database. Only user with access to admin database can view all collections.

Also have a look at the link : Not able to view Mongo DB collections in Metadata - #2 by helicalforum

Thank You,
Helical Insight.