Use more than one key as incremental unique_key

As of dbt Core 1.1, a list of column values is supported, exactly in the way you described :tada:

See the docs for more info: Configuring incremental models | dbt Docs