curl --request PATCH \
--url https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--header 'x-tenant-id: <x-tenant-id>' \
--data '
{
"name": "<string>",
"credentials": {
"username": "<string>",
"password": "<string>",
"private_key": "<string>",
"private_key_passphrase": "<string>"
},
"username": "<string>",
"role": "<string>",
"warehouse": "<string>",
"describe_object_sproc_name": "<string>",
"export_storage_integration_name": "<string>",
"export_stage_name": "<string>",
"compute_cost_per_credit": 123,
"storage_cost_per_tb": 123,
"customer_side_sanitization_database_schema": "<string>",
"customer_side_sanitization_views": [
"<string>"
],
"excluded_users_filter_expression": "<string>",
"fivetran_users": [
"<string>"
],
"mode_workspace": "<string>",
"mode_token_id": "<string>",
"mode_token_secret": "<string>",
"sync_enabled": true,
"query_sanitization_enabled": true
}
'import requests
url = "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
payload = {
"name": "<string>",
"credentials": {
"username": "<string>",
"password": "<string>",
"private_key": "<string>",
"private_key_passphrase": "<string>"
},
"username": "<string>",
"role": "<string>",
"warehouse": "<string>",
"describe_object_sproc_name": "<string>",
"export_storage_integration_name": "<string>",
"export_stage_name": "<string>",
"compute_cost_per_credit": 123,
"storage_cost_per_tb": 123,
"customer_side_sanitization_database_schema": "<string>",
"customer_side_sanitization_views": ["<string>"],
"excluded_users_filter_expression": "<string>",
"fivetran_users": ["<string>"],
"mode_workspace": "<string>",
"mode_token_id": "<string>",
"mode_token_secret": "<string>",
"sync_enabled": True,
"query_sanitization_enabled": True
}
headers = {
"x-tenant-id": "<x-tenant-id>",
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {
'x-tenant-id': '<x-tenant-id>',
Authorization: 'Bearer <token>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
name: '<string>',
credentials: {
username: '<string>',
password: '<string>',
private_key: '<string>',
private_key_passphrase: '<string>'
},
username: '<string>',
role: '<string>',
warehouse: '<string>',
describe_object_sproc_name: '<string>',
export_storage_integration_name: '<string>',
export_stage_name: '<string>',
compute_cost_per_credit: 123,
storage_cost_per_tb: 123,
customer_side_sanitization_database_schema: '<string>',
customer_side_sanitization_views: ['<string>'],
excluded_users_filter_expression: '<string>',
fivetran_users: ['<string>'],
mode_workspace: '<string>',
mode_token_id: '<string>',
mode_token_secret: '<string>',
sync_enabled: true,
query_sanitization_enabled: true
})
};
fetch('https://api.select.dev/v2/snowflake-accounts/{snowflake_account_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.select.dev/v2/snowflake-accounts/{snowflake_account_id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'credentials' => [
'username' => '<string>',
'password' => '<string>',
'private_key' => '<string>',
'private_key_passphrase' => '<string>'
],
'username' => '<string>',
'role' => '<string>',
'warehouse' => '<string>',
'describe_object_sproc_name' => '<string>',
'export_storage_integration_name' => '<string>',
'export_stage_name' => '<string>',
'compute_cost_per_credit' => 123,
'storage_cost_per_tb' => 123,
'customer_side_sanitization_database_schema' => '<string>',
'customer_side_sanitization_views' => [
'<string>'
],
'excluded_users_filter_expression' => '<string>',
'fivetran_users' => [
'<string>'
],
'mode_workspace' => '<string>',
'mode_token_id' => '<string>',
'mode_token_secret' => '<string>',
'sync_enabled' => true,
'query_sanitization_enabled' => true
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json",
"x-tenant-id: <x-tenant-id>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"credentials\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\",\n \"private_key\": \"<string>\",\n \"private_key_passphrase\": \"<string>\"\n },\n \"username\": \"<string>\",\n \"role\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"describe_object_sproc_name\": \"<string>\",\n \"export_storage_integration_name\": \"<string>\",\n \"export_stage_name\": \"<string>\",\n \"compute_cost_per_credit\": 123,\n \"storage_cost_per_tb\": 123,\n \"customer_side_sanitization_database_schema\": \"<string>\",\n \"customer_side_sanitization_views\": [\n \"<string>\"\n ],\n \"excluded_users_filter_expression\": \"<string>\",\n \"fivetran_users\": [\n \"<string>\"\n ],\n \"mode_workspace\": \"<string>\",\n \"mode_token_id\": \"<string>\",\n \"mode_token_secret\": \"<string>\",\n \"sync_enabled\": true,\n \"query_sanitization_enabled\": true\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("x-tenant-id", "<x-tenant-id>")
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
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.select.dev/v2/snowflake-accounts/{snowflake_account_id}")
.header("x-tenant-id", "<x-tenant-id>")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"credentials\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\",\n \"private_key\": \"<string>\",\n \"private_key_passphrase\": \"<string>\"\n },\n \"username\": \"<string>\",\n \"role\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"describe_object_sproc_name\": \"<string>\",\n \"export_storage_integration_name\": \"<string>\",\n \"export_stage_name\": \"<string>\",\n \"compute_cost_per_credit\": 123,\n \"storage_cost_per_tb\": 123,\n \"customer_side_sanitization_database_schema\": \"<string>\",\n \"customer_side_sanitization_views\": [\n \"<string>\"\n ],\n \"excluded_users_filter_expression\": \"<string>\",\n \"fivetran_users\": [\n \"<string>\"\n ],\n \"mode_workspace\": \"<string>\",\n \"mode_token_id\": \"<string>\",\n \"mode_token_secret\": \"<string>\",\n \"sync_enabled\": true,\n \"query_sanitization_enabled\": true\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"credentials\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\",\n \"private_key\": \"<string>\",\n \"private_key_passphrase\": \"<string>\"\n },\n \"username\": \"<string>\",\n \"role\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"describe_object_sproc_name\": \"<string>\",\n \"export_storage_integration_name\": \"<string>\",\n \"export_stage_name\": \"<string>\",\n \"compute_cost_per_credit\": 123,\n \"storage_cost_per_tb\": 123,\n \"customer_side_sanitization_database_schema\": \"<string>\",\n \"customer_side_sanitization_views\": [\n \"<string>\"\n ],\n \"excluded_users_filter_expression\": \"<string>\",\n \"fivetran_users\": [\n \"<string>\"\n ],\n \"mode_workspace\": \"<string>\",\n \"mode_token_id\": \"<string>\",\n \"mode_token_secret\": \"<string>\",\n \"sync_enabled\": true,\n \"query_sanitization_enabled\": true\n}"
response = http.request(request)
puts response.read_body{
"id": "<string>",
"etag": "<string>",
"name": "<string>",
"snowflake_organization_name": "<string>",
"snowflake_account_name": "<string>",
"mode_credentials_configured": true,
"connection_id": "<string>",
"sync_enabled": true,
"query_sanitization_enabled": true,
"has_org_admin_access": true,
"has_data_share": true,
"create_time": "<string>",
"update_time": "<string>",
"locator": "<string>",
"account_region": "<string>",
"snowsight_url": "<string>",
"snowflake_reader_parent_account_name": "<string>",
"role": "<string>",
"warehouse": "<string>",
"describe_object_sproc_name": "<string>",
"export_storage_integration_name": "<string>",
"export_stage_name": "<string>",
"compute_cost_per_credit": 123,
"storage_cost_per_tb": 123,
"customer_side_sanitization_database_schema": "<string>",
"customer_side_sanitization_views": [
"<string>"
],
"excluded_users_filter_expression": "<string>",
"fivetran_users": [
"<string>"
],
"mode_workspace": "<string>",
"mode_token_id": "<string>",
"has_manage_warehouses_grant": true,
"added_by_email": "<string>",
"latest_sync_time": "<string>",
"last_successful_sync_time": "<string>",
"latest_hourly_spend_time": "<string>"
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}Update a Snowflake account
Update a Snowflake account.
Merge-patch: only the fields you send change; omitted fields are left as-is.
curl --request PATCH \
--url https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--header 'x-tenant-id: <x-tenant-id>' \
--data '
{
"name": "<string>",
"credentials": {
"username": "<string>",
"password": "<string>",
"private_key": "<string>",
"private_key_passphrase": "<string>"
},
"username": "<string>",
"role": "<string>",
"warehouse": "<string>",
"describe_object_sproc_name": "<string>",
"export_storage_integration_name": "<string>",
"export_stage_name": "<string>",
"compute_cost_per_credit": 123,
"storage_cost_per_tb": 123,
"customer_side_sanitization_database_schema": "<string>",
"customer_side_sanitization_views": [
"<string>"
],
"excluded_users_filter_expression": "<string>",
"fivetran_users": [
"<string>"
],
"mode_workspace": "<string>",
"mode_token_id": "<string>",
"mode_token_secret": "<string>",
"sync_enabled": true,
"query_sanitization_enabled": true
}
'import requests
url = "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
payload = {
"name": "<string>",
"credentials": {
"username": "<string>",
"password": "<string>",
"private_key": "<string>",
"private_key_passphrase": "<string>"
},
"username": "<string>",
"role": "<string>",
"warehouse": "<string>",
"describe_object_sproc_name": "<string>",
"export_storage_integration_name": "<string>",
"export_stage_name": "<string>",
"compute_cost_per_credit": 123,
"storage_cost_per_tb": 123,
"customer_side_sanitization_database_schema": "<string>",
"customer_side_sanitization_views": ["<string>"],
"excluded_users_filter_expression": "<string>",
"fivetran_users": ["<string>"],
"mode_workspace": "<string>",
"mode_token_id": "<string>",
"mode_token_secret": "<string>",
"sync_enabled": True,
"query_sanitization_enabled": True
}
headers = {
"x-tenant-id": "<x-tenant-id>",
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {
'x-tenant-id': '<x-tenant-id>',
Authorization: 'Bearer <token>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
name: '<string>',
credentials: {
username: '<string>',
password: '<string>',
private_key: '<string>',
private_key_passphrase: '<string>'
},
username: '<string>',
role: '<string>',
warehouse: '<string>',
describe_object_sproc_name: '<string>',
export_storage_integration_name: '<string>',
export_stage_name: '<string>',
compute_cost_per_credit: 123,
storage_cost_per_tb: 123,
customer_side_sanitization_database_schema: '<string>',
customer_side_sanitization_views: ['<string>'],
excluded_users_filter_expression: '<string>',
fivetran_users: ['<string>'],
mode_workspace: '<string>',
mode_token_id: '<string>',
mode_token_secret: '<string>',
sync_enabled: true,
query_sanitization_enabled: true
})
};
fetch('https://api.select.dev/v2/snowflake-accounts/{snowflake_account_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.select.dev/v2/snowflake-accounts/{snowflake_account_id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'credentials' => [
'username' => '<string>',
'password' => '<string>',
'private_key' => '<string>',
'private_key_passphrase' => '<string>'
],
'username' => '<string>',
'role' => '<string>',
'warehouse' => '<string>',
'describe_object_sproc_name' => '<string>',
'export_storage_integration_name' => '<string>',
'export_stage_name' => '<string>',
'compute_cost_per_credit' => 123,
'storage_cost_per_tb' => 123,
'customer_side_sanitization_database_schema' => '<string>',
'customer_side_sanitization_views' => [
'<string>'
],
'excluded_users_filter_expression' => '<string>',
'fivetran_users' => [
'<string>'
],
'mode_workspace' => '<string>',
'mode_token_id' => '<string>',
'mode_token_secret' => '<string>',
'sync_enabled' => true,
'query_sanitization_enabled' => true
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json",
"x-tenant-id: <x-tenant-id>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"credentials\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\",\n \"private_key\": \"<string>\",\n \"private_key_passphrase\": \"<string>\"\n },\n \"username\": \"<string>\",\n \"role\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"describe_object_sproc_name\": \"<string>\",\n \"export_storage_integration_name\": \"<string>\",\n \"export_stage_name\": \"<string>\",\n \"compute_cost_per_credit\": 123,\n \"storage_cost_per_tb\": 123,\n \"customer_side_sanitization_database_schema\": \"<string>\",\n \"customer_side_sanitization_views\": [\n \"<string>\"\n ],\n \"excluded_users_filter_expression\": \"<string>\",\n \"fivetran_users\": [\n \"<string>\"\n ],\n \"mode_workspace\": \"<string>\",\n \"mode_token_id\": \"<string>\",\n \"mode_token_secret\": \"<string>\",\n \"sync_enabled\": true,\n \"query_sanitization_enabled\": true\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("x-tenant-id", "<x-tenant-id>")
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
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.select.dev/v2/snowflake-accounts/{snowflake_account_id}")
.header("x-tenant-id", "<x-tenant-id>")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"credentials\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\",\n \"private_key\": \"<string>\",\n \"private_key_passphrase\": \"<string>\"\n },\n \"username\": \"<string>\",\n \"role\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"describe_object_sproc_name\": \"<string>\",\n \"export_storage_integration_name\": \"<string>\",\n \"export_stage_name\": \"<string>\",\n \"compute_cost_per_credit\": 123,\n \"storage_cost_per_tb\": 123,\n \"customer_side_sanitization_database_schema\": \"<string>\",\n \"customer_side_sanitization_views\": [\n \"<string>\"\n ],\n \"excluded_users_filter_expression\": \"<string>\",\n \"fivetran_users\": [\n \"<string>\"\n ],\n \"mode_workspace\": \"<string>\",\n \"mode_token_id\": \"<string>\",\n \"mode_token_secret\": \"<string>\",\n \"sync_enabled\": true,\n \"query_sanitization_enabled\": true\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"credentials\": {\n \"username\": \"<string>\",\n \"password\": \"<string>\",\n \"private_key\": \"<string>\",\n \"private_key_passphrase\": \"<string>\"\n },\n \"username\": \"<string>\",\n \"role\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"describe_object_sproc_name\": \"<string>\",\n \"export_storage_integration_name\": \"<string>\",\n \"export_stage_name\": \"<string>\",\n \"compute_cost_per_credit\": 123,\n \"storage_cost_per_tb\": 123,\n \"customer_side_sanitization_database_schema\": \"<string>\",\n \"customer_side_sanitization_views\": [\n \"<string>\"\n ],\n \"excluded_users_filter_expression\": \"<string>\",\n \"fivetran_users\": [\n \"<string>\"\n ],\n \"mode_workspace\": \"<string>\",\n \"mode_token_id\": \"<string>\",\n \"mode_token_secret\": \"<string>\",\n \"sync_enabled\": true,\n \"query_sanitization_enabled\": true\n}"
response = http.request(request)
puts response.read_body{
"id": "<string>",
"etag": "<string>",
"name": "<string>",
"snowflake_organization_name": "<string>",
"snowflake_account_name": "<string>",
"mode_credentials_configured": true,
"connection_id": "<string>",
"sync_enabled": true,
"query_sanitization_enabled": true,
"has_org_admin_access": true,
"has_data_share": true,
"create_time": "<string>",
"update_time": "<string>",
"locator": "<string>",
"account_region": "<string>",
"snowsight_url": "<string>",
"snowflake_reader_parent_account_name": "<string>",
"role": "<string>",
"warehouse": "<string>",
"describe_object_sproc_name": "<string>",
"export_storage_integration_name": "<string>",
"export_stage_name": "<string>",
"compute_cost_per_credit": 123,
"storage_cost_per_tb": 123,
"customer_side_sanitization_database_schema": "<string>",
"customer_side_sanitization_views": [
"<string>"
],
"excluded_users_filter_expression": "<string>",
"fivetran_users": [
"<string>"
],
"mode_workspace": "<string>",
"mode_token_id": "<string>",
"has_manage_warehouses_grant": true,
"added_by_email": "<string>",
"latest_sync_time": "<string>",
"last_successful_sync_time": "<string>",
"latest_hourly_spend_time": "<string>"
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}{
"title": "<string>",
"status": 123,
"detail": "<string>",
"code": "<string>",
"retryable": true,
"type": "about:blank",
"details": [
{}
]
}Authorizations
Organization API key (sl_…).
Headers
The organization ID the request is scoped to.
Path Parameters
Body
A merge-patch update to an existing Snowflake account. Omitted fields
are left unchanged; null clears a field.
Every field mirrors its SnowflakeAccountCreate counterpart except id,
which cannot be changed once the account is created.
name, credentials, sync_enabled, and query_sanitization_enabled
cannot be cleared: sending null is rejected. mode_token_secret also
cannot be cleared on its own; use mode_workspace: null to disconnect
Mode, which clears mode_workspace, mode_token_id, and
mode_token_secret together.
Display name for the account, as shown throughout SELECT.
How SELECT authenticates to the account.
Show child attributes
Show child attributes
The Snowflake user SELECT connects as. Changes just the username, leaving the stored password or private key untouched. Cannot be sent alongside credentials, and not valid for an account using workload_identity_federation, which has no username.
The Snowflake role SELECT assumes when reading this account. Null uses the user's default role.
The Snowflake warehouse SELECT runs its queries on. Null uses the user's default warehouse.
Fully qualified name of the stored procedure SELECT calls to describe objects it cannot read directly. Null if there is none.
Name of the Snowflake storage integration used to export data to SELECT. Mutually exclusive with export_stage_name.
Fully qualified name of the Snowflake stage used to export data to SELECT. Mutually exclusive with export_storage_integration_name.
Overrides the credit rate SELECT reads from Snowflake when costing compute. Required together with storage_cost_per_tb when the account cannot read organization-level rates.
Overrides the rate SELECT uses when costing storage, per terabyte per month. Required together with compute_cost_per_credit when the account cannot read organization-level rates.
DATABASE.SCHEMA hosting your own sanitized copies of Snowflake's account usage views, which SELECT reads instead of the originals. Null disables the redirection.
The account usage views to redirect, such as query_history. Null redirects every view SELECT reads. Requires customer_side_sanitization_database_schema.
JSON-encoded filter selecting Snowflake users whose activity is excluded from SELECT's cost and usage figures.
Snowflake users that Fivetran runs as, so their activity is attributed to Fivetran.
The Mode workspace to attribute queries to.
Identifier of the Mode API token SELECT uses.
The Mode API token secret. Cannot be cleared with null; disconnect Mode with mode_workspace: null instead.
Whether SELECT starts syncing data for this account.
Whether query text is sanitized before SELECT stores it.
Response
Successful Response
A connection to one Snowflake account.
The account's Snowflake identifier, in ORGANIZATION-ACCOUNT form. Set by the caller when the account is added and cannot be changed afterward.
Opaque strong ETag for this account's configuration. Matches the ETag response header, and is what If-Match requires on a write. It changes whenever a configurable field on the account changes.
Display name for the account, as shown throughout SELECT.
Name of the Snowflake organization the account belongs to.
The account's name within its Snowflake organization.
Whether Mode BI credentials are configured for this account. The credentials themselves are never returned.
Identifier of the underlying connection this account reads through.
Whether SELECT is currently syncing data for this account.
Whether query text is sanitized before SELECT stores it.
Whether SELECT can read this account's Snowflake organization-level usage views, which is what makes organization-wide rates and spend available.
Whether the account reads SELECT's data share.
When the account was added to SELECT, as an RFC 3339 UTC timestamp.
When the account was last changed, as an RFC 3339 UTC timestamp.
The account's Snowflake locator, as returned by current_account().
The Snowflake region the account is hosted in.
Link to the account in Snowsight.
For a reader account, the name of the account that created it. Null for a regular account.
The Snowflake role SELECT assumes when reading this account.
The Snowflake warehouse SELECT runs its queries on.
Fully qualified name of the stored procedure SELECT calls to describe objects it cannot read directly.
Name of the Snowflake storage integration used to export data to SELECT. Mutually exclusive with export_stage_name.
Fully qualified name of the Snowflake stage used to export data to SELECT, for accounts that export through a stage rather than a storage integration.
Overrides the credit rate SELECT reads from Snowflake when costing compute. Null uses the rate on the account's contract.
Overrides the rate SELECT uses when costing storage, per terabyte per month. Null uses the rate on the account's contract.
DATABASE.SCHEMA hosting the customer's own sanitized copies of Snowflake's account usage views, which SELECT reads instead of the originals. Null disables the redirection.
The account usage views to redirect, such as query_history. Null redirects every view SELECT reads.
JSON-encoded filter selecting Snowflake users whose activity is excluded from SELECT's cost and usage figures.
Snowflake users that Fivetran runs as, so their activity is attributed to Fivetran.
The Mode workspace to attribute queries to.
Identifier of the Mode API token SELECT uses.
Whether SELECT's role holds manage warehouses on the account, which smart suspension requires. Null until first checked.
Email address of the user who added the account.
When SELECT last synced data for this account, as an RFC 3339 UTC timestamp.
When the account's last sync succeeded, as an RFC 3339 UTC timestamp. Behind latest_sync_time if the most recent attempt failed.
The most recent hour SELECT holds spend data for, as an RFC 3339 UTC timestamp.