Hello everyone,
I try to create a model on a large table containing some json columns (>40 Millions lines)
My Database is an Amazon Athena
The model has the only purpose to unnest some json column to give access to certain value with the good type and hide what is useless.
So it does not filter or reduce the table size.
The problem is that the model editor try to scan everything and not just a subset with a limit causing a timeout and preventing me from accessing the metadata and validate the model.
I tried to put a limit directly in the model and finish the creation (this works) but then when I remove the limit, the save fails.
Maybe it is not what models are used for but I have succeeded to do this kind of stuff on a previous version of metabase on the same table.
Thanks for your support.
have a nice day