title: Confluent platform - Debezium MySql source connector - cant see data in topic
body: <p>I have defined Debezium MySQL source connector with the following configuraion</p>
  <pre><code>{
      &quot;name&quot;: &quot;quickstart-debezium-source1&quot;,
      &quot;config&quot;: {
          &quot;connector.class&quot;: &quot;io.debezium.connector.mysql.MySqlConnector&quot;,
          &quot;tasks.max&quot;: 1,
          &quot;database.hostname&quot;: &quot;host.docker.internal&quot;,
          &quot;database.server.name&quot;: &quot;connect_test&quot;,
          &quot;database.server.id&quot;: &quot;5555&quot;,
          &quot;database.port&quot;: &quot;3306&quot;,
          &quot;database.user&quot;: &quot;root&quot;,
          &quot;database.password&quot;: &quot;Fintech1!&quot;,
          &quot;database.history.kafka.topic&quot;: &quot;debezium-source&quot;,
          &quot;database.history.kafka.bootstrap.servers&quot;: &quot;broker:29092&quot;,
          &quot;include.schema.changes&quot;: &quot;true&quot;,
          
          &quot;key.converter&quot; : &quot;io.confluent.connect.avro.AvroConverter&quot;,
          &quot;key.converter.schema.registry.url&quot; : &quot;http://host.docker.internal:8081&quot;,
          &quot;value.converter&quot;:&quot;io.confluent.connect.avro.AvroConverter&quot;,
          &quot;value.converter.schema.registry.url&quot;: &quot;http://host.docker.internal:8081&quot;,
  
          &quot;topic.creation.default.replication.factor&quot;: -1,
          &quot;topic.creation.default.partitions&quot;: -1,
          &quot;topic.creation.default.cleanup.policy&quot;: &quot;compact&quot;,
          &quot;topic.creation.default.compression.type&quot;: &quot;lz4&quot;
   
  </code></pre>
  <p>Also have the following table in MySql:
  <a href="https://i.stack.imgur.com/SUWf5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SUWf5.png" alt="enter image description here" /></a></p>
  <p>I am able to see in Kafka new topic created and also new data that being added/updated to the table.
  but, I can't see the new data on the topic (I am using confluent-cloud-center)
  On the topic I can see the new data like:
  <a href="https://i.stack.imgur.com/bMQme.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bMQme.png" alt="enter image description here" /></a></p>
  <p>I cant see the values of the columns in the table
  Also I am trying to create a KSQLDB table out of this topic and no results are coming.
  Hope some1 could help me with that,
  I also have schema-registry, and the schema registry of the topic is:</p>
  <pre><code>{
    &quot;type&quot;: &quot;record&quot;,
    &quot;name&quot;: &quot;Envelope&quot;,
    &quot;namespace&quot;: &quot;connect_test.connect_test.test&quot;,
    &quot;fields&quot;: [
      {
        &quot;name&quot;: &quot;before&quot;,
        &quot;type&quot;: [
          &quot;null&quot;,
          {
            &quot;type&quot;: &quot;record&quot;,
            &quot;name&quot;: &quot;Value&quot;,
            &quot;fields&quot;: [
              {
                &quot;name&quot;: &quot;id&quot;,
                &quot;type&quot;: &quot;long&quot;
              },
              {
                &quot;name&quot;: &quot;name&quot;,
                &quot;type&quot;: [
                  &quot;null&quot;,
                  &quot;string&quot;
                ],
                &quot;default&quot;: null
              },
              {
                &quot;name&quot;: &quot;email&quot;,
                &quot;type&quot;: [
                  &quot;null&quot;,
                  &quot;string&quot;
                ],
                &quot;default&quot;: null
              },
              {
                &quot;name&quot;: &quot;department&quot;,
                &quot;type&quot;: [
                  &quot;null&quot;,
                  &quot;string&quot;
                ],
                &quot;default&quot;: null
              },
              {
                &quot;name&quot;: &quot;modified&quot;,
                &quot;type&quot;: {
                  &quot;type&quot;: &quot;string&quot;,
                  &quot;connect.version&quot;: 1,
                  &quot;connect.default&quot;: &quot;1970-01-01T00:00:00Z&quot;,
                  &quot;connect.name&quot;: &quot;io.debezium.time.ZonedTimestamp&quot;
                },
                &quot;default&quot;: &quot;1970-01-01T00:00:00Z&quot;
              }
            ],
            &quot;connect.name&quot;: &quot;connect_test.connect_test.test.Value&quot;
          }
        ],
        &quot;default&quot;: null
      },
      {
        &quot;name&quot;: &quot;after&quot;,
        &quot;type&quot;: [
          &quot;null&quot;,
          &quot;Value&quot;
        ],
        &quot;default&quot;: null
      },
      {
        &quot;name&quot;: &quot;source&quot;,
        &quot;type&quot;: {
          &quot;type&quot;: &quot;record&quot;,
          &quot;name&quot;: &quot;Source&quot;,
          &quot;namespace&quot;: &quot;io.debezium.connector.mysql&quot;,
          &quot;fields&quot;: [
            {
              &quot;name&quot;: &quot;version&quot;,
              &quot;type&quot;: &quot;string&quot;
            },
            {
              &quot;name&quot;: &quot;connector&quot;,
              &quot;type&quot;: &quot;string&quot;
            },
            {
              &quot;name&quot;: &quot;name&quot;,
              &quot;type&quot;: &quot;string&quot;
            },
            {
              &quot;name&quot;: &quot;ts_ms&quot;,
              &quot;type&quot;: &quot;long&quot;
            },
            {
              &quot;name&quot;: &quot;snapshot&quot;,
              &quot;type&quot;: [
                {
                  &quot;type&quot;: &quot;string&quot;,
                  &quot;connect.version&quot;: 1,
                  &quot;connect.parameters&quot;: {
                    &quot;allowed&quot;: &quot;true,last,false,incremental&quot;
                  },
                  &quot;connect.default&quot;: &quot;false&quot;,
                  &quot;connect.name&quot;: &quot;io.debezium.data.Enum&quot;
                },
                &quot;null&quot;
              ],
              &quot;default&quot;: &quot;false&quot;
            },
            {
              &quot;name&quot;: &quot;db&quot;,
              &quot;type&quot;: &quot;string&quot;
            },
            {
              &quot;name&quot;: &quot;sequence&quot;,
              &quot;type&quot;: [
                &quot;null&quot;,
                &quot;string&quot;
              ],
              &quot;default&quot;: null
            },
            {
              &quot;name&quot;: &quot;table&quot;,
              &quot;type&quot;: [
                &quot;null&quot;,
                &quot;string&quot;
              ],
              &quot;default&quot;: null
            },
            {
              &quot;name&quot;: &quot;server_id&quot;,
              &quot;type&quot;: &quot;long&quot;
            },
            {
              &quot;name&quot;: &quot;gtid&quot;,
              &quot;type&quot;: [
                &quot;null&quot;,
                &quot;string&quot;
              ],
              &quot;default&quot;: null
            },
            {
              &quot;name&quot;: &quot;file&quot;,
              &quot;type&quot;: &quot;string&quot;
            },
            {
              &quot;name&quot;: &quot;pos&quot;,
              &quot;type&quot;: &quot;long&quot;
            },
            {
              &quot;name&quot;: &quot;row&quot;,
              &quot;type&quot;: &quot;int&quot;
            },
            {
              &quot;name&quot;: &quot;thread&quot;,
              &quot;type&quot;: [
                &quot;null&quot;,
                &quot;long&quot;
              ],
              &quot;default&quot;: null
            },
            {
              &quot;name&quot;: &quot;query&quot;,
              &quot;type&quot;: [
                &quot;null&quot;,
                &quot;string&quot;
              ],
              &quot;default&quot;: null
            }
          ],
          &quot;connect.name&quot;: &quot;io.debezium.connector.mysql.Source&quot;
        }
      },
      {
        &quot;name&quot;: &quot;op&quot;,
        &quot;type&quot;: &quot;string&quot;
      },
      {
        &quot;name&quot;: &quot;ts_ms&quot;,
        &quot;type&quot;: [
          &quot;null&quot;,
          &quot;long&quot;
        ],
        &quot;default&quot;: null
      },
      {
        &quot;name&quot;: &quot;transaction&quot;,
        &quot;type&quot;: [
          &quot;null&quot;,
          {
            &quot;type&quot;: &quot;record&quot;,
            &quot;name&quot;: &quot;ConnectDefault&quot;,
            &quot;namespace&quot;: &quot;io.confluent.connect.avro&quot;,
            &quot;fields&quot;: [
              {
                &quot;name&quot;: &quot;id&quot;,
                &quot;type&quot;: &quot;string&quot;
              },
              {
                &quot;name&quot;: &quot;total_order&quot;,
                &quot;type&quot;: &quot;long&quot;
              },
              {
                &quot;name&quot;: &quot;data_collection_order&quot;,
                &quot;type&quot;: &quot;long&quot;
              }
            ]
          }
        ],
        &quot;default&quot;: null
      }
    ],
    &quot;connect.name&quot;: &quot;connect_test.connect_test.test.Envelope&quot;
  }
  </code></pre>