Forum Discussion
Getting this error: datasource.error: the table has no visible columns and cannot be queried.
Hello community, I am currently working on extracting data from our MongoDB database and have encountered an issue that I would like to discuss. The problem I am facing is related to one specific c...
Solution:
Seems to be that when adding new collections you need to update the SQL Schemas in the Data Federation for Atlas SQL in MongoDB.
Its under
Services > Data Federation > Scroll Down to your cluster > ManageSQL Schemas > Find the Collection that doesn't work > will be marked as "empty" > click edit (pencil icon) > generate schema
this did it for me
Esto me funcino perfectamente, muchas gracias