Skip to content

Cloudquery deletes data from other tables if provided list of tables in source config #4770

@rajeshwarakella1994

Description

@rajeshwarakella1994

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

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions