Test source connection
curl --request POST \
--url https://api.prequel.co/sources/{source_id}/test-connection \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"source": {
"name": "<string>",
"max_concurrent_transfers": 123,
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"aurora_postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"databricks": {
"host": "<string>",
"port": 123,
"catalog": "<string>",
"http_path": "<string>",
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": true
},
"mongodb": {
"host": "<string>",
"port": 123,
"authentication_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"oracle": {
"ssl_options": {
"wallet": "<string>"
},
"disable_ssl": "<unknown>",
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"snowflake": {
"username": "<string>",
"host": "<string>",
"port": 123,
"database": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
}
}
}
'import requests
url = "https://api.prequel.co/sources/{source_id}/test-connection"
payload = { "source": {
"name": "<string>",
"max_concurrent_transfers": 123,
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"aurora_postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"databricks": {
"host": "<string>",
"port": 123,
"catalog": "<string>",
"http_path": "<string>",
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": True
},
"mongodb": {
"host": "<string>",
"port": 123,
"authentication_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"oracle": {
"ssl_options": { "wallet": "<string>" },
"disable_ssl": "<unknown>",
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"snowflake": {
"username": "<string>",
"host": "<string>",
"port": 123,
"database": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
}
} }
headers = {
"X-API-KEY": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'X-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
source: {
name: '<string>',
max_concurrent_transfers: 123,
aurora_mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
aurora_postgres: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
databricks: {
host: '<string>',
port: 123,
catalog: '<string>',
http_path: '<string>',
oauth_client_secret_auth: {client_id: '<string>', client_secret: '<string>'},
hive: {
bucket_vendor: 'bucket_s3',
bucket_s3: {
bucket_name: '<string>',
bucket_region: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'}
}
},
use_ssh_tunnel: true
},
mongodb: {
host: '<string>',
port: 123,
authentication_database: '<string>',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
oracle: {
ssl_options: {wallet: '<string>'},
disable_ssl: '<unknown>',
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true
},
postgres: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
singlestore: {
host: '<string>',
port: 123,
connection_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
snowflake: {username: '<string>', host: '<string>', port: 123, database: '<string>'},
sql_server: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
}
}
})
};
fetch('https://api.prequel.co/sources/{source_id}/test-connection', 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}/test-connection",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'source' => [
'name' => '<string>',
'max_concurrent_transfers' => 123,
'aurora_mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'aurora_postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'databricks' => [
'host' => '<string>',
'port' => 123,
'catalog' => '<string>',
'http_path' => '<string>',
'oauth_client_secret_auth' => [
'client_id' => '<string>',
'client_secret' => '<string>'
],
'hive' => [
'bucket_vendor' => 'bucket_s3',
'bucket_s3' => [
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
]
]
],
'use_ssh_tunnel' => true
],
'mongodb' => [
'host' => '<string>',
'port' => 123,
'authentication_database' => '<string>',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'oracle' => [
'ssl_options' => [
'wallet' => '<string>'
],
'disable_ssl' => '<unknown>',
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true
],
'postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'singlestore' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'snowflake' => [
'username' => '<string>',
'host' => '<string>',
'port' => 123,
'database' => '<string>'
],
'sql_server' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
]
]
]),
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}/test-connection"
payload := strings.NewReader("{\n \"source\": {\n \"name\": \"<string>\",\n \"max_concurrent_transfers\": 123,\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"aurora_postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"catalog\": \"<string>\",\n \"http_path\": \"<string>\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": true\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"authentication_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"disable_ssl\": \"<unknown>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"snowflake\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n }\n }\n}")
req, _ := http.NewRequest("POST", 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.post("https://api.prequel.co/sources/{source_id}/test-connection")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"source\": {\n \"name\": \"<string>\",\n \"max_concurrent_transfers\": 123,\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"aurora_postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"catalog\": \"<string>\",\n \"http_path\": \"<string>\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": true\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"authentication_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"disable_ssl\": \"<unknown>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"snowflake\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n }\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.prequel.co/sources/{source_id}/test-connection")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["X-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"source\": {\n \"name\": \"<string>\",\n \"max_concurrent_transfers\": 123,\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"aurora_postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"catalog\": \"<string>\",\n \"http_path\": \"<string>\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": true\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"authentication_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"disable_ssl\": \"<unknown>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"snowflake\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n }\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "<string>",
"data": {
"source": {
"athena": {
"workgroup": "<string>",
"connection_database": "<string>",
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>"
},
"auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "<string>"
}
},
"id": "<string>",
"vendor": "<string>",
"name": "<string>",
"created_at": "2023-11-07T05:31:56Z",
"updated_at": "2023-11-07T05:31:56Z",
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123
},
"ssh_public_key": "<string>"
},
"message": "<string>"
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}Sources
Test source connection
Test the connection to a source.
POST
/
sources
/
{source_id}
/
test-connection
Test source connection
curl --request POST \
--url https://api.prequel.co/sources/{source_id}/test-connection \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"source": {
"name": "<string>",
"max_concurrent_transfers": 123,
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"aurora_postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"databricks": {
"host": "<string>",
"port": 123,
"catalog": "<string>",
"http_path": "<string>",
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": true
},
"mongodb": {
"host": "<string>",
"port": 123,
"authentication_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"oracle": {
"ssl_options": {
"wallet": "<string>"
},
"disable_ssl": "<unknown>",
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"snowflake": {
"username": "<string>",
"host": "<string>",
"port": 123,
"database": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
}
}
}
'import requests
url = "https://api.prequel.co/sources/{source_id}/test-connection"
payload = { "source": {
"name": "<string>",
"max_concurrent_transfers": 123,
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"aurora_postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"databricks": {
"host": "<string>",
"port": 123,
"catalog": "<string>",
"http_path": "<string>",
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": True
},
"mongodb": {
"host": "<string>",
"port": 123,
"authentication_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"oracle": {
"ssl_options": { "wallet": "<string>" },
"disable_ssl": "<unknown>",
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"snowflake": {
"username": "<string>",
"host": "<string>",
"port": 123,
"database": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
}
} }
headers = {
"X-API-KEY": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'X-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
source: {
name: '<string>',
max_concurrent_transfers: 123,
aurora_mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
aurora_postgres: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
databricks: {
host: '<string>',
port: 123,
catalog: '<string>',
http_path: '<string>',
oauth_client_secret_auth: {client_id: '<string>', client_secret: '<string>'},
hive: {
bucket_vendor: 'bucket_s3',
bucket_s3: {
bucket_name: '<string>',
bucket_region: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'}
}
},
use_ssh_tunnel: true
},
mongodb: {
host: '<string>',
port: 123,
authentication_database: '<string>',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
oracle: {
ssl_options: {wallet: '<string>'},
disable_ssl: '<unknown>',
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true
},
postgres: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
singlestore: {
host: '<string>',
port: 123,
connection_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
snowflake: {username: '<string>', host: '<string>', port: 123, database: '<string>'},
sql_server: {
host: '<string>',
port: 123,
database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
}
}
})
};
fetch('https://api.prequel.co/sources/{source_id}/test-connection', 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}/test-connection",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'source' => [
'name' => '<string>',
'max_concurrent_transfers' => 123,
'aurora_mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'aurora_postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'databricks' => [
'host' => '<string>',
'port' => 123,
'catalog' => '<string>',
'http_path' => '<string>',
'oauth_client_secret_auth' => [
'client_id' => '<string>',
'client_secret' => '<string>'
],
'hive' => [
'bucket_vendor' => 'bucket_s3',
'bucket_s3' => [
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
]
]
],
'use_ssh_tunnel' => true
],
'mongodb' => [
'host' => '<string>',
'port' => 123,
'authentication_database' => '<string>',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'oracle' => [
'ssl_options' => [
'wallet' => '<string>'
],
'disable_ssl' => '<unknown>',
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true
],
'postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'singlestore' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'snowflake' => [
'username' => '<string>',
'host' => '<string>',
'port' => 123,
'database' => '<string>'
],
'sql_server' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
]
]
]),
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}/test-connection"
payload := strings.NewReader("{\n \"source\": {\n \"name\": \"<string>\",\n \"max_concurrent_transfers\": 123,\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"aurora_postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"catalog\": \"<string>\",\n \"http_path\": \"<string>\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": true\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"authentication_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"disable_ssl\": \"<unknown>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"snowflake\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n }\n }\n}")
req, _ := http.NewRequest("POST", 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.post("https://api.prequel.co/sources/{source_id}/test-connection")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"source\": {\n \"name\": \"<string>\",\n \"max_concurrent_transfers\": 123,\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"aurora_postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"catalog\": \"<string>\",\n \"http_path\": \"<string>\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": true\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"authentication_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"disable_ssl\": \"<unknown>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"snowflake\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n }\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.prequel.co/sources/{source_id}/test-connection")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["X-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"source\": {\n \"name\": \"<string>\",\n \"max_concurrent_transfers\": 123,\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"aurora_postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"catalog\": \"<string>\",\n \"http_path\": \"<string>\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": true\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"authentication_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"disable_ssl\": \"<unknown>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true,\n \"connection_timeout_in_seconds\": 1\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"snowflake\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n }\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "<string>",
"data": {
"source": {
"athena": {
"workgroup": "<string>",
"connection_database": "<string>",
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>"
},
"auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "<string>"
}
},
"id": "<string>",
"vendor": "<string>",
"name": "<string>",
"created_at": "2023-11-07T05:31:56Z",
"updated_at": "2023-11-07T05:31:56Z",
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123
},
"ssh_public_key": "<string>"
},
"message": "<string>"
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}{
"status": "<string>",
"message": "<string>",
"data": null
}⌘I