curl --request PATCH \
  --url https://api.prequel.co/sources/{source_id} \
  --header 'Content-Type: application/json' \
  --header 'X-API-KEY: <api-key>' \
  --data '
{
  "source": {
    "name": "production-primary",
    "max_concurrent_transfers": 10,
    "max_concurrent_queries_per_transfer": 1,
    "aurora_mysql": {
      "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
      "port": 3306,
      "connection_database": "mysql",
      "auth_method": "password_auth",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false
    },
    "aurora_postgres": {
      "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
      "port": 5432,
      "database": "analytics",
      "auth_method": "password_auth",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false,
      "connection_timeout_in_seconds": 30
    },
    "databricks": {
      "host": "adb-1099123456789876.12.azuredatabricks.net",
      "port": 443,
      "catalog": "main",
      "http_path": "/sql/1.0/endpoints/a98765ab4c3210a0",
      "oauth_client_secret_auth": {
        "client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
        "client_secret": "<string>"
      },
      "hive": {
        "bucket_vendor": "bucket_s3",
        "bucket_s3": {
          "bucket_name": "acme-data-export-staging",
          "bucket_region": "us-east-1",
          "aws_access_keys": {
            "access_id": "AKIAIOSFODNN7EXAMPLE",
            "secret_key": "<string>"
          }
        }
      },
      "use_ssh_tunnel": false
    },
    "mongodb": {
      "host": "clusterID.mongodb.net",
      "port": 27017,
      "authentication_database": "admin",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false
    },
    "mysql": {
      "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
      "port": 3306,
      "connection_database": "mysql",
      "auth_method": "password_auth",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false
    },
    "oracle": {
      "ssl_options": {
        "wallet": "<string>"
      },
      "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
      "port": 1521,
      "database": "ORCL",
      "auth_method": "password_auth",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false
    },
    "postgres": {
      "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
      "port": 5432,
      "database": "analytics",
      "auth_method": "password_auth",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false,
      "connection_timeout_in_seconds": 30
    },
    "singlestore": {
      "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
      "port": 3306,
      "connection_database": "mysql",
      "auth_method": "password_auth",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false
    },
    "snowflake": {
      "username": "DATA_EXPORT_USER",
      "host": "db54321.us-central1.gcp.snowflakecomputing.com",
      "port": 443,
      "database": "ANALYTICS"
    },
    "sql_server": {
      "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
      "port": 1433,
      "database": "analytics",
      "auth_method": "password_auth",
      "password_auth": {
        "username": "data_export_user",
        "password": "<string>"
      },
      "use_ssh_tunnel": false,
      "disable_ssl": false
    }
  }
}
'

import requests

url = "https://api.prequel.co/sources/{source_id}"

payload = { "source": {
        "name": "production-primary",
        "max_concurrent_transfers": 10,
        "max_concurrent_queries_per_transfer": 1,
        "aurora_mysql": {
            "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
            "port": 3306,
            "connection_database": "mysql",
            "auth_method": "password_auth",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False
        },
        "aurora_postgres": {
            "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
            "port": 5432,
            "database": "analytics",
            "auth_method": "password_auth",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False,
            "connection_timeout_in_seconds": 30
        },
        "databricks": {
            "host": "adb-1099123456789876.12.azuredatabricks.net",
            "port": 443,
            "catalog": "main",
            "http_path": "/sql/1.0/endpoints/a98765ab4c3210a0",
            "oauth_client_secret_auth": {
                "client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
                "client_secret": "<string>"
            },
            "hive": {
                "bucket_vendor": "bucket_s3",
                "bucket_s3": {
                    "bucket_name": "acme-data-export-staging",
                    "bucket_region": "us-east-1",
                    "aws_access_keys": {
                        "access_id": "AKIAIOSFODNN7EXAMPLE",
                        "secret_key": "<string>"
                    }
                }
            },
            "use_ssh_tunnel": False
        },
        "mongodb": {
            "host": "clusterID.mongodb.net",
            "port": 27017,
            "authentication_database": "admin",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False
        },
        "mysql": {
            "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
            "port": 3306,
            "connection_database": "mysql",
            "auth_method": "password_auth",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False
        },
        "oracle": {
            "ssl_options": { "wallet": "<string>" },
            "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
            "port": 1521,
            "database": "ORCL",
            "auth_method": "password_auth",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False
        },
        "postgres": {
            "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
            "port": 5432,
            "database": "analytics",
            "auth_method": "password_auth",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False,
            "connection_timeout_in_seconds": 30
        },
        "singlestore": {
            "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
            "port": 3306,
            "connection_database": "mysql",
            "auth_method": "password_auth",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False
        },
        "snowflake": {
            "username": "DATA_EXPORT_USER",
            "host": "db54321.us-central1.gcp.snowflakecomputing.com",
            "port": 443,
            "database": "ANALYTICS"
        },
        "sql_server": {
            "host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
            "port": 1433,
            "database": "analytics",
            "auth_method": "password_auth",
            "password_auth": {
                "username": "data_export_user",
                "password": "<string>"
            },
            "use_ssh_tunnel": False,
            "disable_ssl": False
        }
    } }
