What does Syncari require to access data in tables?
To sync with database tables, Syncari needs to be able to identify each individual record and know if that record was modified since the last sync. To ensure that happens, every database table that you connect to Syncari must include:
- A primary key that uniquely identifies each record. The primary key must be required for each record.
- A DATETIME or TIMESTAMP field that identifies when the record was created or updated. Syncari uses the field as a watermark to identify when the record was last updated. This must be populated upon creation and must be populated at the current date and time of modification.
Why do I receive this sync error?
The provided key element does not match the schema (Service: AmazonDynamoDBv2; Status Code: 400; Error Code: ValidationException;
The sync error typically occurs on record creation to a DynamoDB table when values for a Primary Key and/or Sort Key is not provided. Check to see if you have the Primary Key and/or Sort Key mapped as fields to the destination (the requirement for mapping the Sort Key is dependent on the DynamoDB table configuration. Confirm that the table has a Sort Key configured).