Update destination
curl --request PATCH \
--url https://api.prequel.co/destinations/{destination_id} \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"destination": {
"name": "acme-corp-prod",
"frequency_minutes": 60,
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 10,
"max_concurrent_queries_per_transfer": 1,
"is_enabled": true,
"abs": {
"folder": "data_export",
"container_name": "data-export",
"storage_account_name": "acmestorage",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": {
"shared_access_signature_token": "<string>"
},
"disable_manifest": false
},
"athena": {
"workgroup": "primary",
"connection_database": "default",
"write_database": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1"
}
},
"aurora_mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"aurora_postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false,
"connection_timeout_in_seconds": 30
},
"clickhouse": {
"host": "abc123xyz.us-east-1.aws.clickhouse.cloud",
"port": 8443,
"cluster": "default",
"connection_database": "default",
"write_database": "default",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
}
},
"disable_ssl": false
},
"databricks": {
"host": "adb-1099123456789876.12.azuredatabricks.net",
"port": 443,
"schema": "data_export",
"catalog": "main",
"http_path": "/sql/1.0/endpoints/a98765ab4c3210a0",
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": false
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "acmestorage",
"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": "data-export@acme-analytics-1234.iam.gserviceaccount.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": false,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"retention_window_days": 30,
"column_mapping_mode": "none",
"deletion_vectors_disabled": false,
"change_data_feed_disabled": false
},
"gcs": {
"disable_manifest": false,
"folder": "data_export",
"gcp_service_account_role": {
"service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com"
},
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
},
"bucket_name": "acme-data-export-staging"
},
"google_sheets": {
"host": "https://docs.google.com/spreadsheets/d/1234567"
},
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": {
"password": "<string>"
},
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"folder": "data_export",
"bucket_auth_method": "gcp_service_account_role",
"gcp_service_account_role": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com"
}
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
}
}
},
"namespace": "data_export",
"warehouse": "s3://acme-data-export-staging/warehouse"
},
"catalog_glue": {
"storage_options": {
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
}
}
},
"database": "analytics"
},
"catalog_s3_tables": {
"storage_options": {
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
}
}
},
"database": "analytics",
"table_bucket_arn": "arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables"
},
"catalog_google_lakehouse": {
"project_id": "acme-analytics-1234",
"catalog_name": "data_export_catalog",
"schema": "data_export",
"bucket_name": "acme-data-export-staging",
"gcp_service_account_role": {
"service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com"
},
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 30
},
"mongodb": {
"host": "clusterID.mongodb.net",
"port": 27017,
"authentication_database": "admin",
"write_database": "data_export",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"motherduck": {
"database": "my_db",
"schema": "data_export",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"oracle": {
"ssl_options": {
"wallet": "<string>"
},
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1521,
"database": "ORCL",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"planetscale": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false,
"connection_timeout_in_seconds": 30
},
"sftp": {
"username": "data_export_user",
"host": "sftp.acme.com",
"port": 22,
"folder": "/uploads/data_export",
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"singlestore": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"snowflake": {
"username": "DATA_EXPORT_USER",
"host": "db54321.us-central1.gcp.snowflakecomputing.com",
"port": 443,
"database": "ANALYTICS",
"schema": "data_export"
},
"sql_server": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1433,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false,
"primary_key_collation": "SQL_Latin1_General_CP1_CI_AS"
},
"s3": {
"disable_manifest": false,
"folder": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"use_ssh_tunnel": false
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
}
'import requests
url = "https://api.prequel.co/destinations/{destination_id}"
payload = { "destination": {
"name": "acme-corp-prod",
"frequency_minutes": 60,
"enabled_models": ["<string>"],
"max_concurrent_transfers": 10,
"max_concurrent_queries_per_transfer": 1,
"is_enabled": True,
"abs": {
"folder": "data_export",
"container_name": "data-export",
"storage_account_name": "acmestorage",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": { "shared_access_signature_token": "<string>" },
"disable_manifest": False
},
"athena": {
"workgroup": "primary",
"connection_database": "default",
"write_database": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1"
}
},
"aurora_mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"aurora_postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False,
"connection_timeout_in_seconds": 30
},
"clickhouse": {
"host": "abc123xyz.us-east-1.aws.clickhouse.cloud",
"port": 8443,
"cluster": "default",
"connection_database": "default",
"write_database": "default",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
}
},
"disable_ssl": False
},
"databricks": {
"host": "adb-1099123456789876.12.azuredatabricks.net",
"port": 443,
"schema": "data_export",
"catalog": "main",
"http_path": "/sql/1.0/endpoints/a98765ab4c3210a0",
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": False
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "acmestorage",
"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": "data-export@acme-analytics-1234.iam.gserviceaccount.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": False,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"retention_window_days": 30,
"column_mapping_mode": "none",
"deletion_vectors_disabled": False,
"change_data_feed_disabled": False
},
"gcs": {
"disable_manifest": False,
"folder": "data_export",
"gcp_service_account_role": { "service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com" },
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
},
"bucket_name": "acme-data-export-staging"
},
"google_sheets": { "host": "https://docs.google.com/spreadsheets/d/1234567" },
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": { "password": "<string>" },
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"folder": "data_export",
"bucket_auth_method": "gcp_service_account_role",
"gcp_service_account_role": { "service_account_email": "service-account-name@project-id.iam.gserviceaccount.com" }
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" }
}
},
"namespace": "data_export",
"warehouse": "s3://acme-data-export-staging/warehouse"
},
"catalog_glue": {
"storage_options": { "bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" }
} },
"database": "analytics"
},
"catalog_s3_tables": {
"storage_options": { "bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" }
} },
"database": "analytics",
"table_bucket_arn": "arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables"
},
"catalog_google_lakehouse": {
"project_id": "acme-analytics-1234",
"catalog_name": "data_export_catalog",
"schema": "data_export",
"bucket_name": "acme-data-export-staging",
"gcp_service_account_role": { "service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com" },
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 30
},
"mongodb": {
"host": "clusterID.mongodb.net",
"port": 27017,
"authentication_database": "admin",
"write_database": "data_export",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"motherduck": {
"database": "my_db",
"schema": "data_export",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"oracle": {
"ssl_options": { "wallet": "<string>" },
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1521,
"database": "ORCL",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"planetscale": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False,
"connection_timeout_in_seconds": 30
},
"sftp": {
"username": "data_export_user",
"host": "sftp.acme.com",
"port": 22,
"folder": "/uploads/data_export",
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"singlestore": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"snowflake": {
"username": "DATA_EXPORT_USER",
"host": "db54321.us-central1.gcp.snowflakecomputing.com",
"port": 443,
"database": "ANALYTICS",
"schema": "data_export"
},
"sql_server": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1433,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False,
"primary_key_collation": "SQL_Latin1_General_CP1_CI_AS"
},
"s3": {
"disable_manifest": False,
"folder": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"use_ssh_tunnel": False
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
} }
headers = {
"X-API-KEY": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {'X-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
destination: {
name: 'acme-corp-prod',
frequency_minutes: 60,
enabled_models: ['<string>'],
max_concurrent_transfers: 10,
max_concurrent_queries_per_transfer: 1,
is_enabled: true,
abs: {
folder: 'data_export',
container_name: 'data-export',
storage_account_name: 'acmestorage',
auth_method: 'azure_service_shared_access_signature',
azure_service_shared_access_signature: {shared_access_signature_token: '<string>'},
disable_manifest: false
},
athena: {
workgroup: 'primary',
connection_database: 'default',
write_database: 'data_export',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'},
bucket_s3: {bucket_name: 'acme-data-export-staging', bucket_region: 'us-east-1'}
},
aurora_mysql: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
aurora_postgres: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 5432,
database: 'analytics',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false,
connection_timeout_in_seconds: 30
},
clickhouse: {
host: 'abc123xyz.us-east-1.aws.clickhouse.cloud',
port: 8443,
cluster: 'default',
connection_database: 'default',
write_database: 'default',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'}
},
bucket_gcs: {
bucket_name: 'acme-data-export-staging',
gcs_hmac_keys: {access_key: 'GOOG1EXAMPLEACCESSID', secret: '<string>'}
},
disable_ssl: false
},
databricks: {
host: 'adb-1099123456789876.12.azuredatabricks.net',
port: 443,
schema: 'data_export',
catalog: 'main',
http_path: '/sql/1.0/endpoints/a98765ab4c3210a0',
oauth_client_secret_auth: {client_id: '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d', client_secret: '<string>'},
hive: {
bucket_vendor: 'bucket_s3',
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'}
}
},
use_ssh_tunnel: false
},
delta_lake: {
bucket_abs: {
storage_account_name: 'acmestorage',
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: 'data-export@acme-analytics-1234.iam.gserviceaccount.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: false,
bucket_auth_method: 'access_keys',
access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'}
},
retention_window_days: 30,
column_mapping_mode: 'none',
deletion_vectors_disabled: false,
change_data_feed_disabled: false
},
gcs: {
disable_manifest: false,
folder: 'data_export',
gcp_service_account_role: {
service_account_email: 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
},
gcs_hmac_keys: {access_key: 'GOOG1EXAMPLEACCESSID', secret: '<string>'},
bucket_name: 'acme-data-export-staging'
},
google_sheets: {host: 'https://docs.google.com/spreadsheets/d/1234567'},
iceberg: {
catalog_iceberg_rest: {
oauth_bearer_token_auth: {password: '<string>'},
oauth_client_secret_auth: {client_id: '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d', client_secret: '<string>'},
storage_options: {
bucket_gcs: {
bucket_name: 'acme-data-export-staging',
folder: 'data_export',
bucket_auth_method: 'gcp_service_account_role',
gcp_service_account_role: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com'
}
},
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
folder: 'data_export',
bucket_auth_method: 'aws_iam_role',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'}
}
},
namespace: 'data_export',
warehouse: 's3://acme-data-export-staging/warehouse'
},
catalog_glue: {
storage_options: {
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
folder: 'data_export',
bucket_auth_method: 'aws_iam_role',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'}
}
},
database: 'analytics'
},
catalog_s3_tables: {
storage_options: {
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
folder: 'data_export',
bucket_auth_method: 'aws_iam_role',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'}
}
},
database: 'analytics',
table_bucket_arn: 'arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables'
},
catalog_google_lakehouse: {
project_id: 'acme-analytics-1234',
catalog_name: 'data_export_catalog',
schema: 'data_export',
bucket_name: 'acme-data-export-staging',
gcp_service_account_role: {
service_account_email: 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
},
gcp_service_account_key: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com',
service_account_key: '<unknown>'
}
},
retention_window_days: 30
},
mongodb: {
host: 'clusterID.mongodb.net',
port: 27017,
authentication_database: 'admin',
write_database: 'data_export',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
motherduck: {database: 'my_db', schema: 'data_export', auth_method: 'access_token_auth'},
mysql: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
oracle: {
ssl_options: {wallet: '<string>'},
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 1521,
database: 'ORCL',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
planetscale: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
postgres: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 5432,
database: 'analytics',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false,
connection_timeout_in_seconds: 30
},
sftp: {
username: 'data_export_user',
host: 'sftp.acme.com',
port: 22,
folder: '/uploads/data_export',
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
singlestore: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
snowflake: {
username: 'DATA_EXPORT_USER',
host: 'db54321.us-central1.gcp.snowflakecomputing.com',
port: 443,
database: 'ANALYTICS',
schema: 'data_export'
},
sql_server: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 1433,
database: 'analytics',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false,
primary_key_collation: 'SQL_Latin1_General_CP1_CI_AS'
},
s3: {
disable_manifest: false,
folder: 'data_export',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'},
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
use_ssh_tunnel: false
},
machine_type_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a'
}
})
};
fetch('https://api.prequel.co/destinations/{destination_id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.prequel.co/destinations/{destination_id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'destination' => [
'name' => 'acme-corp-prod',
'frequency_minutes' => 60,
'enabled_models' => [
'<string>'
],
'max_concurrent_transfers' => 10,
'max_concurrent_queries_per_transfer' => 1,
'is_enabled' => true,
'abs' => [
'folder' => 'data_export',
'container_name' => 'data-export',
'storage_account_name' => 'acmestorage',
'auth_method' => 'azure_service_shared_access_signature',
'azure_service_shared_access_signature' => [
'shared_access_signature_token' => '<string>'
],
'disable_manifest' => false
],
'athena' => [
'workgroup' => 'primary',
'connection_database' => 'default',
'write_database' => 'data_export',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
],
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1'
]
],
'aurora_mysql' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'aurora_postgres' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 5432,
'database' => 'analytics',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false,
'connection_timeout_in_seconds' => 30
],
'clickhouse' => [
'host' => 'abc123xyz.us-east-1.aws.clickhouse.cloud',
'port' => 8443,
'cluster' => 'default',
'connection_database' => 'default',
'write_database' => 'default',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
]
],
'bucket_gcs' => [
'bucket_name' => 'acme-data-export-staging',
'gcs_hmac_keys' => [
'access_key' => 'GOOG1EXAMPLEACCESSID',
'secret' => '<string>'
]
],
'disable_ssl' => false
],
'databricks' => [
'host' => 'adb-1099123456789876.12.azuredatabricks.net',
'port' => 443,
'schema' => 'data_export',
'catalog' => 'main',
'http_path' => '/sql/1.0/endpoints/a98765ab4c3210a0',
'oauth_client_secret_auth' => [
'client_id' => '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d',
'client_secret' => '<string>'
],
'hive' => [
'bucket_vendor' => 'bucket_s3',
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
]
]
],
'use_ssh_tunnel' => false
],
'delta_lake' => [
'bucket_abs' => [
'storage_account_name' => 'acmestorage',
'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' => 'data-export@acme-analytics-1234.iam.gserviceaccount.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' => false,
'bucket_auth_method' => 'access_keys',
'access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
]
],
'retention_window_days' => 30,
'column_mapping_mode' => 'none',
'deletion_vectors_disabled' => false,
'change_data_feed_disabled' => false
],
'gcs' => [
'disable_manifest' => false,
'folder' => 'data_export',
'gcp_service_account_role' => [
'service_account_email' => 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
],
'gcs_hmac_keys' => [
'access_key' => 'GOOG1EXAMPLEACCESSID',
'secret' => '<string>'
],
'bucket_name' => 'acme-data-export-staging'
],
'google_sheets' => [
'host' => 'https://docs.google.com/spreadsheets/d/1234567'
],
'iceberg' => [
'catalog_iceberg_rest' => [
'oauth_bearer_token_auth' => [
'password' => '<string>'
],
'oauth_client_secret_auth' => [
'client_id' => '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d',
'client_secret' => '<string>'
],
'storage_options' => [
'bucket_gcs' => [
'bucket_name' => 'acme-data-export-staging',
'folder' => 'data_export',
'bucket_auth_method' => 'gcp_service_account_role',
'gcp_service_account_role' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com'
]
],
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'folder' => 'data_export',
'bucket_auth_method' => 'aws_iam_role',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
]
]
],
'namespace' => 'data_export',
'warehouse' => 's3://acme-data-export-staging/warehouse'
],
'catalog_glue' => [
'storage_options' => [
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'folder' => 'data_export',
'bucket_auth_method' => 'aws_iam_role',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
]
]
],
'database' => 'analytics'
],
'catalog_s3_tables' => [
'storage_options' => [
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'folder' => 'data_export',
'bucket_auth_method' => 'aws_iam_role',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
]
]
],
'database' => 'analytics',
'table_bucket_arn' => 'arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables'
],
'catalog_google_lakehouse' => [
'project_id' => 'acme-analytics-1234',
'catalog_name' => 'data_export_catalog',
'schema' => 'data_export',
'bucket_name' => 'acme-data-export-staging',
'gcp_service_account_role' => [
'service_account_email' => 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com',
'service_account_key' => '<unknown>'
]
],
'retention_window_days' => 30
],
'mongodb' => [
'host' => 'clusterID.mongodb.net',
'port' => 27017,
'authentication_database' => 'admin',
'write_database' => 'data_export',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'motherduck' => [
'database' => 'my_db',
'schema' => 'data_export',
'auth_method' => 'access_token_auth'
],
'mysql' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'oracle' => [
'ssl_options' => [
'wallet' => '<string>'
],
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 1521,
'database' => 'ORCL',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'planetscale' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'postgres' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 5432,
'database' => 'analytics',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false,
'connection_timeout_in_seconds' => 30
],
'sftp' => [
'username' => 'data_export_user',
'host' => 'sftp.acme.com',
'port' => 22,
'folder' => '/uploads/data_export',
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'singlestore' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'snowflake' => [
'username' => 'DATA_EXPORT_USER',
'host' => 'db54321.us-central1.gcp.snowflakecomputing.com',
'port' => 443,
'database' => 'ANALYTICS',
'schema' => 'data_export'
],
'sql_server' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 1433,
'database' => 'analytics',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false,
'primary_key_collation' => 'SQL_Latin1_General_CP1_CI_AS'
],
's3' => [
'disable_manifest' => false,
'folder' => 'data_export',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
],
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'use_ssh_tunnel' => false
],
'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}"
payload := strings.NewReader("{\n \"destination\": {\n \"name\": \"acme-corp-prod\",\n \"frequency_minutes\": 60,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 10,\n \"max_concurrent_queries_per_transfer\": 1,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"data_export\",\n \"container_name\": \"data-export\",\n \"storage_account_name\": \"acmestorage\",\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\": \"primary\",\n \"connection_database\": \"default\",\n \"write_database\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"aurora_postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"clickhouse\": {\n \"host\": \"abc123xyz.us-east-1.aws.clickhouse.cloud\",\n \"port\": 8443,\n \"cluster\": \"default\",\n \"connection_database\": \"default\",\n \"write_database\": \"default\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": false\n },\n \"databricks\": {\n \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n \"port\": 443,\n \"schema\": \"data_export\",\n \"catalog\": \"main\",\n \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": false\n },\n \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"acmestorage\",\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\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": false,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 30,\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\": \"data_export\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\"\n },\n \"google_sheets\": {\n \"host\": \"https://docs.google.com/spreadsheets/d/1234567\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"gcp_service_account_role\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n }\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"namespace\": \"data_export\",\n \"warehouse\": \"s3://acme-data-export-staging/warehouse\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\",\n \"table_bucket_arn\": \"arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"acme-analytics-1234\",\n \"catalog_name\": \"data_export_catalog\",\n \"schema\": \"data_export\",\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": 30\n },\n \"mongodb\": {\n \"host\": \"clusterID.mongodb.net\",\n \"port\": 27017,\n \"authentication_database\": \"admin\",\n \"write_database\": \"data_export\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"motherduck\": {\n \"database\": \"my_db\",\n \"schema\": \"data_export\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1521,\n \"database\": \"ORCL\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"planetscale\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"sftp\": {\n \"username\": \"data_export_user\",\n \"host\": \"sftp.acme.com\",\n \"port\": 22,\n \"folder\": \"/uploads/data_export\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"snowflake\": {\n \"username\": \"DATA_EXPORT_USER\",\n \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n \"port\": 443,\n \"database\": \"ANALYTICS\",\n \"schema\": \"data_export\"\n },\n \"sql_server\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1433,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"primary_key_collation\": \"SQL_Latin1_General_CP1_CI_AS\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"use_ssh_tunnel\": false\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("X-API-KEY", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://api.prequel.co/destinations/{destination_id}")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"destination\": {\n \"name\": \"acme-corp-prod\",\n \"frequency_minutes\": 60,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 10,\n \"max_concurrent_queries_per_transfer\": 1,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"data_export\",\n \"container_name\": \"data-export\",\n \"storage_account_name\": \"acmestorage\",\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\": \"primary\",\n \"connection_database\": \"default\",\n \"write_database\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"aurora_postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"clickhouse\": {\n \"host\": \"abc123xyz.us-east-1.aws.clickhouse.cloud\",\n \"port\": 8443,\n \"cluster\": \"default\",\n \"connection_database\": \"default\",\n \"write_database\": \"default\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": false\n },\n \"databricks\": {\n \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n \"port\": 443,\n \"schema\": \"data_export\",\n \"catalog\": \"main\",\n \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": false\n },\n \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"acmestorage\",\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\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": false,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 30,\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\": \"data_export\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\"\n },\n \"google_sheets\": {\n \"host\": \"https://docs.google.com/spreadsheets/d/1234567\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"gcp_service_account_role\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n }\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"namespace\": \"data_export\",\n \"warehouse\": \"s3://acme-data-export-staging/warehouse\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\",\n \"table_bucket_arn\": \"arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"acme-analytics-1234\",\n \"catalog_name\": \"data_export_catalog\",\n \"schema\": \"data_export\",\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": 30\n },\n \"mongodb\": {\n \"host\": \"clusterID.mongodb.net\",\n \"port\": 27017,\n \"authentication_database\": \"admin\",\n \"write_database\": \"data_export\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"motherduck\": {\n \"database\": \"my_db\",\n \"schema\": \"data_export\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1521,\n \"database\": \"ORCL\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"planetscale\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"sftp\": {\n \"username\": \"data_export_user\",\n \"host\": \"sftp.acme.com\",\n \"port\": 22,\n \"folder\": \"/uploads/data_export\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"snowflake\": {\n \"username\": \"DATA_EXPORT_USER\",\n \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n \"port\": 443,\n \"database\": \"ANALYTICS\",\n \"schema\": \"data_export\"\n },\n \"sql_server\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1433,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"primary_key_collation\": \"SQL_Latin1_General_CP1_CI_AS\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"use_ssh_tunnel\": false\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}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["X-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"destination\": {\n \"name\": \"acme-corp-prod\",\n \"frequency_minutes\": 60,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 10,\n \"max_concurrent_queries_per_transfer\": 1,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"data_export\",\n \"container_name\": \"data-export\",\n \"storage_account_name\": \"acmestorage\",\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\": \"primary\",\n \"connection_database\": \"default\",\n \"write_database\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"aurora_postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"clickhouse\": {\n \"host\": \"abc123xyz.us-east-1.aws.clickhouse.cloud\",\n \"port\": 8443,\n \"cluster\": \"default\",\n \"connection_database\": \"default\",\n \"write_database\": \"default\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": false\n },\n \"databricks\": {\n \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n \"port\": 443,\n \"schema\": \"data_export\",\n \"catalog\": \"main\",\n \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": false\n },\n \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"acmestorage\",\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\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": false,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 30,\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\": \"data_export\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\"\n },\n \"google_sheets\": {\n \"host\": \"https://docs.google.com/spreadsheets/d/1234567\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"gcp_service_account_role\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n }\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"namespace\": \"data_export\",\n \"warehouse\": \"s3://acme-data-export-staging/warehouse\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\",\n \"table_bucket_arn\": \"arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"acme-analytics-1234\",\n \"catalog_name\": \"data_export_catalog\",\n \"schema\": \"data_export\",\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": 30\n },\n \"mongodb\": {\n \"host\": \"clusterID.mongodb.net\",\n \"port\": 27017,\n \"authentication_database\": \"admin\",\n \"write_database\": \"data_export\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"motherduck\": {\n \"database\": \"my_db\",\n \"schema\": \"data_export\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1521,\n \"database\": \"ORCL\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"planetscale\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"sftp\": {\n \"username\": \"data_export_user\",\n \"host\": \"sftp.acme.com\",\n \"port\": 22,\n \"folder\": \"/uploads/data_export\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"snowflake\": {\n \"username\": \"DATA_EXPORT_USER\",\n \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n \"port\": 443,\n \"database\": \"ANALYTICS\",\n \"schema\": \"data_export\"\n },\n \"sql_server\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1433,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"primary_key_collation\": \"SQL_Latin1_General_CP1_CI_AS\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"use_ssh_tunnel\": false\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "success",
"data": {
"destination": {
"id": "<string>",
"vendor": "snowflake",
"name": "acme-corp-prod",
"recipient_id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"created_at": "2023-11-07T05:31:56Z",
"updated_at": "2023-11-07T05:31:56Z",
"last_successful_transfer_ended_at": "2023-11-07T05:31:56Z",
"abs": {
"folder": "data_export",
"container_name": "data-export",
"auth_method": "azure_service_shared_access_signature",
"storage_account_name": "acmestorage",
"disable_manifest": true,
"file_format": "parquet",
"csv": {
"delimiter": ","
}
},
"frequency_minutes": 60,
"id_in_provider_system": "cus_1a2b3c4d",
"products": [
"<string>"
],
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 10,
"max_concurrent_queries_per_transfer": 1,
"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": "2026-01-01T00:00:00Z",
"end_transfer_window_at": "2026-01-02T00:00:00Z",
"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": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"model_metrics": [
{
"model_id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"rows_transferred": 123,
"delta_rows_transferred": 123,
"volume_transferred_in_mb": 123,
"start_transfer_window_at": "2026-01-01T00:00:00Z",
"end_transfer_window_at": "2026-01-02T00:00:00Z",
"most_recent_last_updated_at": "2026-01-01T00:00:00Z",
"error": {
"error_code": "<string>",
"title": "<string>",
"blame": "<string>",
"documentation_url": "<string>",
"trace": "<string>",
"message": "<string>"
},
"model_name": "orders"
}
],
"models_snapshot": [
{
"model_id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"model_name": "orders",
"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": "error",
"message": "<string>",
"data": null
}{
"status": "error",
"message": "<string>",
"data": null
}{
"status": "error",
"message": "<string>",
"data": null
}{
"status": "error",
"message": "<string>",
"data": null
}Destinations
Update destination
Update an existing destination.
PATCH
/
destinations
/
{destination_id}
Update destination
curl --request PATCH \
--url https://api.prequel.co/destinations/{destination_id} \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: <api-key>' \
--data '
{
"destination": {
"name": "acme-corp-prod",
"frequency_minutes": 60,
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 10,
"max_concurrent_queries_per_transfer": 1,
"is_enabled": true,
"abs": {
"folder": "data_export",
"container_name": "data-export",
"storage_account_name": "acmestorage",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": {
"shared_access_signature_token": "<string>"
},
"disable_manifest": false
},
"athena": {
"workgroup": "primary",
"connection_database": "default",
"write_database": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1"
}
},
"aurora_mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"aurora_postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false,
"connection_timeout_in_seconds": 30
},
"clickhouse": {
"host": "abc123xyz.us-east-1.aws.clickhouse.cloud",
"port": 8443,
"cluster": "default",
"connection_database": "default",
"write_database": "default",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
}
},
"disable_ssl": false
},
"databricks": {
"host": "adb-1099123456789876.12.azuredatabricks.net",
"port": 443,
"schema": "data_export",
"catalog": "main",
"http_path": "/sql/1.0/endpoints/a98765ab4c3210a0",
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": false
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "acmestorage",
"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": "data-export@acme-analytics-1234.iam.gserviceaccount.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": false,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"retention_window_days": 30,
"column_mapping_mode": "none",
"deletion_vectors_disabled": false,
"change_data_feed_disabled": false
},
"gcs": {
"disable_manifest": false,
"folder": "data_export",
"gcp_service_account_role": {
"service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com"
},
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
},
"bucket_name": "acme-data-export-staging"
},
"google_sheets": {
"host": "https://docs.google.com/spreadsheets/d/1234567"
},
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": {
"password": "<string>"
},
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"folder": "data_export",
"bucket_auth_method": "gcp_service_account_role",
"gcp_service_account_role": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com"
}
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
}
}
},
"namespace": "data_export",
"warehouse": "s3://acme-data-export-staging/warehouse"
},
"catalog_glue": {
"storage_options": {
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
}
}
},
"database": "analytics"
},
"catalog_s3_tables": {
"storage_options": {
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": {
"aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name"
}
}
},
"database": "analytics",
"table_bucket_arn": "arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables"
},
"catalog_google_lakehouse": {
"project_id": "acme-analytics-1234",
"catalog_name": "data_export_catalog",
"schema": "data_export",
"bucket_name": "acme-data-export-staging",
"gcp_service_account_role": {
"service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com"
},
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 30
},
"mongodb": {
"host": "clusterID.mongodb.net",
"port": 27017,
"authentication_database": "admin",
"write_database": "data_export",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"motherduck": {
"database": "my_db",
"schema": "data_export",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"oracle": {
"ssl_options": {
"wallet": "<string>"
},
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1521,
"database": "ORCL",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"planetscale": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false,
"connection_timeout_in_seconds": 30
},
"sftp": {
"username": "data_export_user",
"host": "sftp.acme.com",
"port": 22,
"folder": "/uploads/data_export",
"auth_method": "public_key_auth",
"public_key_auth": {
"public_key": "<string>"
}
},
"singlestore": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false
},
"snowflake": {
"username": "DATA_EXPORT_USER",
"host": "db54321.us-central1.gcp.snowflakecomputing.com",
"port": 443,
"database": "ANALYTICS",
"schema": "data_export"
},
"sql_server": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1433,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": false,
"disable_ssl": false,
"primary_key_collation": "SQL_Latin1_General_CP1_CI_AS"
},
"s3": {
"disable_manifest": false,
"folder": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"use_ssh_tunnel": false
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
}
'import requests
url = "https://api.prequel.co/destinations/{destination_id}"
payload = { "destination": {
"name": "acme-corp-prod",
"frequency_minutes": 60,
"enabled_models": ["<string>"],
"max_concurrent_transfers": 10,
"max_concurrent_queries_per_transfer": 1,
"is_enabled": True,
"abs": {
"folder": "data_export",
"container_name": "data-export",
"storage_account_name": "acmestorage",
"auth_method": "azure_service_shared_access_signature",
"azure_service_shared_access_signature": { "shared_access_signature_token": "<string>" },
"disable_manifest": False
},
"athena": {
"workgroup": "primary",
"connection_database": "default",
"write_database": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1"
}
},
"aurora_mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"aurora_postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False,
"connection_timeout_in_seconds": 30
},
"clickhouse": {
"host": "abc123xyz.us-east-1.aws.clickhouse.cloud",
"port": 8443,
"cluster": "default",
"connection_database": "default",
"write_database": "default",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
}
},
"disable_ssl": False
},
"databricks": {
"host": "adb-1099123456789876.12.azuredatabricks.net",
"port": 443,
"schema": "data_export",
"catalog": "main",
"http_path": "/sql/1.0/endpoints/a98765ab4c3210a0",
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"hive": {
"bucket_vendor": "bucket_s3",
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
}
},
"use_ssh_tunnel": False
},
"delta_lake": {
"bucket_abs": {
"storage_account_name": "acmestorage",
"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": "data-export@acme-analytics-1234.iam.gserviceaccount.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": False,
"bucket_auth_method": "access_keys",
"access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
}
},
"retention_window_days": 30,
"column_mapping_mode": "none",
"deletion_vectors_disabled": False,
"change_data_feed_disabled": False
},
"gcs": {
"disable_manifest": False,
"folder": "data_export",
"gcp_service_account_role": { "service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com" },
"gcs_hmac_keys": {
"access_key": "GOOG1EXAMPLEACCESSID",
"secret": "<string>"
},
"bucket_name": "acme-data-export-staging"
},
"google_sheets": { "host": "https://docs.google.com/spreadsheets/d/1234567" },
"iceberg": {
"catalog_iceberg_rest": {
"oauth_bearer_token_auth": { "password": "<string>" },
"oauth_client_secret_auth": {
"client_id": "1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
"client_secret": "<string>"
},
"storage_options": {
"bucket_gcs": {
"bucket_name": "acme-data-export-staging",
"folder": "data_export",
"bucket_auth_method": "gcp_service_account_role",
"gcp_service_account_role": { "service_account_email": "service-account-name@project-id.iam.gserviceaccount.com" }
},
"bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" }
}
},
"namespace": "data_export",
"warehouse": "s3://acme-data-export-staging/warehouse"
},
"catalog_glue": {
"storage_options": { "bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" }
} },
"database": "analytics"
},
"catalog_s3_tables": {
"storage_options": { "bucket_s3": {
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"folder": "data_export",
"bucket_auth_method": "aws_iam_role",
"aws_iam_role": { "aws_iam_role_arn": "arn:aws:iam::123456789012:role/service-role/role-name" }
} },
"database": "analytics",
"table_bucket_arn": "arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables"
},
"catalog_google_lakehouse": {
"project_id": "acme-analytics-1234",
"catalog_name": "data_export_catalog",
"schema": "data_export",
"bucket_name": "acme-data-export-staging",
"gcp_service_account_role": { "service_account_email": "data-export@acme-analytics-1234.iam.gserviceaccount.com" },
"gcp_service_account_key": {
"service_account_email": "service-account-name@project-id.iam.gserviceaccount.com",
"service_account_key": "<unknown>"
}
},
"retention_window_days": 30
},
"mongodb": {
"host": "clusterID.mongodb.net",
"port": 27017,
"authentication_database": "admin",
"write_database": "data_export",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"motherduck": {
"database": "my_db",
"schema": "data_export",
"auth_method": "access_token_auth"
},
"mysql": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"oracle": {
"ssl_options": { "wallet": "<string>" },
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1521,
"database": "ORCL",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"planetscale": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"postgres": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 5432,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False,
"connection_timeout_in_seconds": 30
},
"sftp": {
"username": "data_export_user",
"host": "sftp.acme.com",
"port": 22,
"folder": "/uploads/data_export",
"auth_method": "public_key_auth",
"public_key_auth": { "public_key": "<string>" }
},
"singlestore": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 3306,
"connection_database": "mysql",
"write_database": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False
},
"snowflake": {
"username": "DATA_EXPORT_USER",
"host": "db54321.us-central1.gcp.snowflakecomputing.com",
"port": 443,
"database": "ANALYTICS",
"schema": "data_export"
},
"sql_server": {
"host": "example.ab02cdefgxyz.us-east-1.rds.amazonaws.com",
"port": 1433,
"database": "analytics",
"schema": "data_export",
"auth_method": "password_auth",
"password_auth": {
"username": "data_export_user",
"password": "<string>"
},
"use_ssh_tunnel": False,
"disable_ssl": False,
"primary_key_collation": "SQL_Latin1_General_CP1_CI_AS"
},
"s3": {
"disable_manifest": False,
"folder": "data_export",
"aws_access_keys": {
"access_id": "AKIAIOSFODNN7EXAMPLE",
"secret_key": "<string>"
},
"bucket_name": "acme-data-export-staging",
"bucket_region": "us-east-1",
"use_ssh_tunnel": False
},
"machine_type_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
} }
headers = {
"X-API-KEY": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {'X-API-KEY': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
destination: {
name: 'acme-corp-prod',
frequency_minutes: 60,
enabled_models: ['<string>'],
max_concurrent_transfers: 10,
max_concurrent_queries_per_transfer: 1,
is_enabled: true,
abs: {
folder: 'data_export',
container_name: 'data-export',
storage_account_name: 'acmestorage',
auth_method: 'azure_service_shared_access_signature',
azure_service_shared_access_signature: {shared_access_signature_token: '<string>'},
disable_manifest: false
},
athena: {
workgroup: 'primary',
connection_database: 'default',
write_database: 'data_export',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'},
bucket_s3: {bucket_name: 'acme-data-export-staging', bucket_region: 'us-east-1'}
},
aurora_mysql: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
aurora_postgres: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 5432,
database: 'analytics',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false,
connection_timeout_in_seconds: 30
},
clickhouse: {
host: 'abc123xyz.us-east-1.aws.clickhouse.cloud',
port: 8443,
cluster: 'default',
connection_database: 'default',
write_database: 'default',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'}
},
bucket_gcs: {
bucket_name: 'acme-data-export-staging',
gcs_hmac_keys: {access_key: 'GOOG1EXAMPLEACCESSID', secret: '<string>'}
},
disable_ssl: false
},
databricks: {
host: 'adb-1099123456789876.12.azuredatabricks.net',
port: 443,
schema: 'data_export',
catalog: 'main',
http_path: '/sql/1.0/endpoints/a98765ab4c3210a0',
oauth_client_secret_auth: {client_id: '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d', client_secret: '<string>'},
hive: {
bucket_vendor: 'bucket_s3',
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'}
}
},
use_ssh_tunnel: false
},
delta_lake: {
bucket_abs: {
storage_account_name: 'acmestorage',
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: 'data-export@acme-analytics-1234.iam.gserviceaccount.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: false,
bucket_auth_method: 'access_keys',
access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'}
},
retention_window_days: 30,
column_mapping_mode: 'none',
deletion_vectors_disabled: false,
change_data_feed_disabled: false
},
gcs: {
disable_manifest: false,
folder: 'data_export',
gcp_service_account_role: {
service_account_email: 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
},
gcs_hmac_keys: {access_key: 'GOOG1EXAMPLEACCESSID', secret: '<string>'},
bucket_name: 'acme-data-export-staging'
},
google_sheets: {host: 'https://docs.google.com/spreadsheets/d/1234567'},
iceberg: {
catalog_iceberg_rest: {
oauth_bearer_token_auth: {password: '<string>'},
oauth_client_secret_auth: {client_id: '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d', client_secret: '<string>'},
storage_options: {
bucket_gcs: {
bucket_name: 'acme-data-export-staging',
folder: 'data_export',
bucket_auth_method: 'gcp_service_account_role',
gcp_service_account_role: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com'
}
},
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
folder: 'data_export',
bucket_auth_method: 'aws_iam_role',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'}
}
},
namespace: 'data_export',
warehouse: 's3://acme-data-export-staging/warehouse'
},
catalog_glue: {
storage_options: {
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
folder: 'data_export',
bucket_auth_method: 'aws_iam_role',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'}
}
},
database: 'analytics'
},
catalog_s3_tables: {
storage_options: {
bucket_s3: {
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
folder: 'data_export',
bucket_auth_method: 'aws_iam_role',
aws_iam_role: {aws_iam_role_arn: 'arn:aws:iam::123456789012:role/service-role/role-name'}
}
},
database: 'analytics',
table_bucket_arn: 'arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables'
},
catalog_google_lakehouse: {
project_id: 'acme-analytics-1234',
catalog_name: 'data_export_catalog',
schema: 'data_export',
bucket_name: 'acme-data-export-staging',
gcp_service_account_role: {
service_account_email: 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
},
gcp_service_account_key: {
service_account_email: 'service-account-name@project-id.iam.gserviceaccount.com',
service_account_key: '<unknown>'
}
},
retention_window_days: 30
},
mongodb: {
host: 'clusterID.mongodb.net',
port: 27017,
authentication_database: 'admin',
write_database: 'data_export',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
motherduck: {database: 'my_db', schema: 'data_export', auth_method: 'access_token_auth'},
mysql: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
oracle: {
ssl_options: {wallet: '<string>'},
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 1521,
database: 'ORCL',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
planetscale: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
postgres: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 5432,
database: 'analytics',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false,
connection_timeout_in_seconds: 30
},
sftp: {
username: 'data_export_user',
host: 'sftp.acme.com',
port: 22,
folder: '/uploads/data_export',
auth_method: 'public_key_auth',
public_key_auth: {public_key: '<string>'}
},
singlestore: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 3306,
connection_database: 'mysql',
write_database: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false
},
snowflake: {
username: 'DATA_EXPORT_USER',
host: 'db54321.us-central1.gcp.snowflakecomputing.com',
port: 443,
database: 'ANALYTICS',
schema: 'data_export'
},
sql_server: {
host: 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
port: 1433,
database: 'analytics',
schema: 'data_export',
auth_method: 'password_auth',
password_auth: {username: 'data_export_user', password: '<string>'},
use_ssh_tunnel: false,
disable_ssl: false,
primary_key_collation: 'SQL_Latin1_General_CP1_CI_AS'
},
s3: {
disable_manifest: false,
folder: 'data_export',
aws_access_keys: {access_id: 'AKIAIOSFODNN7EXAMPLE', secret_key: '<string>'},
bucket_name: 'acme-data-export-staging',
bucket_region: 'us-east-1',
use_ssh_tunnel: false
},
machine_type_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a'
}
})
};
fetch('https://api.prequel.co/destinations/{destination_id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.prequel.co/destinations/{destination_id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'destination' => [
'name' => 'acme-corp-prod',
'frequency_minutes' => 60,
'enabled_models' => [
'<string>'
],
'max_concurrent_transfers' => 10,
'max_concurrent_queries_per_transfer' => 1,
'is_enabled' => true,
'abs' => [
'folder' => 'data_export',
'container_name' => 'data-export',
'storage_account_name' => 'acmestorage',
'auth_method' => 'azure_service_shared_access_signature',
'azure_service_shared_access_signature' => [
'shared_access_signature_token' => '<string>'
],
'disable_manifest' => false
],
'athena' => [
'workgroup' => 'primary',
'connection_database' => 'default',
'write_database' => 'data_export',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
],
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1'
]
],
'aurora_mysql' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'aurora_postgres' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 5432,
'database' => 'analytics',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false,
'connection_timeout_in_seconds' => 30
],
'clickhouse' => [
'host' => 'abc123xyz.us-east-1.aws.clickhouse.cloud',
'port' => 8443,
'cluster' => 'default',
'connection_database' => 'default',
'write_database' => 'default',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
]
],
'bucket_gcs' => [
'bucket_name' => 'acme-data-export-staging',
'gcs_hmac_keys' => [
'access_key' => 'GOOG1EXAMPLEACCESSID',
'secret' => '<string>'
]
],
'disable_ssl' => false
],
'databricks' => [
'host' => 'adb-1099123456789876.12.azuredatabricks.net',
'port' => 443,
'schema' => 'data_export',
'catalog' => 'main',
'http_path' => '/sql/1.0/endpoints/a98765ab4c3210a0',
'oauth_client_secret_auth' => [
'client_id' => '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d',
'client_secret' => '<string>'
],
'hive' => [
'bucket_vendor' => 'bucket_s3',
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
]
]
],
'use_ssh_tunnel' => false
],
'delta_lake' => [
'bucket_abs' => [
'storage_account_name' => 'acmestorage',
'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' => 'data-export@acme-analytics-1234.iam.gserviceaccount.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' => false,
'bucket_auth_method' => 'access_keys',
'access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
]
],
'retention_window_days' => 30,
'column_mapping_mode' => 'none',
'deletion_vectors_disabled' => false,
'change_data_feed_disabled' => false
],
'gcs' => [
'disable_manifest' => false,
'folder' => 'data_export',
'gcp_service_account_role' => [
'service_account_email' => 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
],
'gcs_hmac_keys' => [
'access_key' => 'GOOG1EXAMPLEACCESSID',
'secret' => '<string>'
],
'bucket_name' => 'acme-data-export-staging'
],
'google_sheets' => [
'host' => 'https://docs.google.com/spreadsheets/d/1234567'
],
'iceberg' => [
'catalog_iceberg_rest' => [
'oauth_bearer_token_auth' => [
'password' => '<string>'
],
'oauth_client_secret_auth' => [
'client_id' => '1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d',
'client_secret' => '<string>'
],
'storage_options' => [
'bucket_gcs' => [
'bucket_name' => 'acme-data-export-staging',
'folder' => 'data_export',
'bucket_auth_method' => 'gcp_service_account_role',
'gcp_service_account_role' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com'
]
],
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'folder' => 'data_export',
'bucket_auth_method' => 'aws_iam_role',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
]
]
],
'namespace' => 'data_export',
'warehouse' => 's3://acme-data-export-staging/warehouse'
],
'catalog_glue' => [
'storage_options' => [
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'folder' => 'data_export',
'bucket_auth_method' => 'aws_iam_role',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
]
]
],
'database' => 'analytics'
],
'catalog_s3_tables' => [
'storage_options' => [
'bucket_s3' => [
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'folder' => 'data_export',
'bucket_auth_method' => 'aws_iam_role',
'aws_iam_role' => [
'aws_iam_role_arn' => 'arn:aws:iam::123456789012:role/service-role/role-name'
]
]
],
'database' => 'analytics',
'table_bucket_arn' => 'arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables'
],
'catalog_google_lakehouse' => [
'project_id' => 'acme-analytics-1234',
'catalog_name' => 'data_export_catalog',
'schema' => 'data_export',
'bucket_name' => 'acme-data-export-staging',
'gcp_service_account_role' => [
'service_account_email' => 'data-export@acme-analytics-1234.iam.gserviceaccount.com'
],
'gcp_service_account_key' => [
'service_account_email' => 'service-account-name@project-id.iam.gserviceaccount.com',
'service_account_key' => '<unknown>'
]
],
'retention_window_days' => 30
],
'mongodb' => [
'host' => 'clusterID.mongodb.net',
'port' => 27017,
'authentication_database' => 'admin',
'write_database' => 'data_export',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'motherduck' => [
'database' => 'my_db',
'schema' => 'data_export',
'auth_method' => 'access_token_auth'
],
'mysql' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'oracle' => [
'ssl_options' => [
'wallet' => '<string>'
],
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 1521,
'database' => 'ORCL',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'planetscale' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'postgres' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 5432,
'database' => 'analytics',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false,
'connection_timeout_in_seconds' => 30
],
'sftp' => [
'username' => 'data_export_user',
'host' => 'sftp.acme.com',
'port' => 22,
'folder' => '/uploads/data_export',
'auth_method' => 'public_key_auth',
'public_key_auth' => [
'public_key' => '<string>'
]
],
'singlestore' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 3306,
'connection_database' => 'mysql',
'write_database' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false
],
'snowflake' => [
'username' => 'DATA_EXPORT_USER',
'host' => 'db54321.us-central1.gcp.snowflakecomputing.com',
'port' => 443,
'database' => 'ANALYTICS',
'schema' => 'data_export'
],
'sql_server' => [
'host' => 'example.ab02cdefgxyz.us-east-1.rds.amazonaws.com',
'port' => 1433,
'database' => 'analytics',
'schema' => 'data_export',
'auth_method' => 'password_auth',
'password_auth' => [
'username' => 'data_export_user',
'password' => '<string>'
],
'use_ssh_tunnel' => false,
'disable_ssl' => false,
'primary_key_collation' => 'SQL_Latin1_General_CP1_CI_AS'
],
's3' => [
'disable_manifest' => false,
'folder' => 'data_export',
'aws_access_keys' => [
'access_id' => 'AKIAIOSFODNN7EXAMPLE',
'secret_key' => '<string>'
],
'bucket_name' => 'acme-data-export-staging',
'bucket_region' => 'us-east-1',
'use_ssh_tunnel' => false
],
'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}"
payload := strings.NewReader("{\n \"destination\": {\n \"name\": \"acme-corp-prod\",\n \"frequency_minutes\": 60,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 10,\n \"max_concurrent_queries_per_transfer\": 1,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"data_export\",\n \"container_name\": \"data-export\",\n \"storage_account_name\": \"acmestorage\",\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\": \"primary\",\n \"connection_database\": \"default\",\n \"write_database\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"aurora_postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"clickhouse\": {\n \"host\": \"abc123xyz.us-east-1.aws.clickhouse.cloud\",\n \"port\": 8443,\n \"cluster\": \"default\",\n \"connection_database\": \"default\",\n \"write_database\": \"default\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": false\n },\n \"databricks\": {\n \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n \"port\": 443,\n \"schema\": \"data_export\",\n \"catalog\": \"main\",\n \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": false\n },\n \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"acmestorage\",\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\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": false,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 30,\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\": \"data_export\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\"\n },\n \"google_sheets\": {\n \"host\": \"https://docs.google.com/spreadsheets/d/1234567\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"gcp_service_account_role\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n }\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"namespace\": \"data_export\",\n \"warehouse\": \"s3://acme-data-export-staging/warehouse\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\",\n \"table_bucket_arn\": \"arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"acme-analytics-1234\",\n \"catalog_name\": \"data_export_catalog\",\n \"schema\": \"data_export\",\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": 30\n },\n \"mongodb\": {\n \"host\": \"clusterID.mongodb.net\",\n \"port\": 27017,\n \"authentication_database\": \"admin\",\n \"write_database\": \"data_export\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"motherduck\": {\n \"database\": \"my_db\",\n \"schema\": \"data_export\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1521,\n \"database\": \"ORCL\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"planetscale\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"sftp\": {\n \"username\": \"data_export_user\",\n \"host\": \"sftp.acme.com\",\n \"port\": 22,\n \"folder\": \"/uploads/data_export\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"snowflake\": {\n \"username\": \"DATA_EXPORT_USER\",\n \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n \"port\": 443,\n \"database\": \"ANALYTICS\",\n \"schema\": \"data_export\"\n },\n \"sql_server\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1433,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"primary_key_collation\": \"SQL_Latin1_General_CP1_CI_AS\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"use_ssh_tunnel\": false\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("X-API-KEY", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://api.prequel.co/destinations/{destination_id}")
.header("X-API-KEY", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"destination\": {\n \"name\": \"acme-corp-prod\",\n \"frequency_minutes\": 60,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 10,\n \"max_concurrent_queries_per_transfer\": 1,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"data_export\",\n \"container_name\": \"data-export\",\n \"storage_account_name\": \"acmestorage\",\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\": \"primary\",\n \"connection_database\": \"default\",\n \"write_database\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"aurora_postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"clickhouse\": {\n \"host\": \"abc123xyz.us-east-1.aws.clickhouse.cloud\",\n \"port\": 8443,\n \"cluster\": \"default\",\n \"connection_database\": \"default\",\n \"write_database\": \"default\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": false\n },\n \"databricks\": {\n \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n \"port\": 443,\n \"schema\": \"data_export\",\n \"catalog\": \"main\",\n \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": false\n },\n \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"acmestorage\",\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\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": false,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 30,\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\": \"data_export\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\"\n },\n \"google_sheets\": {\n \"host\": \"https://docs.google.com/spreadsheets/d/1234567\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"gcp_service_account_role\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n }\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"namespace\": \"data_export\",\n \"warehouse\": \"s3://acme-data-export-staging/warehouse\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\",\n \"table_bucket_arn\": \"arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"acme-analytics-1234\",\n \"catalog_name\": \"data_export_catalog\",\n \"schema\": \"data_export\",\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": 30\n },\n \"mongodb\": {\n \"host\": \"clusterID.mongodb.net\",\n \"port\": 27017,\n \"authentication_database\": \"admin\",\n \"write_database\": \"data_export\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"motherduck\": {\n \"database\": \"my_db\",\n \"schema\": \"data_export\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1521,\n \"database\": \"ORCL\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"planetscale\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"sftp\": {\n \"username\": \"data_export_user\",\n \"host\": \"sftp.acme.com\",\n \"port\": 22,\n \"folder\": \"/uploads/data_export\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"snowflake\": {\n \"username\": \"DATA_EXPORT_USER\",\n \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n \"port\": 443,\n \"database\": \"ANALYTICS\",\n \"schema\": \"data_export\"\n },\n \"sql_server\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1433,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"primary_key_collation\": \"SQL_Latin1_General_CP1_CI_AS\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"use_ssh_tunnel\": false\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}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["X-API-KEY"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"destination\": {\n \"name\": \"acme-corp-prod\",\n \"frequency_minutes\": 60,\n \"enabled_models\": [\n \"<string>\"\n ],\n \"max_concurrent_transfers\": 10,\n \"max_concurrent_queries_per_transfer\": 1,\n \"is_enabled\": true,\n \"abs\": {\n \"folder\": \"data_export\",\n \"container_name\": \"data-export\",\n \"storage_account_name\": \"acmestorage\",\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\": \"primary\",\n \"connection_database\": \"default\",\n \"write_database\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\"\n }\n },\n \"aurora_mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"aurora_postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"clickhouse\": {\n \"host\": \"abc123xyz.us-east-1.aws.clickhouse.cloud\",\n \"port\": 8443,\n \"cluster\": \"default\",\n \"connection_database\": \"default\",\n \"write_database\": \"default\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n }\n },\n \"disable_ssl\": false\n },\n \"databricks\": {\n \"host\": \"adb-1099123456789876.12.azuredatabricks.net\",\n \"port\": 443,\n \"schema\": \"data_export\",\n \"catalog\": \"main\",\n \"http_path\": \"/sql/1.0/endpoints/a98765ab4c3210a0\",\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"hive\": {\n \"bucket_vendor\": \"bucket_s3\",\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n }\n },\n \"use_ssh_tunnel\": false\n },\n \"delta_lake\": {\n \"bucket_abs\": {\n \"storage_account_name\": \"acmestorage\",\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\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": false,\n \"bucket_auth_method\": \"access_keys\",\n \"access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n }\n },\n \"retention_window_days\": 30,\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\": \"data_export\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.com\"\n },\n \"gcs_hmac_keys\": {\n \"access_key\": \"GOOG1EXAMPLEACCESSID\",\n \"secret\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\"\n },\n \"google_sheets\": {\n \"host\": \"https://docs.google.com/spreadsheets/d/1234567\"\n },\n \"iceberg\": {\n \"catalog_iceberg_rest\": {\n \"oauth_bearer_token_auth\": {\n \"password\": \"<string>\"\n },\n \"oauth_client_secret_auth\": {\n \"client_id\": \"1a2b3c4d-5e6f-7a8b-9c0d-1e2f3a4b5c6d\",\n \"client_secret\": \"<string>\"\n },\n \"storage_options\": {\n \"bucket_gcs\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"gcp_service_account_role\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"service-account-name@project-id.iam.gserviceaccount.com\"\n }\n },\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"namespace\": \"data_export\",\n \"warehouse\": \"s3://acme-data-export-staging/warehouse\"\n },\n \"catalog_glue\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\"\n },\n \"catalog_s3_tables\": {\n \"storage_options\": {\n \"bucket_s3\": {\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"folder\": \"data_export\",\n \"bucket_auth_method\": \"aws_iam_role\",\n \"aws_iam_role\": {\n \"aws_iam_role_arn\": \"arn:aws:iam::123456789012:role/service-role/role-name\"\n }\n }\n },\n \"database\": \"analytics\",\n \"table_bucket_arn\": \"arn:aws:s3tables:us-east-1:123456789012:bucket/acme-tables\"\n },\n \"catalog_google_lakehouse\": {\n \"project_id\": \"acme-analytics-1234\",\n \"catalog_name\": \"data_export_catalog\",\n \"schema\": \"data_export\",\n \"bucket_name\": \"acme-data-export-staging\",\n \"gcp_service_account_role\": {\n \"service_account_email\": \"data-export@acme-analytics-1234.iam.gserviceaccount.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\": 30\n },\n \"mongodb\": {\n \"host\": \"clusterID.mongodb.net\",\n \"port\": 27017,\n \"authentication_database\": \"admin\",\n \"write_database\": \"data_export\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"motherduck\": {\n \"database\": \"my_db\",\n \"schema\": \"data_export\",\n \"auth_method\": \"access_token_auth\"\n },\n \"mysql\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"oracle\": {\n \"ssl_options\": {\n \"wallet\": \"<string>\"\n },\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1521,\n \"database\": \"ORCL\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"planetscale\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"postgres\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 5432,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"connection_timeout_in_seconds\": 30\n },\n \"sftp\": {\n \"username\": \"data_export_user\",\n \"host\": \"sftp.acme.com\",\n \"port\": 22,\n \"folder\": \"/uploads/data_export\",\n \"auth_method\": \"public_key_auth\",\n \"public_key_auth\": {\n \"public_key\": \"<string>\"\n }\n },\n \"singlestore\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 3306,\n \"connection_database\": \"mysql\",\n \"write_database\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false\n },\n \"snowflake\": {\n \"username\": \"DATA_EXPORT_USER\",\n \"host\": \"db54321.us-central1.gcp.snowflakecomputing.com\",\n \"port\": 443,\n \"database\": \"ANALYTICS\",\n \"schema\": \"data_export\"\n },\n \"sql_server\": {\n \"host\": \"example.ab02cdefgxyz.us-east-1.rds.amazonaws.com\",\n \"port\": 1433,\n \"database\": \"analytics\",\n \"schema\": \"data_export\",\n \"auth_method\": \"password_auth\",\n \"password_auth\": {\n \"username\": \"data_export_user\",\n \"password\": \"<string>\"\n },\n \"use_ssh_tunnel\": false,\n \"disable_ssl\": false,\n \"primary_key_collation\": \"SQL_Latin1_General_CP1_CI_AS\"\n },\n \"s3\": {\n \"disable_manifest\": false,\n \"folder\": \"data_export\",\n \"aws_access_keys\": {\n \"access_id\": \"AKIAIOSFODNN7EXAMPLE\",\n \"secret_key\": \"<string>\"\n },\n \"bucket_name\": \"acme-data-export-staging\",\n \"bucket_region\": \"us-east-1\",\n \"use_ssh_tunnel\": false\n },\n \"machine_type_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n }\n}"
response = http.request(request)
puts response.read_body{
"status": "success",
"data": {
"destination": {
"id": "<string>",
"vendor": "snowflake",
"name": "acme-corp-prod",
"recipient_id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"created_at": "2023-11-07T05:31:56Z",
"updated_at": "2023-11-07T05:31:56Z",
"last_successful_transfer_ended_at": "2023-11-07T05:31:56Z",
"abs": {
"folder": "data_export",
"container_name": "data-export",
"auth_method": "azure_service_shared_access_signature",
"storage_account_name": "acmestorage",
"disable_manifest": true,
"file_format": "parquet",
"csv": {
"delimiter": ","
}
},
"frequency_minutes": 60,
"id_in_provider_system": "cus_1a2b3c4d",
"products": [
"<string>"
],
"enabled_models": [
"<string>"
],
"max_concurrent_transfers": 10,
"max_concurrent_queries_per_transfer": 1,
"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": "2026-01-01T00:00:00Z",
"end_transfer_window_at": "2026-01-02T00:00:00Z",
"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": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"model_metrics": [
{
"model_id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"rows_transferred": 123,
"delta_rows_transferred": 123,
"volume_transferred_in_mb": 123,
"start_transfer_window_at": "2026-01-01T00:00:00Z",
"end_transfer_window_at": "2026-01-02T00:00:00Z",
"most_recent_last_updated_at": "2026-01-01T00:00:00Z",
"error": {
"error_code": "<string>",
"title": "<string>",
"blame": "<string>",
"documentation_url": "<string>",
"trace": "<string>",
"message": "<string>"
},
"model_name": "orders"
}
],
"models_snapshot": [
{
"model_id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"model_name": "orders",
"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": "error",
"message": "<string>",
"data": null
}{
"status": "error",
"message": "<string>",
"data": null
}{
"status": "error",
"message": "<string>",
"data": null
}{
"status": "error",
"message": "<string>",
"data": null
}