I’ve been trying Meltano for various taps/targets ...
# troubleshooting
b
I’ve been trying Meltano for various taps/targets and use cases. I’m having a problem with a Snowflake target. I’m getting this error even though the file format exists: 2022-06-17T174955.596805Z [info ] target_snowflake.exceptions.FileFormatNotFoundException: Named file format not found: ksedw_2_snowflake_file_format cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake 2022-06-17T174955.756744Z [debug ] tail consumer completed first Any help for troubleshooting would be appreciated.
d
Did you happen to create the file format?
Copy code
CREATE FILE FORMAT {database}.{schema}.{file_format_name}
TYPE = 'CSV' ESCAPE='\\' FIELD_OPTIONALLY_ENCLOSED_BY='"';
I needed to do that and define it in my loader
Copy code
loaders:
          - name: target-snowflake
            config:
              account:--------
              dbname: MELTANO_DEV
              user: meltano
              warehouse: MELTANO_WH
              role: ACCOUNTADMIN
              file_format: meltano_dev.public.meltano_file_format
              primary_key_required: false
b
This is looking like operator error. Sorry for the false alarm.