hi, can some one explain ideal behavior (tap-mysql, target-postgres):

flattening_enabled: true
flattening_max_depth: 10

have a JSON datatype at the source but with flattening_enabled it becomes TEXT at the target, whereas removing the flattening and it becomes JSON at the target

It's probably because the JSON object has no structure. You could try adding some with the schema extra, i.e. add the fields you know are present in the object. Now, the reason for that behavior is that the SDK wouldn't know how to flatten a JSON object with unknown fields, so it just converts the whole thing to a string.