Question on JSON data quality capability and Data set filter for analysis

1. JSON file = yes
2. a single JSON column from a database as blob or clob or json possibly if its the only column
3. MongoDB document json object yes if the proper drivers
4. What isn’t supported is a JSON column in a database table with other columns, because you technically have 2 schemas the database table schema and the json schema.

So while you can write rules or have auto rules on JSON you cannot mix JSON with tabular data

As for filtering a dataset you could do a couple things, 1) apply where clause in the original -q “select” or 2) apply a rule condition like “where col1=A and col2 > 5”