Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

document how to activate a new version of postgres-singer-io tap schema - key_properties change detected #223

Open
michaelklotz opened this issue Oct 20, 2022 · 0 comments

Comments

@michaelklotz
Copy link

After updating a singer.io target-postgres tap to use a new key, I see the following error:

 target_postgres.exceptions.PostgresError: ('Exception writing records', PostgresError("`key_properties` change detected. Existing values are: ['uri']. Streamed values are: ['id']"))
[2022-10-20, 19:22:01 UTC] {{taskinstance.py:1902}} ERROR - Task failed with exception

the target table comment is configured like this....

comment on table redacted.redacted is '{"path": ["redacted"], "version": 1, "schema_version": 3, "key_properties": ["uri"] ....

it used to have "key_properties": ["id"].

This functionality is listed as a feature, but there is no documentation on how to use it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant