Snowflake

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

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
        "created_column": "",
6
        "preserve_table_on_resync": false,
7
        "updated_column": "",
8
        "write_null_values": false,
9
        "write_record_timestamps": false
10
    }
11
  }
12
}

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