How to Clone a Fivetran Connection
Use the following steps to clone a Fivetran connection.
Retrieve connection details
Retrieve the connection's object details using the Retrieve Connection Details endpoint.
Request
GET https://api.fivetran.com/v1/connections/{connection_id}
Path parameters
Name | Description |
---|---|
connection_id (required) | The unique identifier for the connection within the Fivetran system. |
Response
HTTP 200 OK
Record field and their values from response
Make a note of the following fields from the API response:
{
"group_id": "projected_sickle",
"service": "criteo",
"config": {
"username": "myuser",
"password": "******",
"api_token": "******",
"service_version": "0"
}
}
Create new connection
Create the new connection using the fields from the previous step using the Create a connection endpoint.
Request
POST https://api.fivetran.com/v1/connections
{
"service": "criteo",
"group_id": "projected_sickle",
"trust_certificates": true,
"run_setup_tests": true,
"config": {
"schema": "criteo",
"username": "myuser",
"password": "mypassword",
"app_token": "myapptoken"
}
}
Payload parameters
Name | Description |
---|---|
group_id (required) | The unique identifier for the group within the Fivetran system. Find you group_id by fetching your account's group list. |
service (required) | The name for the connector type within the Fivetran system. |
config (required) | The connection setup configuration. The format is specific to each connector. |
trust_certificates | Specifies whether we should trust the certificate automatically. Applicable only for database connectors. The default value is FALSE . If a certificate is not trusted automatically, it has to be approved using the Certificates Management API. |
run_setup_tests | Specifies whether setup tests should be run automatically. The default value is TRUE . |
Response
HTTP 201 Created