List All dbt Transformations
Returns a list of all dbt Transformations within dbt Project.
Request schema
Query parameters
The unique identifier for the dbt Project within the Fivetran system.
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.
Header parameters
HTTP: basicAuth
HTTP AuthorizationScheme: basic
GET /v1/dbt/transformations?project_id=dbt_project_id&cursor=ghyYGuYg8gg8G&limit=100 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 return items
The unique identifier for the dbt Model within the Fivetran system.
The status of dbt Transformation.
Interval.
Schedule type
Days of week
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'
The field indicates whether transformation is in paused state.
The timestamp of last dbt Transformation run.
The field indicates whether the tests have been configured for dbt Transformation.
The dbt Model name.
The unique identifier for the dbt Project within the Fivetran system.
The unique identifier for the dbt Model within the Fivetran system.
The timestamp of next dbt Transformation run.
The value of the cursor parameter for the next page
{
"code": "Success",
"message": "Operation performed.",
"data": {
"items": [
{
"id": "transformation_id",
"status": "RUNNING",
"schedule": {
"interval": 60,
"schedule_type": "TIME_OF_DAY",
"days_of_week": [
"MONDAY",
"FRIDAY"
],
"time_of_day": "14:00"
},
"paused": true,
"last_run": "2019-08-24T14:15:22Z",
"run_tests": true,
"output_model_name": "string",
"dbt_project_id": "string",
"dbt_model_id": "string",
"next_run": "2019-08-24T14:15:22Z"
}
],
"nextCursor": "cursor_value"
}
}