is there a way we can use data sandboxing for Models instead of Tables? e.g. if table have JSON data which needs transformation first and model required first.
I would suggest that you do those models in a view in the database, so they get exposed to Metabase as tables so then you can do sandboxing on those
We are using Azure cosmosdb where views are not possible.
Try with advanced sandboxing (use a sql question for sandboxing a table)