@flamber thank you for your help. I will consider migration later and after this will manually change initial_sync_status. But I still think it would be great to fix this on metabase side as well. Native query - no need for completed status.
This doesn't make much sense for me. It found issue, ok. No reason to repeat it again and again. Also Issue in collection A, why does it prevent me from using collection B?
And most funny part, there is no field named date with not a date in it.... This part of data not really secret so I just will put it here. Whole collection is 3 documents and there is 1 indeed with such text.... but text not in date feild. Provided json has $date and $oid as I copied directly from Compas. So may be issue in fingerprinting MongoDb collection?
{
"_id": {
"$oid": "62deca78eff8987b9231f880"
},
"id": "com.diveomedia.ls.buyMeSomethingMom",
"bookFolderName": "BuyMeSomethingMom",
"coverColor": "#68bd4e",
"coverImages": {
"boyHeic": {
"relative": "https://secret.com"
},
"girlHeic": {
"relative": "https://secret.com"
},
"boyJpg": {
"relative": "https://secret.com"
},
"girlJpg": {
"relative": "https://secret.com"
}
},
"declaredNumberOfPages": {
"$numberLong": "42"
},
"publishingState": {
"date": {
"$date": {
"$numberLong": "1659139200000"
}
},
"status": "published"
},
"texts": {
"ru": {
"title": "Мама, купи!",
"boyDescription": "Лягушонок не задумывается о том, откуда берутся\nденьги. Главное, чтобы родители покупали всё,\nчто он просит. Однажды ему придётся столкнуться\nс работой, и перед ним встанет сложный выбор.",
"girlDescription": "Лягушка не задумывается о том, откуда берутся деньги.\nКакая разница? Главное, чтобы родители покупали всё,\nчто она просит. Однажды ей придётся столкнуться\nс работой, и перед ней встанет сложный выбор."
},
"de": {
"title": "Kauf mir etwas, Mama!",
"boyDescription": "Ein junger Frosch hat nie überlegt, wo Geld herkommt. Aber\nwar das wichtig, solange seine Eltern ihm kauften, was er\nwollte? Als er eine schwierige Aufgabe annimmt, muss\ner eine Entscheidung treffen.",
"girlDescription": "Ein junges Froschmädchen hat nie überlegt, wo Geld\nherkommt. Aber war das wichtig, solange ihre Eltern\nihr kauften, was sie wollte? Als sie eine schwierige Aufgabe\nannimmt, muss sie eine Entscheidung treffen."
},
"en": {
"title": "Buy Me Something, Mom!",
"boyDescription": "A young frog never thought about where money came from.\nDid it even matter, as long as his parents bought him\neverything he asked for? When faced with a difficult job,\nhe finds himself caught between tough choices.",
"girlDescription": "A young frog never thought about where money came from.\nDid it even matter, as long as her parents bought her\neverything she wanted? When faced with a difficult job,\nshe finds herself caught between tough choices."
},
"it": {
"title": "Mamma, compramelo!",
"boyDescription": "Un piccolo ranocchio non sapeva da dove arrivassero i soldi:\ni suoi genitori gli compravano tutto senza dire mai di no.\nUn giorno, però, dopo aver ottenuto un lavoro duro, dovette\nfare una scelta difficile.",
"girlDescription": "Una piccola rana non sapeva da dove arrivassero i soldi:\ni suoi genitori le compravano tutto senza dire mai di no.\nUn giorno, però, dopo aver ottenuto un lavoro duro,\ndovette fare una scelta difficile."
},
"fr": {
"title": "Maman, achète-moi ça !",
"boyDescription": "Une petite grenouille ne sait pas d’où vient l’argent.\nQuelle importance, du moment où ses parents lui achète\nce qu’il veut ? Mais confronté à une tâche difficile,\nil se retrouve face à un dilemme.",
"girlDescription": "Une petite grenouille ne sait pas d’où vient l’argent.\nQuelle importance, du moment où ses parents lui achète\nce qu’elle veut ? Mais confrontée à une tâche difficile,\nelle se retrouve face à un dilemme."
},
"pt": {
"title": "Compra pra mim, mãe!",
"boyDescription": "De onde vem o dinheiro? Um jovem sapo nunca havia\npensado nisso. Mas será que isso importava, já que seus\npais compravam tudo o que ele pedia? Ao lidar com um\ntrabalho difícil, ele se vê em meio a escolhas difíceis.",
"girlDescription": "De onde vem o dinheiro? Uma jovem sapa nunca havia\npensado nisso. Mas será que isso importava, já que seus\npais compravam tudo o que ela pedia? Ao lidar com um\ntrabalho difícil, ela precisa fazer escolhas difíceis."
}
}
}