By default CQ runs for all tables but when a configuration as mentioned below is provided, data is getting deleted from other tables as well.
This is the case with overwrite-delete-stale mode in postgres destination.
Sharing the config files below -
aws.yml
kind: source
spec:
name: "aws_667292283479"
path: "cloudquery/aws"
version: "v5.1.2"
destinations: ["postgresql"]
tables:
- aws_rds_engine_versions
- aws_rds_cluster_parameters
rds.yml
kind: destination
spec:
name: "postgresql"
path: "cloudquery/postgresql"
version: "v1.7.10"
write_mode: "overwrite-delete-stale" # overwrite, overwrite-delete-stale, append