headers = {
    "X-API-KEY": "<api-key>",
    "Content-Type": "application/json"
}

response = requests.patch(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PATCH',
  headers: {'X-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    source: {
      name: 'production-primary',
      max_concurrent_transfers: 10,
      max_concurrent_queries_per_transfer: 1,
      aurora_mysql: {
        host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
        port: 3306,
        connection_database: 'mysql',
        auth_method: 'password_auth',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false
      },
      aurora_postgres: {
        host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
        port: 5432,
        database: 'analytics',
        auth_method: 'password_auth',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false,
        connection_timeout_in_seconds: 30
      },
      databricks: {
        host: 'adb-1099123456789876.12.azuredatabricks.net',
        port: 443,
        catalog: 'main',
        http_path: '/sql/1.0/endpoints/a98765ab4c3210a0',
        oauth_client_secret_auth: {client_id: '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d', client_secret: '<string>'},
        hive: {
          bucket_vendor: 'bucket_s3',
          bucket_s3: {
            bucket_name: 'acme-data-export-staging',
            bucket_region: 'us-east-1',
            aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'}
          }
        },
        use_ssh_tunnel: false
      },
      mongodb: {
        host: 'clusterID.mongodb.net',
        port: 27017,
        authentication_database: 'admin',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false
      },
      mysql: {
        host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
        port: 3306,
        connection_database: 'mysql',
        auth_method: 'password_auth',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false
      },
      oracle: {
        ssl_options: {wallet: '<string>'},
        host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
        port: 1521,
        database: 'ORCL',
        auth_method: 'password_auth',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false
      },
      postgres: {
        host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
        port: 5432,
        database: 'analytics',
        auth_method: 'password_auth',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false,
        connection_timeout_in_seconds: 30
      },
      singlestore: {
        host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
        port: 3306,
        connection_database: 'mysql',
        auth_method: 'password_auth',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false
      },
      snowflake: {
        username: 'DATA_EXPORT_USER',
        host: 'db54321.us-central1.gcp.snowflakecomputing.com',
        port: 443,
        database: 'ANALYTICS'
      },
      sql_server: {
        host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
        port: 1433,
        database: 'analytics',
        auth_method: 'password_auth',
        password_auth: {username: 'data_export_user', password: '<string>'},
        use_ssh_tunnel: false,
        disable_ssl: false
      }
    }
  })
};

