Fabrizzio Chavez
08/09/2025, 8:40 PMCREATE TABLE 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,
operation STRING METADATA FROM 'row_kind' VIRTUAL,
_id STRING,
fullDocument 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',
'scan.full-changelog' = 'true'
);
I don't want to deserialize because I need to store the raw data through a jdbc sink, fullDocument is returning null