List all Transformations within Account
Returns a list of all transformations within your Fivetran account.
Request schema
Query parameters
Paging cursor, read more about pagination
Number of records to fetch per page. Accepts a number in the range 1..1000; the default value is 100
Specify the group identifier to filter transformations by group
Specify dbt Core project identifier to filter transformations by project
Transformation type filter
Header parameters
HTTP: basicAuth
HTTP AuthorizationScheme: basic
GET /v1/transformations?cursor=cursor_value&limit=100&group_id=group_id&project_id=project_id&type=DBT_CORE HTTP/1.1
Accept: application/json
Authorization: Basic REPLACE_BASIC_AUTH
Host: api.fivetran.com
Responses
Successful response schema
Response status code
Response status text
The collection of returned items
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
The value of the cursor parameter for the next page
{
"code": "Success",
"message": "Operation performed.",
"data": {
"items": [
{
"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"
}
]
}
}
],
"nextCursor": "cursor_value"
}
}