UPDATE: I was able to solve this just by using mongo read connection, not sure why there is an option to control the connection type when it doesn't really matter
Hi everybody,
I'm trying to set up a new mongo resource for writing queries.
I choose the write connection option -
The connection test works and everything looks ok.
However, when Im trying to use the resource in a query I get an empty tables dropdown-
I tried to run this anyway and got this error -
From what I know, knex is a tool for relational DB's, and with the fact them Im having a "tables" dropdown, not "collections", makes me think there is possibly a bug here.
What am I doing wrong?
Thanks in advance