Destination connections
Configure and manage connections to destinations for data loading.
Destination connections define how and where data should be loaded within a destination system. They include:
- Authentication credentials for the destination
- Target configuration (database, schema, table naming patterns)
- Load behavior settings (append, replace, upsert)
- Path and formatting rules
Destination connections are created and modified through the iframe UI to securely handle credentials.
List destination connections
Create a connection
Create a destination connection of a given type.
The set of connection_params fields depends on the destination. For s3:
connection_option— authentication method:aws_credentials(default),bucket_policy, orrole_chainingaws_access_key_id,aws_secret_access_key— AWS credentials; required only foraws_credentials(secret fields)assume_role_arn— customer IAM role ARN; required only forrole_chainingimprovado_assume_role_arn,improvado_assume_role_externalid— managed by Improvado and returned read-only; use them to build the trust policy on the customer side forrole_chainingaws_default_region— AWS region code, e.g.eu-west-1bucket_name,folder,filename— target location;filenamesupports templates like{{ filename }}-{{ YYYY }}-{{ MM }}-{{ DD }}file_format(parquet|csv|csv_gzip|csv_gz|json|json_gzip|json_gz|avro),separator,partition_by(by_day|by_month)max_file_size_mb— optional chunking limit (45–100000); requires{{chunk_id}}infilenameandfile_format: parquetencryption(no_storage_encryption|sse_s3|sse_kms|sse_kms_with_customer_managed_key),encryption_key— required secret field: the KMS key id when usingsse_kms_with_customer_managed_key, the literal placeholderstubfor every other encryption optionuse_load_by_accounts— split delivered files by account
path Parameters
destination_nameDestination name
Create a connection › Request Body
titleConnection title
create_load_for_new_tablesCreate load for new tables
destination_nameDestination name
connection_paramsConnection params
Create a connection › Responses
Create a Connection
Get a connection
Get detailed info about destination connection
path Parameters
destination_nameDestination name
idDestination Connection ID
Get a connection › Responses
Get a Connection
idConnection ID
uidConnection UID
titleConnection title
datasource_nameData source name
statusConnection status
created_atConnection creation date
updated_atConnection update date
accounts_numberTotal number of accounts available on this connection (excluding accounts disabled on the data source side).
enabled_for_extraction_accounts_numberNumber of accounts on this connection that are selected for extraction. Use this to detect connections that have no accounts enabled and prompt the user to select at least one before setting up extractions or loads.
accounts_statusAccounts status
update_accounts_last_successedLast successful accounts update date
update_accounts_was_successfullWas the last accounts update successful
Update connection parameters
Update the title and/or connection parameters of an existing destination connection.
connection_params is merged at field level: only the fields present in the payload are
updated, omitted fields keep their current values. To change a single setting, send just
that field — e.g. {"connection_params": {"partition_by": "by_month"}}.
Notes:
- Unknown field names are rejected with
400. - Secret fields cannot be updated one at a time — if any secret field is present in the
payload, all required secret fields must be sent together. For
s3that meansaws_access_key_id,aws_secret_access_keyandencryption_keyalways travel as a trio (keepencryption_key: "stub"unless you use a customer-managed KMS key). Omit secret fields entirely to keep the stored values. improvado_assume_role_arnandimprovado_assume_role_externalidare managed by Improvado and cannot be changed through this endpoint.- A successful update resets the connection status and triggers a connection re-check.
See the create endpoint for the full list of connection_params fields per destination.
path Parameters
destination_nameDestination name
idDestination Connection ID
Update connection parameters › Request Body
titleConnection title
connection_paramsConnection params to change. Merged at field level with the stored parameters — omitted fields keep their current values.
Update connection parameters › Responses
Update a Connection
Update a connection
Allows to update create_load_for_new_tables value for destination connection
path Parameters
destination_nameDestination name
idDestination Connection ID
Update a connection › Responses
Update a Connection
idDestination Connection ID
Destination object
titleDestination Connection title
updated_atDestination Connection update date
statusDestination Connection status
error_textDestination Connection error text
is_editableIs the Destination Connection editable
create_load_for_new_tablesCreate load for new tables
Check connection status
Starts a manual status check of a destination connection. If a destination connection has invalid or staled connection credentials – the system will mark this destination connection as invalid for future loads.
path Parameters
destination_nameDestination name
destination_connection_idDestination Connection ID
Check connection status › Responses
Recheck a Connection

