jstark
01/06/2022, 9:43 PMUntil it is fixed, we are going to store semi-structured data (mainly JSON arrays) as strings and depend on a transformation step to convert those strings to proper snowflake VARIANT or ARRAY types.The tap fails as I exptected it would if i try to define the object as a string in the object schema with a
Failed validating 'type' in schema
error. I am not sure how to do this conversion from a json object in the tap to a string in the target. Is this a change I would make to the json schema in the tap or somewhere else?