Example Debezium CDC record in Snowflake

video_cdc_event_snowflake

// record_metadata
{
  "CreateTime": 1595535726000,
  "key": "{\"id\":1}",
  "offset": 4000,
  "partition": 2,
  "topic": "debezium.myschema.video"
}

//record_content
{
  "after": {
    "created_at": 1519212232000,
    "id": 2,
    "user_id": 500,
    "video_title": "Cat Video",
  },
  "before": null,
  "op": "r",
  "source": {
    "connector": "mysql",
    "db": "mydb",
    "file": "mysql-binlog.001001",
    "gtid": null,
    "name": "debezium",
    "pos": 45046200,
    "query": null,
    "row": 0,
    "server_id": 0,
    "snapshot": true,
    "table": "video",
    "thread": null,
    "ts_sec": 0,
    "version": "0.9.5.Final"
  },
  "ts_ms": 1595534726000
}