Update Transformation
Updates the transformation if a valid identifier is provided
Request schema
Path parameters
The unique identifier for the transformation within the Fivetran system
Header parameters
HTTP: basicAuth
HTTP AuthorizationScheme: basic
Request
Cron schedule: list of CRON strings.
The interval in minutes
The boolean flag that enables the Smart Syncing schedule
The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
The schedule type
The set of days of the week, where an empty set represents a daily schedule
The time of the day the transformation should be launched at. The following values are supported: '00:00', '00:30', '01:00', '01:30', '02:00', '02:30', '03:00', '03:30', '04:00', '04:30', '05:00', '05:30', '06:00', '06:30', '07:00', '07:30', '08:00', '08:30', '09:00', '09:30', '10:00', '10:30', '11:00', '11:30', '12:00', '12:30', '13:00', '13:30', '14:00', '14:30', '15:00', '15:30', '16:00', '16:30', '17:00', '17:30', '18:00', '18:30', '19:00', '19:30', '20:00', '20:30', '21:00', '21:30', '22:00', '22:30', '23:00', '23:30'
dbt Core transformation configuration object
The unique identifier for the dbt Core project within the Fivetran system
The transformation name
The list of transformation steps
The step name
The dbt command in the transformation step
PATCH /v1/transformations/transformation_id HTTP/1.1
Accept: application/json
Authorization: Basic REPLACE_BASIC_AUTH
Content-Type: application/json
Host: api.fivetran.com
Content-Length: 480
{
"schedule": {
"cron": [
"0 */1 * * *"
],
"interval": 60,
"smart_syncing": true,
"connection_ids": [
"connection_id"
],
"schedule_type": "TIME_OF_DAY",
"days_of_week": [
"MONDAY",
"FRIDAY"
],
"time_of_day": "14:00"
},
"paused": true,
"transformation_config": {
"project_id": "string",
"name": "string",
"steps": [
{
"name": "string",
"command": "string"
}
]
}
}Responses
Successful response schema
Response status code
Response status text
The unique identifier for the transformation within the Fivetran system
The status of transformation
Cron schedule: list of CRON strings.
The interval in minutes
The boolean flag that enables the Smart Syncing schedule
The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
The schedule type
The set of days of the week, where an empty set represents a daily schedule
The time of the day the transformation should be launched at. The following values are supported: '00:00', '00:30', '01:00', '01:30', '02:00', '02:30', '03:00', '03:30', '04:00', '04:30', '05:00', '05:30', '06:00', '06:30', '07:00', '07:30', '08:00', '08:30', '09:00', '09:30', '10:00', '10:30', '11:00', '11:30', '12:00', '12:30', '13:00', '13:30', '14:00', '14:30', '15:00', '15:30', '16:00', '16:30', '17:00', '17:30', '18:00', '18:30', '19:00', '19:30', '20:00', '20:30', '21:00', '21:30', '22:00', '22:30', '23:00', '23:30'
Transformation type
The field indicates whether transformation is in paused state
The timestamp when the transformation was created
The list of transformation output models
The unique identifier for the actor (user or system key) within the Fivetran system
dbt Core transformation configuration object
The unique identifier for the dbt Core project within the Fivetran system
The transformation name
The list of transformation steps
The step name
The dbt command in the transformation step
{
"code": "Success",
"message": "Operation performed.",
"data": {
"id": "transformation_id",
"status": "RUNNING",
"schedule": {
"cron": [
"0 */1 * * *"
],
"interval": 60,
"smart_syncing": true,
"connection_ids": [
"connection_id"
],
"schedule_type": "TIME_OF_DAY",
"days_of_week": [
"MONDAY",
"FRIDAY"
],
"time_of_day": "14:00"
},
"type": "DBT_CORE",
"paused": true,
"created_at": "2024-01-02T00:00:00.743708Z",
"output_model_names": [
"string"
],
"created_by_id": "user_id",
"transformation_config": {
"project_id": "string",
"name": "string",
"steps": [
{
"name": "string",
"command": "string"
}
]
}
}
}