Modify Transformation Project
Modifies transformation project if a valid identifier was provided
Request schema
Path parameters
The unique identifier for the transformation project within the Fivetran system
Header parameters
HTTP: basicAuth
HTTP AuthorizationScheme: basic
Request
The boolean flag specifies if the project should be tested after creation or update operation
dbt Core project configuration object
The path to the folder in the Git repo where your dbt project is stored.
The Git branch of your dbt project.
The number of threads dbt will use
The default target name
The list of environment variables defined as key-value pairs in the raw string format using = as a separator. The variable names should have the DBT_ prefix and can contain A-Z, 0-9, dash, underscore, or dot characters. Example: "DBT_VARIABLE=variable_value"
PATCH /v1/transformation-projects/null HTTP/1.1
Accept: application/json
Authorization: Basic REPLACE_BASIC_AUTH
Content-Type: application/json
Host: api.fivetran.com
Content-Length: 187
{
"run_tests": true,
"project_config": {
"folder_path": "string",
"git_branch": "string",
"threads": 0,
"target_name": "string",
"environment_vars": "string"
}
}Responses
Successful response schema
Response status code
Response status text
The unique identifier for the transformation project within the Fivetran system
Transformation project type
The status of transformation project
The list of errors occurred during project processing and setup
The timestamp when the transformation project was created
The unique identifier for the group within the Fivetran system
The setup tests results
The setup test title
The status of the test
The setup test message
The setup test details
The unique identifier for the actor (user or system key) within the Fivetran system
dbt Core project configuration object
The version of dbt that should run the project
The default schema in the destination
The Git remote URL of your dbt project
The path to the folder in the Git repo where your dbt project is stored.
The Git branch of your dbt project.
The number of threads dbt will use
The default target name
The list of environment variables defined as key-value pairs in the raw string format using = as a separator. The variable names should have the DBT_ prefix and can contain A-Z, 0-9, dash, underscore, or dot characters. Example: "DBT_VARIABLE=variable_value"
The public key used to grant Fivetran SSH access to the dbt project Git repository
{
"code": "Success",
"message": "Operation performed.",
"data": {
"id": "string",
"type": "DBT_GIT",
"status": "NOT_READY",
"errors": [
"string"
],
"created_at": "2019-08-24T14:15:22Z",
"group_id": "string",
"setup_tests": [
{
"title": "Test Title",
"status": "FAILED",
"message": "Error message",
"details": "Error details"
}
],
"created_by_id": "string",
"project_config": {
"dbt_version": "string",
"default_schema": "string",
"git_remote_url": "string",
"folder_path": "string",
"git_branch": "string",
"threads": 0,
"target_name": "string",
"environment_vars": "string",
"public_key": "string"
}
}
}