In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

Bug report

For bug reports, provide this information, please:

What Debezium connector do you use and what version?

1.8

What is the connector configuration?

database.hostname: <hostname>
database.port: "3306"
database.user: "${file:/opt/kafka/external-configuration/connector-config/debezium-mysql-credentials.properties:mysql_username}"
database.password: "${file:/opt/kafka/external-configuration/connector-config/debezium-mysql-credentials.properties:mysql_password}"
database.server.id: "100"
database.server.name: "<server-name>"
database.whitelist: "<dbname>"
table.include.list: "<dbname>.tabSales Order,<dbname>.tabSales Order Item"
database.history.kafka.bootstrap.servers: "my-cluster-kafka-bootstrap:9092"
database.history.kafka.topic: "schema-changes.<server-name>"
database.history.skip.unparseable.ddl: "true"
event.deserialization.failure.handling.mode: "warn"
database.history.kafka.recovery.poll.interval.ms: 600000
database.history.kafka.recovery.attempts: 100
database.history.store.only.captured.tables.ddl: "false"
include.schema.changes: "true"
snapshot.locking.mode: "minimal"
snapshot.mode: "when_needed"
snapshot.lock.timeout.ms: 60000
min.row.count.to.stream.results: "0"
max.queue.size: 81290
max.batch.size: 20480
time.precision.mode: connect
snapshot.select.statement.overrides: "[<dbname>].[tabSales_Order],[<dbname>].[tabSales_Order_Item]"
snapshot.select.statement.overrides.[<dbname>].[tabSales_Order]: "SELECT * FROM [<dbname>].[tabSales Order] WHERE modified >= '2023-01-01'"
snapshot.select.statement.overrides.[<dbname>].[tabSales_Order_Item]: "SELECT * FROM [<dbname>].[tabSales Order Item] WHERE modified >= '2023-01-01'"
transforms: unwrap
transforms.unwrap.type: io.debezium.transforms.ExtractNewRecordState
transforms.unwrap.drop.tombstones: "false"
transforms.unwrap.delete.handling.mode: rewrite
transforms.unwrap.add.fields: op,table,ts_ms

What is the captured database version and mode of depoyment?

(E.g. on-premises, with a specific cloud provider, etc.)

Captured Database:  Mariadb 10.6

Mode of Deployment: Database (cloud VM), connector(kubernetes)

What behaviour do you expect?

The connector should take a snapshot as per the override query mentioned in the config above.

What behaviour do you see?

The connector is taking a snapshot of the entire table.

Do you see the same behaviour using the latest relesead Debezium version?

(Ideally, also verify with latest Alpha/Beta/CR version)

<Your answer>

Do you have the connector logs, ideally from start till finish?

(You might be asked later to provide DEBUG/TRACE level log)

No, Only snippet of logs where the snapshot query is reflecting.

How to reproduce the issue using our tutorial deployment?

<Your answer>

Feature request or enhancement

For feature requests or enhancements, provide this information, please:

Which use case/requirement will be addressed by the proposed feature?

<Your answer>

Implementation ideas (optional)

<Your answer>