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?jstark
01/06/2022, 9:46 PMobject
in the object schema, which gets ignored in target-snowflake.jstark
01/06/2022, 10:07 PMjstark
01/06/2022, 10:27 PMinstall --clean
for both the tap and target since our meltano.yml is just referencing the repo for target-snowflake, now I’m getting a sqlalchemy error CRITICAL 'SnowflakeDialect' object has no attribute 'driver'
😤 digging around a bit…jstark
01/06/2022, 11:47 PMjstark
01/06/2022, 11:48 PMjstark
01/07/2022, 12:02 AMjstark
01/07/2022, 5:55 PMadam_roderick
01/07/2022, 6:15 PMedgar_ramirez_mondragon
01/07/2022, 6:34 PMproperties
key from the schema: https://gitlab.com/meltano/target-snowflake/-/blob/master/target_snowflake/utils/singer_target_utils.py#L108-114jstark
01/07/2022, 6:46 PMKeyError: 'properties'
I wondered if i should add "$ref": "#"
as a property or something equivalent. I am pretty new to json schemasjstark
01/07/2022, 6:53 PMjstark
01/07/2022, 8:17 PMjstark
01/07/2022, 8:17 PMedgar_ramirez_mondragon
01/07/2022, 8:24 PMpoetry update singer-sdk
should do the trickjstark
01/07/2022, 9:02 PMpoetry update
and am still getting the same error.edgar_ramirez_mondragon
01/07/2022, 9:05 PMjstark
01/07/2022, 9:06 PMjstark
01/07/2022, 9:06 PMjstark
01/07/2022, 9:07 PMpoetry run tap-zengrc --config .secrets/config.json | ~/.virtualenvs/target-jsonl/bin/target-jsonl
jstark
01/07/2022, 9:12 PMjstark
01/07/2022, 9:14 PMjstark
01/07/2022, 9:17 PMedgar_ramirez_mondragon
01/07/2022, 9:39 PMdo you think meltano would handle this correctly?not necessarily. was just wondering if the venv was stale
edgar_ramirez_mondragon
01/07/2022, 9:39 PMor context I could very easily define the schema in a way that would handle our use case, but that would make the tap idiosyncratic, which I had hoped to contribute to the hub after this iteration.thanks for that!
edgar_ramirez_mondragon
01/07/2022, 9:42 PMpoetry run tap-zengrc --about
to confirm the SDK version in 0.3.17?jstark
01/07/2022, 9:44 PMedgar_ramirez_mondragon
01/07/2022, 9:59 PMSdk_Version: 0.3.10
It's not the latest 🤔. What version of singer-sdk do you see in poetry.lock
?jstark
01/07/2022, 10:01 PMjstark
01/07/2022, 10:05 PMjstark
01/07/2022, 10:07 PMjstark
01/07/2022, 10:08 PMjstark
01/07/2022, 10:16 PMedgar_ramirez_mondragon
01/07/2022, 10:27 PM