Meltano

Hi all,

I'm currently using `target-snowflake` (transferwise variant) and I'm having trouble loading the result from an API into my snowflake database. I get the following errors,

target_snowflake.exceptions.InvalidFileFormatException: `Not supported named file format 'my_file_format'.` Supported file formats: &lt;enum 'FileFormatTypes'&gt; cmd_type=loader job_id=2022-02-16T135455--tap-rest-api-msdk--target-snowflake name=target-snowflake run_id=3b8d50a0-b2ff-4ddc-af6b-2cf2804764eb stdio=stderr

ValueError: `'json' is not a valid FileFormatTypes` cmd_type=loader job_id=2022-02-16T135455--tap-rest-api-msdk--target-snowflake name=target-snowflake run_id=3b8d50a0-b2ff-4ddc-af6b-2cf2804764eb stdio=stderr

I've created a basic JSON file format on snowflake to parse the data but it seems to not "support" JSON type. The data structure from the API looks expected, in JSON format.

Yup, `target-snowflake` doesn't seem to support the JSON file format: <https://github.com/transferwise/pipelinewise-target-snowflake/blob/ad0d71baa9dee4c47b05869b7ca6c333593f8da3/target_snowflake/file_format.py#L10-L20>. Only CSV and Parquet