Update a SQL trait definition
curl --request PATCH \
--url https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}import requests
url = "https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}"
response = requests.patch(url)
print(response.text)const options = {method: 'PATCH'};
fetch('https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}"
req, _ := http.NewRequest("PATCH", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
response = http.request(request)
puts response.read_body{
"data": {
"id": "sqltrait_9f2c1d4a7b3e9f2c1d4a7b3e9f2c1d4a7b3e",
"name": "high_value_segment",
"description": "LTV over the 90-day window",
"warehouse": "bigquery",
"sql": "select user_id, sum(o.gmv) as trait_value from orders o group by 1",
"connection_configured": true,
"schedule_minutes": 1440,
"enabled": false,
"created_by": "user_2hGfK9dTsbJ1Q7c",
"created_at": "2026-08-01T09:00:00.000Z",
"updated_at": "2026-08-07T12:00:00.000Z",
"last_run_at": "2026-08-07T00:13:00.000Z",
"last_run_status": "ok",
"last_run_rows": 412,
"last_error": null,
"last_error_at": null
},
"meta": {
"request_id": "req_01J8Z9K3P4Q5R6S7T8U9V0W1X2",
"timestamp": "2026-08-07T12:00:00.000Z"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "RATE_LIMITED",
"message": "<string>",
"status": 429,
"retry_after": 2
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}CDP
Update a SQL trait definition
Partially updates one SQL trait definition: name, description, warehouse, sql, connection, schedule_minutes, and enabled are each optional — the scheduler-owned run-status fields (last_run_*, last_error*) are never writable through this endpoint. 400 when a supplied connection fails the JSON-object shape check; 409 on a name clash with another definition; 404 when the id is unknown. At least one field must be provided.
PATCH
/
api
/
v1
/
cdp
/
sql-traits
/
{id}
Update a SQL trait definition
curl --request PATCH \
--url https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}import requests
url = "https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}"
response = requests.patch(url)
print(response.text)const options = {method: 'PATCH'};
fetch('https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}"
req, _ := http.NewRequest("PATCH", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.orbit.devotel.io/api/v1/cdp/sql-traits/{id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
response = http.request(request)
puts response.read_body{
"data": {
"id": "sqltrait_9f2c1d4a7b3e9f2c1d4a7b3e9f2c1d4a7b3e",
"name": "high_value_segment",
"description": "LTV over the 90-day window",
"warehouse": "bigquery",
"sql": "select user_id, sum(o.gmv) as trait_value from orders o group by 1",
"connection_configured": true,
"schedule_minutes": 1440,
"enabled": false,
"created_by": "user_2hGfK9dTsbJ1Q7c",
"created_at": "2026-08-01T09:00:00.000Z",
"updated_at": "2026-08-07T12:00:00.000Z",
"last_run_at": "2026-08-07T00:13:00.000Z",
"last_run_status": "ok",
"last_run_rows": 412,
"last_error": null,
"last_error_at": null
},
"meta": {
"request_id": "req_01J8Z9K3P4Q5R6S7T8U9V0W1X2",
"timestamp": "2026-08-07T12:00:00.000Z"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "RATE_LIMITED",
"message": "<string>",
"status": 429,
"retry_after": 2
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}Path Parameters
Response
The updated SQL trait definition; connection_configured replaces the credential blob.
The updated SQL trait definition; connection_configured replaces the credential blob.