1
{
2
  "name": "snowflake connection",
3
  "type": "snowflake",
4
  "configuration": {
5
    "account": "uc193736182",
6
    "dbname": "database_name",
7
    "key_pair_auth": false,
8
    "params": "",
9
    "password": "password",
10
    "private_key": "",
11
    "private_key_passphrase": "",
12
    "username": "user",
13
    "warehouse": "warehouse"
14
  }
15
}

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

1
{
2
  ...
3
  "target": {
4
      "configuration": {
5
        "preserve_table_on_resync": false
6
    }
7
  }
8
}

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