Test destination connection
curl --request POST \
--url https://api.prequel.co/destinations/{destination_id}/test-connection \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"destination": {
"name": "<string>",
"frequency_minutes": 123,
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123,
"is_enabled": true,
"abs": {
"folder": "<string>",
"container_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": {
"shared_access_signature_token": "<string>"
},
"disable_manifest": false
},
"athena": {
"workgroup": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>"
}
},
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"clickhouse": {
"host": "<string>",
"port": 123,
"cluster": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "<string>",
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
}
},
"disable_ssl": true
},
"databricks": {
"host": "<string>",
"port": 123,
"schema": "<string>",
"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
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "<string>",
"bucket_auth_method": "azure_storage_account_access_key",
"azure_storage_account_access_key": {
"storage_account_access_key": "<string>"
}
},
"bucket_gcs": {
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"bucket_s3_compatible": {
"disable_ssl": true,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"retention_window_days": 7,
"column_mapping_mode": "none",
"deletion_vectors_disabled": false,
"change_data_feed_disabled": false
},
"gcs": {
"disable_manifest": false,
"folder": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"bucket_name": "<string>"
},
"google_sheets": {
"host": "<string>"
},
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": {
"password": "<string>"
},
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_auth_method": "<unknown>",
"gcp_service_account_role": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com"
},
"bucket_name": "<string>",
"folder": "<string>"
},
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"namespace": "<string>",
"warehouse": "<string>"
},
"catalog_glue": {
"storage_options": {
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"database": "<string>"
},
"catalog_s3_tables": {
"storage_options": {
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"database": "<string>",
"table_bucket_arn": "<string>"
},
"catalog_google_lakehouse": {
"project_id": "<string>",
"catalog_name": "<string>",
"schema": "<string>",
"bucket_name": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 7
},
"mongodb": {
"host": "<string>",
"port": 27017,
"authentication_database": "<string>",
"write_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"motherduck": {
"database": "<string>",
"schema": "<string>",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true
},
"planetscale": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"folder": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"primary_key_collation": "<string>"
},
"s3": {
"disable_manifest": false,
"folder": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"use_ssh_tunnel": true
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
}
'import requests
url = "https://api.prequel.co/destinations/{destination_id}/test-connection"
payload = { "destination": {
"name": "<string>",
"frequency_minutes": 123,
"enabled_models": ["<string>"],
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123,
"is_enabled": True,
"abs": {
"folder": "<string>",
"container_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": { "shared_access_signature_token": "<string>" },
"disable_manifest": False
},
"athena": {
"workgroup": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>"
}
},
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"clickhouse": {
"host": "<string>",
"port": 123,
"cluster": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "<string>",
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
}
},
"disable_ssl": True
},
"databricks": {
"host": "<string>",
"port": 123,
"schema": "<string>",
"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
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "<string>",
"bucket_auth_method": "azure_storage_account_access_key",
"azure_storage_account_access_key": { "storage_account_access_key": "<string>" }
},
"bucket_gcs": {
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"bucket_s3_compatible": {
"disable_ssl": True,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"retention_window_days": 7,
"column_mapping_mode": "none",
"deletion_vectors_disabled": False,
"change_data_feed_disabled": False
},
"gcs": {
"disable_manifest": False,
"folder": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"bucket_name": "<string>"
},
"google_sheets": { "host": "<string>" },
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": { "password": "<string>" },
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_auth_method": "<unknown>",
"gcp_service_account_role": { "service_account_email": "service-account-name@project-id.iam.gserviceaccount.com" },
"bucket_name": "<string>",
"folder": "<string>"
},
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" },
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"namespace": "<string>",
"warehouse": "<string>"
},
"catalog_glue": {
"storage_options": { "bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" },
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
} },
"database": "<string>"
},
"catalog_s3_tables": {
"storage_options": { "bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" },
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
} },
"database": "<string>",
"table_bucket_arn": "<string>"
},
"catalog_google_lakehouse": {
"project_id": "<string>",
"catalog_name": "<string>",
"schema": "<string>",
"bucket_name": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 7
},
"mongodb": {
"host": "<string>",
"port": 27017,
"authentication_database": "<string>",
"write_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"motherduck": {
"database": "<string>",
"schema": "<string>",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True
},
"planetscale": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"folder": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"primary_key_collation": "<string>"
},
"s3": {
"disable_manifest": False,
"folder": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"use_ssh_tunnel": True
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
} }
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({
destination: {
name: '<string>',
frequency_minutes: 123,
enabled_models: ['<string>'],
max_concurrent_transfers: 123,
max_concurrent_queries_per_transfer: 123,
is_enabled: true,
abs: {
folder: '<string>',
container_name: '<string>',
storage_account_name: '<string>',
auth_method: 'azure_service_shared_access_signature',
azure_service_shared_access_signature: {shared_access_signature_token: '<string>'},
disable_manifest: false
},
athena: {
workgroup: '<string>',
connection_database: '<string>',
write_database: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
bucket_s3: {bucket_name: '<string>', bucket_region: '<string>'}
},
aurora_mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_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>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
clickhouse: {
host: '<string>',
port: 123,
cluster: '<string>',
connection_database: '<string>',
write_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
bucket_s3: {
bucket_name: '<string>',
bucket_region: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'}
},
bucket_gcs: {
bucket_name: '<string>',
gcs_hmac_keys: {access_key: '<string>', secret: '<string>'}
},
disable_ssl: true
},
databricks: {
host: '<string>',
port: 123,
schema: '<string>',
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
},
delta_lake: {
bucket_abs: {
storage_account_name: '<string>',
bucket_auth_method: 'azure_storage_account_access_key',
azure_storage_account_access_key: {storage_account_access_key: '<string>'}
},
bucket_gcs: {
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcp_service_account_key: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com',
service_account_key: '<unknown>'
}
},
bucket_s3_compatible: {
disable_ssl: true,
bucket_auth_method: 'access_keys',
access_keys: {access_id: '<string>', secret_key: '<string>'}
},
retention_window_days: 7,
column_mapping_mode: 'none',
deletion_vectors_disabled: false,
change_data_feed_disabled: false
},
gcs: {
disable_manifest: false,
folder: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcs_hmac_keys: {access_key: '<string>', secret: '<string>'},
bucket_name: '<string>'
},
google_sheets: {host: '<string>'},
iceberg: {
catalog_iceberg_rest: {
oauth_bearer_token_auth: {password: '<string>'},
oauth_client_secret_auth: {client_id: '<string>', client_secret: '<string>'},
storage_options: {
bucket_gcs: {
bucket_auth_method: '<unknown>',
gcp_service_account_role: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com'
},
bucket_name: '<string>',
folder: '<string>'
},
bucket_s3: {
bucket_auth_method: '<unknown>',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'},
bucket_name: '<string>',
bucket_region: '<string>',
folder: '<string>'
}
},
namespace: '<string>',
warehouse: '<string>'
},
catalog_glue: {
storage_options: {
bucket_s3: {
bucket_auth_method: '<unknown>',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'},
bucket_name: '<string>',
bucket_region: '<string>',
folder: '<string>'
}
},
database: '<string>'
},
catalog_s3_tables: {
storage_options: {
bucket_s3: {
bucket_auth_method: '<unknown>',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'},
bucket_name: '<string>',
bucket_region: '<string>',
folder: '<string>'
}
},
database: '<string>',
table_bucket_arn: '<string>'
},
catalog_google_lakehouse: {
project_id: '<string>',
catalog_name: '<string>',
schema: '<string>',
bucket_name: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcp_service_account_key: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com',
service_account_key: '<unknown>'
}
},
retention_window_days: 7
},
mongodb: {
host: '<string>',
port: 27017,
authentication_database: '<string>',
write_database: '<string>',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
motherduck: {database: '<string>', schema: '<string>', auth_method: 'access_token_auth'},
mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_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>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true
},
planetscale: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
postgres: {
host: '<string>',
port: 123,
database: '<string>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
sftp: {
username: '<string>',
host: '<string>',
port: 123,
folder: '<string>',
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
singlestore: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_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>',
schema: '<string>'
},
sql_server: {
host: '<string>',
port: 123,
database: '<string>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
primary_key_collation: '<string>'
},
s3: {
disable_manifest: false,
folder: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
bucket_name: '<string>',
bucket_region: '<string>',
use_ssh_tunnel: true
},
machine_type_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a'
}
})
};
fetch('https://api.prequel.co/destinations/{destination_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/destinations/{destination_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([
'destination' => [
'name' => '<string>',
'frequency_minutes' => 123,
'enabled_models' => [
'<string>'
],
'max_concurrent_transfers' => 123,
'max_concurrent_queries_per_transfer' => 123,
'is_enabled' => true,
'abs' => [
'folder' => '<string>',
'container_name' => '<string>',
'storage_account_name' => '<string>',
'auth_method' => 'azure_service_shared_access_signature',
'azure_service_shared_access_signature' => [
'shared_access_signature_token' => '<string>'
],
'disable_manifest' => false
],
'athena' => [
'workgroup' => '<string>',
'connection_database' => '<string>',
'write_database' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'bucket_s3' => [
'bucket_name' => '<string>',
'bucket_region' => '<string>'
]
],
'aurora_mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_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>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'clickhouse' => [
'host' => '<string>',
'port' => 123,
'cluster' => '<string>',
'connection_database' => '<string>',
'write_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'bucket_s3' => [
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
]
],
'bucket_gcs' => [
'bucket_name' => '<string>',
'gcs_hmac_keys' => [
'access_key' => '<string>',
'secret' => '<string>'
]
],
'disable_ssl' => true
],
'databricks' => [
'host' => '<string>',
'port' => 123,
'schema' => '<string>',
'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
],
'delta_lake' => [
'bucket_abs' => [
'storage_account_name' => '<string>',
'bucket_auth_method' => 'azure_storage_account_access_key',
'azure_storage_account_access_key' => [
'storage_account_access_key' => '<string>'
]
],
'bucket_gcs' => [
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com',
'service_account_key' => '<unknown>'
]
],
'bucket_s3_compatible' => [
'disable_ssl' => true,
'bucket_auth_method' => 'access_keys',
'access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
]
],
'retention_window_days' => 7,
'column_mapping_mode' => 'none',
'deletion_vectors_disabled' => false,
'change_data_feed_disabled' => false
],
'gcs' => [
'disable_manifest' => false,
'folder' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcs_hmac_keys' => [
'access_key' => '<string>',
'secret' => '<string>'
],
'bucket_name' => '<string>'
],
'google_sheets' => [
'host' => '<string>'
],
'iceberg' => [
'catalog_iceberg_rest' => [
'oauth_bearer_token_auth' => [
'password' => '<string>'
],
'oauth_client_secret_auth' => [
'client_id' => '<string>',
'client_secret' => '<string>'
],
'storage_options' => [
'bucket_gcs' => [
'bucket_auth_method' => '<unknown>',
'gcp_service_account_role' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com'
],
'bucket_name' => '<string>',
'folder' => '<string>'
],
'bucket_s3' => [
'bucket_auth_method' => '<unknown>',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'folder' => '<string>'
]
],
'namespace' => '<string>',
'warehouse' => '<string>'
],
'catalog_glue' => [
'storage_options' => [
'bucket_s3' => [
'bucket_auth_method' => '<unknown>',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'folder' => '<string>'
]
],
'database' => '<string>'
],
'catalog_s3_tables' => [
'storage_options' => [
'bucket_s3' => [
'bucket_auth_method' => '<unknown>',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'folder' => '<string>'
]
],
'database' => '<string>',
'table_bucket_arn' => '<string>'
],
'catalog_google_lakehouse' => [
'project_id' => '<string>',
'catalog_name' => '<string>',
'schema' => '<string>',
'bucket_name' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com',
'service_account_key' => '<unknown>'
]
],
'retention_window_days' => 7
],
'mongodb' => [
'host' => '<string>',
'port' => 27017,
'authentication_database' => '<string>',
'write_database' => '<string>',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'motherduck' => [
'database' => '<string>',
'schema' => '<string>',
'auth_method' => 'access_token_auth'
],
'mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_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>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true
],
'planetscale' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'sftp' => [
'username' => '<string>',
'host' => '<string>',
'port' => 123,
'folder' => '<string>',
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'singlestore' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_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>',
'schema' => '<string>'
],
'sql_server' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'primary_key_collation' => '<string>'
],
's3' => [
'disable_manifest' => false,
'folder' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'use_ssh_tunnel' => true
],
'machine_type_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a'
]
]),
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/destinations/{destination_id}/test-connection"
payload := strings.NewReader("{\n \"destination\": {\n \"name\": \"<string>\",\n \"frequency_minutes\": 123,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 123,\n \"max_concurrent_queries_per_transfer\": 123,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"<string>\",\n \"container_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n },\n \"disable_manifest\": false\n },\n \"athena\": {\n \"workgroup\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<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 \"clickhouse\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"cluster\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\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 \"bucket_gcs\": {\n \"bucket_name\": \"<string>\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": true\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"schema\": \"<string>\",\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 \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"<string>\",\n \"bucket_auth_method\": \"azure_storage_account_access_key\",\n \"azure_storage_account_access_key\": {\n \"storage_account_access_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"bucket_s3_compatible\": {\n \"disable_ssl\": true,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 7,\n \"column_mapping_mode\": \"none\",\n \"deletion_vectors_disabled\": false,\n \"change_data_feed_disabled\": false\n },\n \"gcs\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"<string>\"\n },\n \"google_sheets\": {\n \"host\": \"<string>\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n },\n \"bucket_name\": \"<string>\",\n \"folder\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"namespace\": \"<string>\",\n \"warehouse\": \"<string>\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\",\n \"table_bucket_arn\": \"<string>\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"<string>\",\n \"catalog_name\": \"<string>\",\n \"schema\": \"<string>\",\n \"bucket_name\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"retention_window_days\": 7\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 27017,\n \"authentication_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"motherduck\": {\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"planetscale\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"folder\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"primary_key_collation\": \"<string>\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\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/destinations/{destination_id}/test-connection")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"destination\": {\n \"name\": \"<string>\",\n \"frequency_minutes\": 123,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 123,\n \"max_concurrent_queries_per_transfer\": 123,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"<string>\",\n \"container_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n },\n \"disable_manifest\": false\n },\n \"athena\": {\n \"workgroup\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<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 \"clickhouse\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"cluster\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\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 \"bucket_gcs\": {\n \"bucket_name\": \"<string>\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": true\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"schema\": \"<string>\",\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 \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"<string>\",\n \"bucket_auth_method\": \"azure_storage_account_access_key\",\n \"azure_storage_account_access_key\": {\n \"storage_account_access_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"bucket_s3_compatible\": {\n \"disable_ssl\": true,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 7,\n \"column_mapping_mode\": \"none\",\n \"deletion_vectors_disabled\": false,\n \"change_data_feed_disabled\": false\n },\n \"gcs\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"<string>\"\n },\n \"google_sheets\": {\n \"host\": \"<string>\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n },\n \"bucket_name\": \"<string>\",\n \"folder\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"namespace\": \"<string>\",\n \"warehouse\": \"<string>\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\",\n \"table_bucket_arn\": \"<string>\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"<string>\",\n \"catalog_name\": \"<string>\",\n \"schema\": \"<string>\",\n \"bucket_name\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"retention_window_days\": 7\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 27017,\n \"authentication_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"motherduck\": {\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"planetscale\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"folder\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"primary_key_collation\": \"<string>\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.prequel.co/destinations/{destination_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 \"destination\": {\n \"name\": \"<string>\",\n \"frequency_minutes\": 123,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 123,\n \"max_concurrent_queries_per_transfer\": 123,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"<string>\",\n \"container_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n },\n \"disable_manifest\": false\n },\n \"athena\": {\n \"workgroup\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<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 \"clickhouse\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"cluster\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\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 \"bucket_gcs\": {\n \"bucket_name\": \"<string>\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": true\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"schema\": \"<string>\",\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 \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"<string>\",\n \"bucket_auth_method\": \"azure_storage_account_access_key\",\n \"azure_storage_account_access_key\": {\n \"storage_account_access_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"bucket_s3_compatible\": {\n \"disable_ssl\": true,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 7,\n \"column_mapping_mode\": \"none\",\n \"deletion_vectors_disabled\": false,\n \"change_data_feed_disabled\": false\n },\n \"gcs\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"<string>\"\n },\n \"google_sheets\": {\n \"host\": \"<string>\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n },\n \"bucket_name\": \"<string>\",\n \"folder\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"namespace\": \"<string>\",\n \"warehouse\": \"<string>\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\",\n \"table_bucket_arn\": \"<string>\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"<string>\",\n \"catalog_name\": \"<string>\",\n \"schema\": \"<string>\",\n \"bucket_name\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"retention_window_days\": 7\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 27017,\n \"authentication_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"motherduck\": {\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"planetscale\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"folder\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"primary_key_collation\": \"<string>\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "<string>",
"data": {
"destination": {
"abs": {
"folder": "<string>",
"container_name": "<string>",
"auth_method": "<string>",
"storage_account_name": "<string>",
"disable_manifest": true,
"csv": {
"delimiter": "<string>"
}
},
"id": "<string>",
"vendor": "<string>",
"name": "<string>",
"recipient_id": "<string>",
"created_at": "2023-11-07T05:31:56Z",
"updated_at": "2023-11-07T05:31:56Z",
"last_successful_transfer_ended_at": "2023-11-07T05:31:56Z",
"frequency_minutes": 123,
"id_in_provider_system": "<string>",
"products": [
"<string>"
],
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123,
"is_enabled": true,
"last_completed_transfer": {
"id": "<string>",
"status": "<string>",
"is_full_refresh": true,
"models": [
"<string>"
],
"log": "<string>",
"submitted_at": "2023-11-07T05:31:56Z",
"start_transfer_window_at": "2023-11-07T05:31:56Z",
"end_transfer_window_at": "2023-11-07T05:31:56Z",
"rows_transferred": 123,
"delta_rows_transferred": 123,
"volume_transferred_in_mb": 123,
"is_debug_mode": true,
"actor_id": "<string>",
"actor_type": "<string>",
"source_ids": [
"<string>"
],
"destination_id": "<string>",
"model_metrics": [
{
"model_id": "<string>",
"rows_transferred": 123,
"delta_rows_transferred": 123,
"volume_transferred_in_mb": 123,
"start_transfer_window_at": "2023-11-07T05:31:56Z",
"end_transfer_window_at": "2023-11-07T05:31:56Z",
"most_recent_last_updated_at": "2023-11-07T05:31:56Z",
"error": {
"error": "<unknown>",
"error_code": "<string>",
"title": "<string>",
"blame": "<string>",
"documentation_url": "<string>",
"trace": "<string>",
"message": "<string>"
},
"model_name": "<string>"
}
],
"models_snapshot": [
{
"model_id": "<string>",
"model_name": "<string>",
"revision_id": "<string>"
}
],
"started_at": "2023-11-07T05:31:56Z",
"ended_at": "2023-11-07T05:31:56Z",
"tags": {}
},
"total_rows_transferred_last_billing_period": 123,
"total_delta_rows_transferred_last_billing_period": 123,
"total_rows_transferred_current_billing_period": 123
}
},
"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
}Destinations
Test destination connection
Test the connection to a destination.
POST
/
destinations
/
{destination_id}
/
test-connection
Test destination connection
curl --request POST \
--url https://api.prequel.co/destinations/{destination_id}/test-connection \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"destination": {
"name": "<string>",
"frequency_minutes": 123,
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123,
"is_enabled": true,
"abs": {
"folder": "<string>",
"container_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": {
"shared_access_signature_token": "<string>"
},
"disable_manifest": false
},
"athena": {
"workgroup": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>"
}
},
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"clickhouse": {
"host": "<string>",
"port": 123,
"cluster": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "<string>",
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
}
},
"disable_ssl": true
},
"databricks": {
"host": "<string>",
"port": 123,
"schema": "<string>",
"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
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "<string>",
"bucket_auth_method": "azure_storage_account_access_key",
"azure_storage_account_access_key": {
"storage_account_access_key": "<string>"
}
},
"bucket_gcs": {
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"bucket_s3_compatible": {
"disable_ssl": true,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"retention_window_days": 7,
"column_mapping_mode": "none",
"deletion_vectors_disabled": false,
"change_data_feed_disabled": false
},
"gcs": {
"disable_manifest": false,
"folder": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"bucket_name": "<string>"
},
"google_sheets": {
"host": "<string>"
},
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": {
"password": "<string>"
},
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_auth_method": "<unknown>",
"gcp_service_account_role": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com"
},
"bucket_name": "<string>",
"folder": "<string>"
},
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"namespace": "<string>",
"warehouse": "<string>"
},
"catalog_glue": {
"storage_options": {
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"database": "<string>"
},
"catalog_s3_tables": {
"storage_options": {
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"database": "<string>",
"table_bucket_arn": "<string>"
},
"catalog_google_lakehouse": {
"project_id": "<string>",
"catalog_name": "<string>",
"schema": "<string>",
"bucket_name": "<string>",
"gcp_service_account_role": {
"service_account_email": "jsmith@example.com"
},
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 7
},
"mongodb": {
"host": "<string>",
"port": 27017,
"authentication_database": "<string>",
"write_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"motherduck": {
"database": "<string>",
"schema": "<string>",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true
},
"planetscale": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"connection_timeout_in_seconds": 1
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"folder": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": true,
"disable_ssl": true,
"primary_key_collation": "<string>"
},
"s3": {
"disable_manifest": false,
"folder": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"use_ssh_tunnel": true
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
}
'import requests
url = "https://api.prequel.co/destinations/{destination_id}/test-connection"
payload = { "destination": {
"name": "<string>",
"frequency_minutes": 123,
"enabled_models": ["<string>"],
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123,
"is_enabled": True,
"abs": {
"folder": "<string>",
"container_name": "<string>",
"storage_account_name": "<string>",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": { "shared_access_signature_token": "<string>" },
"disable_manifest": False
},
"athena": {
"workgroup": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>"
}
},
"aurora_mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"clickhouse": {
"host": "<string>",
"port": 123,
"cluster": "<string>",
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "<string>",
"bucket_region": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "<string>",
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
}
},
"disable_ssl": True
},
"databricks": {
"host": "<string>",
"port": 123,
"schema": "<string>",
"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
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "<string>",
"bucket_auth_method": "azure_storage_account_access_key",
"azure_storage_account_access_key": { "storage_account_access_key": "<string>" }
},
"bucket_gcs": {
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"bucket_s3_compatible": {
"disable_ssl": True,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
}
},
"retention_window_days": 7,
"column_mapping_mode": "none",
"deletion_vectors_disabled": False,
"change_data_feed_disabled": False
},
"gcs": {
"disable_manifest": False,
"folder": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcs_hmac_keys": {
"access_key": "<string>",
"secret": "<string>"
},
"bucket_name": "<string>"
},
"google_sheets": { "host": "<string>" },
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": { "password": "<string>" },
"oauth_client_secret_auth": {
"client_id": "<string>",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_auth_method": "<unknown>",
"gcp_service_account_role": { "service_account_email": "service-account-name@project-id.iam.gserviceaccount.com" },
"bucket_name": "<string>",
"folder": "<string>"
},
"bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" },
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
}
},
"namespace": "<string>",
"warehouse": "<string>"
},
"catalog_glue": {
"storage_options": { "bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" },
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
} },
"database": "<string>"
},
"catalog_s3_tables": {
"storage_options": { "bucket_s3": {
"bucket_auth_method": "<unknown>",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" },
"bucket_name": "<string>",
"bucket_region": "<string>",
"folder": "<string>"
} },
"database": "<string>",
"table_bucket_arn": "<string>"
},
"catalog_google_lakehouse": {
"project_id": "<string>",
"catalog_name": "<string>",
"schema": "<string>",
"bucket_name": "<string>",
"gcp_service_account_role": { "service_account_email": "jsmith@example.com" },
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 7
},
"mongodb": {
"host": "<string>",
"port": 27017,
"authentication_database": "<string>",
"write_database": "<string>",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"motherduck": {
"database": "<string>",
"schema": "<string>",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True
},
"planetscale": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_database": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True
},
"postgres": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"connection_timeout_in_seconds": 1
},
"sftp": {
"username": "<string>",
"host": "<string>",
"port": 123,
"folder": "<string>",
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"singlestore": {
"host": "<string>",
"port": 123,
"connection_database": "<string>",
"write_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>",
"schema": "<string>"
},
"sql_server": {
"host": "<string>",
"port": 123,
"database": "<string>",
"schema": "<string>",
"auth_method": "password_auth",
"password_auth": {
"username": "<string>",
"password": "<string>"
},
"use_ssh_tunnel": True,
"disable_ssl": True,
"primary_key_collation": "<string>"
},
"s3": {
"disable_manifest": False,
"folder": "<string>",
"aws_access_keys": {
"access_id": "<string>",
"secret_key": "<string>"
},
"bucket_name": "<string>",
"bucket_region": "<string>",
"use_ssh_tunnel": True
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
} }
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({
destination: {
name: '<string>',
frequency_minutes: 123,
enabled_models: ['<string>'],
max_concurrent_transfers: 123,
max_concurrent_queries_per_transfer: 123,
is_enabled: true,
abs: {
folder: '<string>',
container_name: '<string>',
storage_account_name: '<string>',
auth_method: 'azure_service_shared_access_signature',
azure_service_shared_access_signature: {shared_access_signature_token: '<string>'},
disable_manifest: false
},
athena: {
workgroup: '<string>',
connection_database: '<string>',
write_database: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
bucket_s3: {bucket_name: '<string>', bucket_region: '<string>'}
},
aurora_mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_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>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
clickhouse: {
host: '<string>',
port: 123,
cluster: '<string>',
connection_database: '<string>',
write_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
bucket_s3: {
bucket_name: '<string>',
bucket_region: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'}
},
bucket_gcs: {
bucket_name: '<string>',
gcs_hmac_keys: {access_key: '<string>', secret: '<string>'}
},
disable_ssl: true
},
databricks: {
host: '<string>',
port: 123,
schema: '<string>',
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
},
delta_lake: {
bucket_abs: {
storage_account_name: '<string>',
bucket_auth_method: 'azure_storage_account_access_key',
azure_storage_account_access_key: {storage_account_access_key: '<string>'}
},
bucket_gcs: {
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcp_service_account_key: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com',
service_account_key: '<unknown>'
}
},
bucket_s3_compatible: {
disable_ssl: true,
bucket_auth_method: 'access_keys',
access_keys: {access_id: '<string>', secret_key: '<string>'}
},
retention_window_days: 7,
column_mapping_mode: 'none',
deletion_vectors_disabled: false,
change_data_feed_disabled: false
},
gcs: {
disable_manifest: false,
folder: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcs_hmac_keys: {access_key: '<string>', secret: '<string>'},
bucket_name: '<string>'
},
google_sheets: {host: '<string>'},
iceberg: {
catalog_iceberg_rest: {
oauth_bearer_token_auth: {password: '<string>'},
oauth_client_secret_auth: {client_id: '<string>', client_secret: '<string>'},
storage_options: {
bucket_gcs: {
bucket_auth_method: '<unknown>',
gcp_service_account_role: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com'
},
bucket_name: '<string>',
folder: '<string>'
},
bucket_s3: {
bucket_auth_method: '<unknown>',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'},
bucket_name: '<string>',
bucket_region: '<string>',
folder: '<string>'
}
},
namespace: '<string>',
warehouse: '<string>'
},
catalog_glue: {
storage_options: {
bucket_s3: {
bucket_auth_method: '<unknown>',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'},
bucket_name: '<string>',
bucket_region: '<string>',
folder: '<string>'
}
},
database: '<string>'
},
catalog_s3_tables: {
storage_options: {
bucket_s3: {
bucket_auth_method: '<unknown>',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'},
bucket_name: '<string>',
bucket_region: '<string>',
folder: '<string>'
}
},
database: '<string>',
table_bucket_arn: '<string>'
},
catalog_google_lakehouse: {
project_id: '<string>',
catalog_name: '<string>',
schema: '<string>',
bucket_name: '<string>',
gcp_service_account_role: {service_account_email: 'jsmith@example.com'},
gcp_service_account_key: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com',
service_account_key: '<unknown>'
}
},
retention_window_days: 7
},
mongodb: {
host: '<string>',
port: 27017,
authentication_database: '<string>',
write_database: '<string>',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
motherduck: {database: '<string>', schema: '<string>', auth_method: 'access_token_auth'},
mysql: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_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>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true
},
planetscale: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_database: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true
},
postgres: {
host: '<string>',
port: 123,
database: '<string>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
connection_timeout_in_seconds: 1
},
sftp: {
username: '<string>',
host: '<string>',
port: 123,
folder: '<string>',
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
singlestore: {
host: '<string>',
port: 123,
connection_database: '<string>',
write_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>',
schema: '<string>'
},
sql_server: {
host: '<string>',
port: 123,
database: '<string>',
schema: '<string>',
auth_method: 'password_auth',
password_auth: {username: '<string>', password: '<string>'},
use_ssh_tunnel: true,
disable_ssl: true,
primary_key_collation: '<string>'
},
s3: {
disable_manifest: false,
folder: '<string>',
aws_access_keys: {access_id: '<string>', secret_key: '<string>'},
bucket_name: '<string>',
bucket_region: '<string>',
use_ssh_tunnel: true
},
machine_type_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a'
}
})
};
fetch('https://api.prequel.co/destinations/{destination_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/destinations/{destination_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([
'destination' => [
'name' => '<string>',
'frequency_minutes' => 123,
'enabled_models' => [
'<string>'
],
'max_concurrent_transfers' => 123,
'max_concurrent_queries_per_transfer' => 123,
'is_enabled' => true,
'abs' => [
'folder' => '<string>',
'container_name' => '<string>',
'storage_account_name' => '<string>',
'auth_method' => 'azure_service_shared_access_signature',
'azure_service_shared_access_signature' => [
'shared_access_signature_token' => '<string>'
],
'disable_manifest' => false
],
'athena' => [
'workgroup' => '<string>',
'connection_database' => '<string>',
'write_database' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'bucket_s3' => [
'bucket_name' => '<string>',
'bucket_region' => '<string>'
]
],
'aurora_mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_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>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'clickhouse' => [
'host' => '<string>',
'port' => 123,
'cluster' => '<string>',
'connection_database' => '<string>',
'write_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'bucket_s3' => [
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
]
],
'bucket_gcs' => [
'bucket_name' => '<string>',
'gcs_hmac_keys' => [
'access_key' => '<string>',
'secret' => '<string>'
]
],
'disable_ssl' => true
],
'databricks' => [
'host' => '<string>',
'port' => 123,
'schema' => '<string>',
'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
],
'delta_lake' => [
'bucket_abs' => [
'storage_account_name' => '<string>',
'bucket_auth_method' => 'azure_storage_account_access_key',
'azure_storage_account_access_key' => [
'storage_account_access_key' => '<string>'
]
],
'bucket_gcs' => [
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com',
'service_account_key' => '<unknown>'
]
],
'bucket_s3_compatible' => [
'disable_ssl' => true,
'bucket_auth_method' => 'access_keys',
'access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
]
],
'retention_window_days' => 7,
'column_mapping_mode' => 'none',
'deletion_vectors_disabled' => false,
'change_data_feed_disabled' => false
],
'gcs' => [
'disable_manifest' => false,
'folder' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcs_hmac_keys' => [
'access_key' => '<string>',
'secret' => '<string>'
],
'bucket_name' => '<string>'
],
'google_sheets' => [
'host' => '<string>'
],
'iceberg' => [
'catalog_iceberg_rest' => [
'oauth_bearer_token_auth' => [
'password' => '<string>'
],
'oauth_client_secret_auth' => [
'client_id' => '<string>',
'client_secret' => '<string>'
],
'storage_options' => [
'bucket_gcs' => [
'bucket_auth_method' => '<unknown>',
'gcp_service_account_role' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com'
],
'bucket_name' => '<string>',
'folder' => '<string>'
],
'bucket_s3' => [
'bucket_auth_method' => '<unknown>',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'folder' => '<string>'
]
],
'namespace' => '<string>',
'warehouse' => '<string>'
],
'catalog_glue' => [
'storage_options' => [
'bucket_s3' => [
'bucket_auth_method' => '<unknown>',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'folder' => '<string>'
]
],
'database' => '<string>'
],
'catalog_s3_tables' => [
'storage_options' => [
'bucket_s3' => [
'bucket_auth_method' => '<unknown>',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'folder' => '<string>'
]
],
'database' => '<string>',
'table_bucket_arn' => '<string>'
],
'catalog_google_lakehouse' => [
'project_id' => '<string>',
'catalog_name' => '<string>',
'schema' => '<string>',
'bucket_name' => '<string>',
'gcp_service_account_role' => [
'service_account_email' => 'jsmith@example.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com',
'service_account_key' => '<unknown>'
]
],
'retention_window_days' => 7
],
'mongodb' => [
'host' => '<string>',
'port' => 27017,
'authentication_database' => '<string>',
'write_database' => '<string>',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'motherduck' => [
'database' => '<string>',
'schema' => '<string>',
'auth_method' => 'access_token_auth'
],
'mysql' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_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>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true
],
'planetscale' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_database' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true
],
'postgres' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'connection_timeout_in_seconds' => 1
],
'sftp' => [
'username' => '<string>',
'host' => '<string>',
'port' => 123,
'folder' => '<string>',
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'singlestore' => [
'host' => '<string>',
'port' => 123,
'connection_database' => '<string>',
'write_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>',
'schema' => '<string>'
],
'sql_server' => [
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'schema' => '<string>',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => '<string>',
'password' => '<string>'
],
'use_ssh_tunnel' => true,
'disable_ssl' => true,
'primary_key_collation' => '<string>'
],
's3' => [
'disable_manifest' => false,
'folder' => '<string>',
'aws_access_keys' => [
'access_id' => '<string>',
'secret_key' => '<string>'
],
'bucket_name' => '<string>',
'bucket_region' => '<string>',
'use_ssh_tunnel' => true
],
'machine_type_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a'
]
]),
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/destinations/{destination_id}/test-connection"
payload := strings.NewReader("{\n \"destination\": {\n \"name\": \"<string>\",\n \"frequency_minutes\": 123,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 123,\n \"max_concurrent_queries_per_transfer\": 123,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"<string>\",\n \"container_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n },\n \"disable_manifest\": false\n },\n \"athena\": {\n \"workgroup\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<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 \"clickhouse\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"cluster\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\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 \"bucket_gcs\": {\n \"bucket_name\": \"<string>\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": true\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"schema\": \"<string>\",\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 \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"<string>\",\n \"bucket_auth_method\": \"azure_storage_account_access_key\",\n \"azure_storage_account_access_key\": {\n \"storage_account_access_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"bucket_s3_compatible\": {\n \"disable_ssl\": true,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 7,\n \"column_mapping_mode\": \"none\",\n \"deletion_vectors_disabled\": false,\n \"change_data_feed_disabled\": false\n },\n \"gcs\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"<string>\"\n },\n \"google_sheets\": {\n \"host\": \"<string>\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n },\n \"bucket_name\": \"<string>\",\n \"folder\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"namespace\": \"<string>\",\n \"warehouse\": \"<string>\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\",\n \"table_bucket_arn\": \"<string>\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"<string>\",\n \"catalog_name\": \"<string>\",\n \"schema\": \"<string>\",\n \"bucket_name\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"retention_window_days\": 7\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 27017,\n \"authentication_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"motherduck\": {\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"planetscale\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"folder\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"primary_key_collation\": \"<string>\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\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/destinations/{destination_id}/test-connection")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"destination\": {\n \"name\": \"<string>\",\n \"frequency_minutes\": 123,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 123,\n \"max_concurrent_queries_per_transfer\": 123,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"<string>\",\n \"container_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n },\n \"disable_manifest\": false\n },\n \"athena\": {\n \"workgroup\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<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 \"clickhouse\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"cluster\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\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 \"bucket_gcs\": {\n \"bucket_name\": \"<string>\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": true\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"schema\": \"<string>\",\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 \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"<string>\",\n \"bucket_auth_method\": \"azure_storage_account_access_key\",\n \"azure_storage_account_access_key\": {\n \"storage_account_access_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"bucket_s3_compatible\": {\n \"disable_ssl\": true,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 7,\n \"column_mapping_mode\": \"none\",\n \"deletion_vectors_disabled\": false,\n \"change_data_feed_disabled\": false\n },\n \"gcs\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"<string>\"\n },\n \"google_sheets\": {\n \"host\": \"<string>\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n },\n \"bucket_name\": \"<string>\",\n \"folder\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"namespace\": \"<string>\",\n \"warehouse\": \"<string>\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\",\n \"table_bucket_arn\": \"<string>\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"<string>\",\n \"catalog_name\": \"<string>\",\n \"schema\": \"<string>\",\n \"bucket_name\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"retention_window_days\": 7\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 27017,\n \"authentication_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"motherduck\": {\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"planetscale\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"folder\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"primary_key_collation\": \"<string>\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.prequel.co/destinations/{destination_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 \"destination\": {\n \"name\": \"<string>\",\n \"frequency_minutes\": 123,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 123,\n \"max_concurrent_queries_per_transfer\": 123,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"<string>\",\n \"container_name\": \"<string>\",\n \"storage_account_name\": \"<string>\",\n \"auth_method\": \"azure_service_shared_access_signature\",\n \"azure_service_shared_access_signature\": {\n \"shared_access_signature_token\": \"<string>\"\n },\n \"disable_manifest\": false\n },\n \"athena\": {\n \"workgroup\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<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 \"clickhouse\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"cluster\": \"<string>\",\n \"connection_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\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 \"bucket_gcs\": {\n \"bucket_name\": \"<string>\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": true\n },\n \"databricks\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"schema\": \"<string>\",\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 \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"<string>\",\n \"bucket_auth_method\": \"azure_storage_account_access_key\",\n \"azure_storage_account_access_key\": {\n \"storage_account_access_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"bucket_s3_compatible\": {\n \"disable_ssl\": true,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 7,\n \"column_mapping_mode\": \"none\",\n \"deletion_vectors_disabled\": false,\n \"change_data_feed_disabled\": false\n },\n \"gcs\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"<string>\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"<string>\"\n },\n \"google_sheets\": {\n \"host\": \"<string>\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"<string>\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n },\n \"bucket_name\": \"<string>\",\n \"folder\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"namespace\": \"<string>\",\n \"warehouse\": \"<string>\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_auth_method\": \"<unknown>\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"folder\": \"<string>\"\n }\n },\n \"database\": \"<string>\",\n \"table_bucket_arn\": \"<string>\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"<string>\",\n \"catalog_name\": \"<string>\",\n \"schema\": \"<string>\",\n \"bucket_name\": \"<string>\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"jsmith@example.com\"\n },\n \"gcp_service_account_key\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\",\n \"service_account_key\": \"<unknown>\"\n }\n },\n \"retention_window_days\": 7\n },\n \"mongodb\": {\n \"host\": \"<string>\",\n \"port\": 27017,\n \"authentication_database\": \"<string>\",\n \"write_database\": \"<string>\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true,\n \"disable_ssl\": true\n },\n \"motherduck\": {\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": true\n },\n \"planetscale\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"postgres\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"sftp\": {\n \"username\": \"<string>\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"folder\": \"<string>\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"connection_database\": \"<string>\",\n \"write_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 \"schema\": \"<string>\"\n },\n \"sql_server\": {\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"schema\": \"<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 \"primary_key_collation\": \"<string>\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"<string>\",\n \"aws_access_keys\": {\n \"access_id\": \"<string>\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"<string>\",\n \"bucket_region\": \"<string>\",\n \"use_ssh_tunnel\": true\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "<string>",
"data": {
"destination": {
"abs": {
"folder": "<string>",
"container_name": "<string>",
"auth_method": "<string>",
"storage_account_name": "<string>",
"disable_manifest": true,
"csv": {
"delimiter": "<string>"
}
},
"id": "<string>",
"vendor": "<string>",
"name": "<string>",
"recipient_id": "<string>",
"created_at": "2023-11-07T05:31:56Z",
"updated_at": "2023-11-07T05:31:56Z",
"last_successful_transfer_ended_at": "2023-11-07T05:31:56Z",
"frequency_minutes": 123,
"id_in_provider_system": "<string>",
"products": [
"<string>"
],
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 123,
"max_concurrent_queries_per_transfer": 123,
"is_enabled": true,
"last_completed_transfer": {
"id": "<string>",
"status": "<string>",
"is_full_refresh": true,
"models": [
"<string>"
],
"log": "<string>",
"submitted_at": "2023-11-07T05:31:56Z",
"start_transfer_window_at": "2023-11-07T05:31:56Z",
"end_transfer_window_at": "2023-11-07T05:31:56Z",
"rows_transferred": 123,
"delta_rows_transferred": 123,
"volume_transferred_in_mb": 123,
"is_debug_mode": true,
"actor_id": "<string>",
"actor_type": "<string>",
"source_ids": [
"<string>"
],
"destination_id": "<string>",
"model_metrics": [
{
"model_id": "<string>",
"rows_transferred": 123,
"delta_rows_transferred": 123,
"volume_transferred_in_mb": 123,
"start_transfer_window_at": "2023-11-07T05:31:56Z",
"end_transfer_window_at": "2023-11-07T05:31:56Z",
"most_recent_last_updated_at": "2023-11-07T05:31:56Z",
"error": {
"error": "<unknown>",
"error_code": "<string>",
"title": "<string>",
"blame": "<string>",
"documentation_url": "<string>",
"trace": "<string>",
"message": "<string>"
},
"model_name": "<string>"
}
],
"models_snapshot": [
{
"model_id": "<string>",
"model_name": "<string>",
"revision_id": "<string>"
}
],
"started_at": "2023-11-07T05:31:56Z",
"ended_at": "2023-11-07T05:31:56Z",
"tags": {}
},
"total_rows_transferred_last_billing_period": 123,
"total_delta_rows_transferred_last_billing_period": 123,
"total_rows_transferred_current_billing_period": 123
}
},
"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