Hey all, I have just started using Meltano and thi...
# plugins-general
s
Hey all, I have just started using Meltano and this might be something basic I missed but I cannot figure out how to use
target-snowflake
for source
JSON
data. I have been trying to run meltano from
tap-shopify
to
target-snowflake
(pipelinewise variant) but since the target only accepts
CSV
or
Parquet
file format, it raises the
InvalidFileFormatException
when trying to load
JSON
data to Snowflake. I have tried setting
data_flattening_max_level
and even using
CSV
file format in Snowflake but none of them seem to work. Are there some steps that I am missing in this pipeline? Thanks!