Is there a way to replicate all tables in a database to target?

[alberttwong]

something like

atwong@Albert-CelerData ~ % sling run --src-conn DUCKDB  --src-stream 'duckdb.main.*' --tgt-conn STARROCKSLOCAL --tgt-object 'testing.*' --mode full-refresh

[flarco]

Yes, but you need a replication.yaml file, see https://docs.slingdata.io/sling-cli/run/configuration/replication#overview:

source: MY_POSTGRES
target: MY_SNOWFLAKE

# default config options which apply to all streams
defaults:
  mode: full-refresh
  object: new_schema.{stream_schema}_{stream_table}

streams:
  my_schema.*:

[flarco]

I'll add logic so we don't absolutely need a YAML file (the command you suggested would work, with object being something like new_schema.{stream_schema}_{stream_table})

[flarco]

see #220