im having an issue getting `key_properties` recogn...
# troubleshooting
s
im having an issue getting
key_properties
recognized when setting up
tap-airtable
to
target-snowflake
. in my config i have:
Copy code
metadata:
      '*':
        replication-method: FULL_TABLE
        replication-key: "id"
        table-key-properties: [id]
        key_properties: [id]
but i get an
Copy code
Exception: key_properties field is required
from the target. any thoughts?
tap-airtable is an older tap, and it uses
properties
, in case that is relevant
looks like i can disable the
primary_key_required
setting on the target, but im still not sure why the metadata approach wasn't working šŸ˜•
s
Following this…also having issues with the metadata properties properly showing on the tap (in this case, postgres). On the snowflake side, are your results using a merge on primary key or is it a proper insert?
s
i think
pipelinewise-target-snowflake
does a merge
s
Gotcha - maybe make sure that you have
- properties
in the capabilities section for the tap?