Scope And Collection in N1QL sink handler

Many thanks to for this improvement.

Oops, didn't mean to resolve this yet.

Hi ,Thanks for the comment. The DMLs in the N1QL sink handler only use the bucket name as the keyspace. We wanted to see the data inserted into different scopes and collections. I added this improvement as I wanted to submit a new batch for it in Gerrit. The batch can be found at the following link. https://review.couchbase.org/c/kafka-connect-couchbase/+/179087
In the code, we are creating N1QL DMLs and the only change needed was adding the scope and collection to the statements. And when we don't have any scopes and collections "_default" as collection and as the scope. (I can change it to "" as well if needed) Is there a problem in changing the DMLs in this way?

Thanks , at the moment, we probably need to support 6.x and 7.x. 7.x supports both formats. Or maybe I don't fully understand the change you're looking for in the connector? What was it you were trying to do that you could not?