Syncing specific schema tables in PostgreSQL with CloudQuery

Hello, I’m trying to sync data from PostgreSQL to PostgreSQL. I did not find a way to synchronize only tables in a specific schema.

Hi @ample-dog, can you try specifying the schema in the connection string? It should look like:

kind: source
spec:
  name: "postgresql"
  registry: "github"
  path: "cloudquery/postgresql"
  version: "v3.0.6"
  tables: ["*"]
  spec:
    connection_string: "postgresql://postgres:pass@localhost:5432/postgres?search_path=stitch_google_ads"

Yes, it worked, but now I have another problem.
I made the sync in the “public” schema. Where in the destination spec should I change the schema?

The configuration should be similar:

kind: destination
spec:
  name: "postgresql"
  registry: "github"
  path: "cloudquery/postgresql"
  version: "v6.1.0"

  spec:
    connection_string: "postgresql://postgres:pass@localhost:5432/postgres?search_path=stitch_google_ads"

Yep, thanks a lot!
It’s working.
CloudQuery is fantastic!