Motherduck does not seem to use the passed `database` - Githubissues

slingdata-io / sling-cli

Sling is a CLI tool that extracts data from a source storage/database and loads it in a target storage/database.

https://docs.slingdata.io

GNU General Public License v3.0

438 stars 34 forks source link

Motherduck does not seem to use the passed `database` #439

Closed hello-world-bfree closed 3 hours ago

hello-world-bfree commented 4 hours ago

Issue Description

Description of the issue: Despite setting a connection string or through env.yaml with a particular database that exists within Motherduck, Sling uses the default database, my_db. To be clear, the replication is successful. It's just replicated into the defualt database within Motherduck, my_db and not in the set database.
Sling version (sling --version): 1.2.22
Operating System (linux, mac, windows): mac
Replication Configuration:

env.yaml:

connections:
  motherduck_hallow:
    type: motherduck
    database: hallow_replication
    duckdb_version: 1.1.3
    motherduck_token: {my_token}

Replication:

source: hallow_staging
target: md_sling

defaults:

  source_options:
    empty_as_null: false

  target_options:
    column_casing: snake

streams:
  hallow.users:
    disabled: false
    mode: full-refresh
    object: main.hallow_staging_users

flarco commented 3 hours ago

One liner fix. Try with the latest dev build.