fetch('https://api.prequel.co/sources/{source_id}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.prequel.co/sources/{source_id}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PATCH",
  CURLOPT_POSTFIELDS => json_encode([
    'source' => [
        'name' => 'production-primary',
        'max_concurrent_transfers' => 10,
        'max_concurrent_queries_per_transfer' => 1,
        'aurora_mysql' => [
                'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
                'port' => 3306,
                'connection_database' => 'mysql',
                'auth_method' => 'password_auth',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false
        ],
        'aurora_postgres' => [
                'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
                'port' => 5432,
                'database' => 'analytics',
                'auth_method' => 'password_auth',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false,
                'connection_timeout_in_seconds' => 30
        ],
        'databricks' => [
                'host' => 'adb-1099123456789876.12.azuredatabricks.net',
                'port' => 443,
                'catalog' => 'main',
                'http_path' => '/sql/1.0/endpoints/a98765ab4c3210a0',
                'oauth_client_secret_auth' => [
                                'client_id' => '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d',
                                'client_secret' => '<string>'
                ],
                'hive' => [
                                'bucket_vendor' => 'bucket_s3',
                                'bucket_s3' => [
                                                                'bucket_name' => 'acme-data-export-staging',
                                                                'bucket_region' => 'us-east-1',
                                                                'aws_access_keys' => [
                                                                                                                                'access_id' => 'AKIAIOSFODNN7EXAMPLE',
                                                                                                                                'secret_key' => '<string>'
                                                                ]
                                ]
                ],
                'use_ssh_tunnel' => false
        ],
        'mongodb' => [
                'host' => 'clusterID.mongodb.net',
                'port' => 27017,
                'authentication_database' => 'admin',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false
        ],
        'mysql' => [
                'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
                'port' => 3306,
                'connection_database' => 'mysql',
                'auth_method' => 'password_auth',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false
        ],
        'oracle' => [
                'ssl_options' => [
                                'wallet' => '<string>'
                ],
                'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
                'port' => 1521,
                'database' => 'ORCL',
                'auth_method' => 'password_auth',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false
        ],
        'postgres' => [
                'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
                'port' => 5432,
                'database' => 'analytics',
                'auth_method' => 'password_auth',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false,
                'connection_timeout_in_seconds' => 30
        ],
        'singlestore' => [
                'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
                'port' => 3306,
                'connection_database' => 'mysql',
                'auth_method' => 'password_auth',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false
        ],
        'snowflake' => [
                'username' => 'DATA_EXPORT_USER',
                'host' => 'db54321.us-central1.gcp.snowflakecomputing.com',
                'port' => 443,
                'database' => 'ANALYTICS'
        ],
        'sql_server' => [
                'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
                'port' => 1433,
                'database' => 'analytics',
                'auth_method' => 'password_auth',
                'password_auth' => [
                                'username' => 'data_export_user',
                                'password' => '<string>'
                ],
                'use_ssh_tunnel' => false,
                'disable_ssl' => false
        ]
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Content-Type: application/json",
    "X-API-KEY: <api-key>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.prequel.co/sources/{source_id}"

	payload := strings.NewReader("{\n  \"source\": {\n    \"name\": \"production-primary\",\n    \"max_concurrent_transfers\": 10,\n    \"max_concurrent_queries_per_transfer\": 1,\n    \"aurora_mysql\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"aurora_postgres\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 5432,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false,\n      \"connection_timeout_in_seconds\": 30\n    },\n    \"databricks\": {\n      \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n      \"port\": 443,\n      \"catalog\": \"main\",\n      \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n      \"oauth_client_secret_auth\": {\n        \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n        \"client_secret\": \"<string>\"\n      },\n      \"hive\": {\n        \"bucket_vendor\": \"bucket_s3\",\n        \"bucket_s3\": {\n          \"bucket_name\": \"acme-data-export-staging\",\n          \"bucket_region\": \"us-east-1\",\n          \"aws_access_keys\": {\n            \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n            \"secret_key\": \"<string>\"\n          }\n        }\n      },\n      \"use_ssh_tunnel\": false\n    },\n    \"mongodb\": {\n      \"host\": \"clusterID.mongodb.net\",\n      \"port\": 27017,\n      \"authentication_database\": \"admin\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"mysql\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"oracle\": {\n      \"ssl_options\": {\n        \"wallet\": \"<string>\"\n      },\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 1521,\n      \"database\": \"ORCL\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"postgres\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 5432,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false,\n      \"connection_timeout_in_seconds\": 30\n    },\n    \"singlestore\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"snowflake\": {\n      \"username\": \"DATA_EXPORT_USER\",\n      \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n      \"port\": 443,\n      \"database\": \"ANALYTICS\"\n    },\n    \"sql_server\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 1433,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    }\n  }\n}")

	req, _ := http.NewRequest("PATCH", url, payload)

	req.Header.Add("X-API-KEY", "<api-key>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.patch("https://api.prequel.co/sources/{source_id}")
  .header("X-API-KEY", "<api-key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"source\": {\n    \"name\": \"production-primary\",\n    \"max_concurrent_transfers\": 10,\n    \"max_concurrent_queries_per_transfer\": 1,\n    \"aurora_mysql\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"aurora_postgres\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 5432,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false,\n      \"connection_timeout_in_seconds\": 30\n    },\n    \"databricks\": {\n      \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n      \"port\": 443,\n      \"catalog\": \"main\",\n      \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n      \"oauth_client_secret_auth\": {\n        \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n        \"client_secret\": \"<string>\"\n      },\n      \"hive\": {\n        \"bucket_vendor\": \"bucket_s3\",\n        \"bucket_s3\": {\n          \"bucket_name\": \"acme-data-export-staging\",\n          \"bucket_region\": \"us-east-1\",\n          \"aws_access_keys\": {\n            \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n            \"secret_key\": \"<string>\"\n          }\n        }\n      },\n      \"use_ssh_tunnel\": false\n    },\n    \"mongodb\": {\n      \"host\": \"clusterID.mongodb.net\",\n      \"port\": 27017,\n      \"authentication_database\": \"admin\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"mysql\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"oracle\": {\n      \"ssl_options\": {\n        \"wallet\": \"<string>\"\n      },\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 1521,\n      \"database\": \"ORCL\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"postgres\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 5432,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false,\n      \"connection_timeout_in_seconds\": 30\n    },\n    \"singlestore\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"snowflake\": {\n      \"username\": \"DATA_EXPORT_USER\",\n      \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n      \"port\": 443,\n      \"database\": \"ANALYTICS\"\n    },\n    \"sql_server\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 1433,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    }\n  }\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.prequel.co/sources/{source_id}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Patch.new(url)
request["X-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"source\": {\n    \"name\": \"production-primary\",\n    \"max_concurrent_transfers\": 10,\n    \"max_concurrent_queries_per_transfer\": 1,\n    \"aurora_mysql\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"aurora_postgres\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 5432,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false,\n      \"connection_timeout_in_seconds\": 30\n    },\n    \"databricks\": {\n      \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n      \"port\": 443,\n      \"catalog\": \"main\",\n      \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n      \"oauth_client_secret_auth\": {\n        \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n        \"client_secret\": \"<string>\"\n      },\n      \"hive\": {\n        \"bucket_vendor\": \"bucket_s3\",\n        \"bucket_s3\": {\n          \"bucket_name\": \"acme-data-export-staging\",\n          \"bucket_region\": \"us-east-1\",\n          \"aws_access_keys\": {\n            \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n            \"secret_key\": \"<string>\"\n          }\n        }\n      },\n      \"use_ssh_tunnel\": false\n    },\n    \"mongodb\": {\n      \"host\": \"clusterID.mongodb.net\",\n      \"port\": 27017,\n      \"authentication_database\": \"admin\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"mysql\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"oracle\": {\n      \"ssl_options\": {\n        \"wallet\": \"<string>\"\n      },\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 1521,\n      \"database\": \"ORCL\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"postgres\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 5432,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false,\n      \"connection_timeout_in_seconds\": 30\n    },\n    \"singlestore\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 3306,\n      \"connection_database\": \"mysql\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    },\n    \"snowflake\": {\n      \"username\": \"DATA_EXPORT_USER\",\n      \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n      \"port\": 443,\n      \"database\": \"ANALYTICS\"\n    },\n    \"sql_server\": {\n      \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n      \"port\": 1433,\n      \"database\": \"analytics\",\n      \"auth_method\": \"password_auth\",\n      \"password_auth\": {\n        \"username\": \"data_export_user\",\n        \"password\": \"<string>\"\n      },\n      \"use_ssh_tunnel\": false,\n      \"disable_ssl\": false\n    }\n  }\n}"

response = http.request(request)
puts response.read_body

{
  "status": "success",
  "data": {
    "source": {
      "id": "<string>",
      "vendor": "snowflake",
      "name": "production-primary",
      "created_at": "2023-11-07T05:31:56Z",
      "updated_at": "2023-11-07T05:31:56Z",
      "max_concurrent_transfers": 10,
      "max_concurrent_queries_per_transfer": 1,
      "athena": {
        "workgroup": "primary",
        "connection_database": "default",
        "bucket_s3": {
          "bucket_name": "acme-data-export-staging",
          "bucket_region": "us-east-1"
        },
        "auth_method": "aws_iam_role",
        "aws_iam_role": {
          "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
        }
      }
    },
    "ssh_public_key": "<string>"
  },
  "message": "<string>"
}

{
  "status": "error",
  "message": "<string>",
  "data": null
}

{
  "status": "error",
  "message": "<string>",
  "data": null
}

{
  "status": "error",
  "message": "<string>",
  "data": null
}

{
  "status": "error",
  "message": "<string>",
  "data": null
}