Fabrizzio Chavez
08/11/2025, 1:31 AMSET 'sql-client.execution.result-mode' = 'tableau';
CREATE TABLE mongo_users (
db_name STRING METADATA FROM 'database_name' VIRTUAL,
collection_name STRING METADATA FROM 'collection_name' VIRTUAL,
operation_ts TIMESTAMP_LTZ(3) METADATA FROM 'op_ts' VIRTUAL,
row_kind STRING METADATA FROM 'row_kind' VIRTUAL,
_id STRING,
name STRING,
PRIMARY KEY(_id) NOT ENFORCED
) WITH (
'connector' = 'mongodb-cdc',
'hosts' = 'localhost:27017',
'connection.options' = 'directConnection=true&tls=false',
'username' = 'admin',
'password' = 'admin',
'database' = 'cdc-test',
'collection' = 'users'
);
SELECT * FROM mongo_users;
But I am not sure if the row_kind is returned correctly, because when the document is deleted the row_kind says +U (the previous row_kind), it should not be -D? like the op column added in sql client?Fabrizzio Chavez
08/13/2025, 1:10 AM