1
{
2
  "name": "mysql connection",
3
  "type": "mysql",
4
  "configuration": {
5
    "account": "admin",
6
    "change_detection": false,
7
    "dbname": "mydb",
8
    "hostname": "database.example.com",
9
    "passwd": "password",
10
    "port": 3306,
11
    "ssh": false,
12
    "ssh_host": "",
13
    "ssh_port": 22,
14
    "ssh_private_key": "",
15
    "ssh_user": "",
16
    "ssl": false
17
  }
18
}

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
        "preserve_table_on_resync": false
6
    }
7
  }
8
}