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
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 added. name, credentials,
sync_enabled and query_sanitization_enabled cannot be cleared: they are
optional here only so they can be omitted, and rejecting an explicit null
on them (rather than silently ignoring it) matches the JSON Merge Patch
contract that null means "clear," which isn't a legal state for these.
mode_token_secret cannot be cleared either, for a different reason: the
secret is only meaningful alongside mode_workspace and mode_token_id,
so clearing it alone would leave the pair pointing at a Mode connection
with no secret behind it. Disconnect Mode entirely with mode_workspace: null, which clears all three together.
username is top-level rather than nested in credentials so the Snowflake
user can be corrected without resupplying a password or private key — the
same reason mode_workspace/mode_token_id/mode_token_secret are three
separate fields rather than one Mode object. It cannot be sent alongside
credentials, which already carries its own username; picking a winner
between the two silently would be worse than rejecting the request. It also
cannot be cleared: a Snowflake user is always required for password and
key_pair, and does not exist for workload_identity_federation, so there
is no method for which null is a legal state.
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.