Hey All,

source: mysql 5.7

target: big-query

Meltano: V2.7.1

OS: ubuntu 20.04

Python: Python 3.8.10

When I use

replication_method: incremental

for

target-bigquery

the rows will be duplicated instead of updating, as I know this works based on tap schema but it didn’t in this case, How can I specify the primary keys or is there any other options I need to check?

It's not explicitly documented as far as I can remember, but it works just like AJ has documented on SO: https://stackoverflow.com/a/71669575/6056177

Thank you