[destination-snowflake] multiple records in _airbyte_destination_state

[GKTheOne]

Connector Name

destination-snowflake

Connector Version

3.15.9

What step the error happened?

During the sync

Relevant information

I just updated my mysql -> snowflake connections to their latest versions and notice that the _airbyte_destination_state table now has multiple records for the same name+namespace and the only changing field is the updated_at timestamp. Previously (IIRC) it would only ever have one record per name+namespace.

We're using Airbyte 1.6.0 deployed via Helm chart 1.6.0. The source MySQL connector was upgraded from 3.7.3 to 3.11.19. The destination Snowflake connector was upgraded from 3.9.1 to 3.15.9.

Relevant log output

Contribute

• Yes, I want to contribute

[marcosmarxm]

It seems an expected behavior. It will only create 100 entries and the connector use MAX to capture the right state.