Meltano

Do any one guide me for key-properties documentation?

Hi <@U06CBSA6GF4>. The most basic documentation is the Singer spec one, specifically regarding catalog files.

The way it’s used as part of meltano’s `metadata` extra is documented in <https://docs.meltano.com/concepts/plugins#metadata-extra|https://docs.meltano.com/concepts/plugins#metadata-extra>

thank you <@U06BX9QQ4A3> However we have scenario, where there is no primary key but two foreign keys. Can you suggest how we can avoid duplicates if source table doesn’t have primary key in Meltano?

<@U06BX9QQ4A3> the following doesn’t work in my work example <https://stackoverflow.com/questions/71669574/how-to-override-a-streams-primary-key-properties-or-incremental-replication-key>