Forum Discussion
Getting this error: datasource.error: the table has no visible columns and cannot be queried.
Anybody has a fix on that?
run into the same issue.
we added some collections to the database, but they are basically replicas of previous collections.
so no new fields added to the documents. it still throws the same error on the new collections.
also not nested or complicated data. one collection has exactly one field so this is strange.
also checked that data is healthy, so no errors (missing values, different value types on the same property etc.)
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
