MotherDuck

1
{
2
  "name": "MotherDuck connection",
3
  "type": "motherduck",
4
  "configuration": {
5
    "access_token": "",
6
    "aws_access_key_id": "AKIAIOSFODNN7EXAMPLE",
7
    "aws_secret_access_key": "wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY",
8
    "database": "my_db",
9
    "s3_bucket_name": "s3://polytomic/dataset",
10
    "s3_bucket_region": "us-east-1"
11
  }
12
}

1
{
2
  ...
3
  "configuration": {
4
    "query": "SELECT * from users",
5
    "table": "users",
6
    "view": "active_users"
7
  }
8
}

1
{
2
  ...
3
  "target": {
4
      "configuration": {
5
        "created_column": "",
6
        "preserve_table_on_resync": false,
7
        "updated_column": "",
8
        "write_record_timestamps": false
9
    }
10
  }
11
}

1
{
2
  ...
3
  "destination_configuration": {
4
    "advanced": {
5
        "empty_strings_null": false,
6
        "hard_deletes": false,
7
        "initial_execution": "",
8
        "table_prefix": "",
9
        "truncate_existing": false
10
    },
11
    "mirror_schemas": false,
12
    "schema": "schema"
13
  }
14
}