Add a Snowflake account

curl --request POST \
  --url https://api.select.dev/v2/snowflake-accounts \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'x-tenant-id: <x-tenant-id>' \
  --data '
{
  "id": "<string>",
  "name": "<string>",
  "credentials": {
    "username": "<string>",
    "password": "<string>",
    "private_key": "<string>",
    "private_key_passphrase": "<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": false
}
'

import requests

url = "https://api.select.dev/v2/snowflake-accounts"

payload = {
    "id": "<string>",
    "name": "<string>",
    "credentials": {
        "username": "<string>",
        "password": "<string>",
        "private_key": "<string>",
        "private_key_passphrase": "<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": False
}
headers = {
    "x-tenant-id": "<x-tenant-id>",
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {
    'x-tenant-id': '<x-tenant-id>',
    Authorization: 'Bearer <token>',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    id: '<string>',
    name: '<string>',
    credentials: {
      username: '<string>',
      password: '<string>',
      private_key: '<string>',
      private_key_passphrase: '<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: false
  })
};

fetch('https://api.select.dev/v2/snowflake-accounts', 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",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'id' => '<string>',
    'name' => '<string>',
    'credentials' => [
        'username' => '<string>',
        'password' => '<string>',
        'private_key' => '<string>',
        'private_key_passphrase' => '<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' => false
  ]),
  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"

	payload := strings.NewReader("{\n  \"id\": \"<string>\",\n  \"name\": \"<string>\",\n  \"credentials\": {\n    \"username\": \"<string>\",\n    \"password\": \"<string>\",\n    \"private_key\": \"<string>\",\n    \"private_key_passphrase\": \"<string>\"\n  },\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\": false\n}")

	req, _ := http.NewRequest("POST", 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.post("https://api.select.dev/v2/snowflake-accounts")
  .header("x-tenant-id", "<x-tenant-id>")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"id\": \"<string>\",\n  \"name\": \"<string>\",\n  \"credentials\": {\n    \"username\": \"<string>\",\n    \"password\": \"<string>\",\n    \"private_key\": \"<string>\",\n    \"private_key_passphrase\": \"<string>\"\n  },\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\": false\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.select.dev/v2/snowflake-accounts")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"id\": \"<string>\",\n  \"name\": \"<string>\",\n  \"credentials\": {\n    \"username\": \"<string>\",\n    \"password\": \"<string>\",\n    \"private_key\": \"<string>\",\n    \"private_key_passphrase\": \"<string>\"\n  },\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\": false\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": [
    {}
  ]
}

POST

snowflake-accounts

Add a Snowflake account

curl --request POST \
  --url https://api.select.dev/v2/snowflake-accounts \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'x-tenant-id: <x-tenant-id>' \
  --data '
{
  "id": "<string>",
  "name": "<string>",
  "credentials": {
    "username": "<string>",
    "password": "<string>",
    "private_key": "<string>",
    "private_key_passphrase": "<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": false
}
'

import requests

url = "https://api.select.dev/v2/snowflake-accounts"

payload = {
    "id": "<string>",
    "name": "<string>",
    "credentials": {
        "username": "<string>",
        "password": "<string>",
        "private_key": "<string>",
        "private_key_passphrase": "<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": False
}
headers = {
    "x-tenant-id": "<x-tenant-id>",
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {
    'x-tenant-id': '<x-tenant-id>',
    Authorization: 'Bearer <token>',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    id: '<string>',
    name: '<string>',
    credentials: {
      username: '<string>',
      password: '<string>',
      private_key: '<string>',
      private_key_passphrase: '<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: false
  })
};

fetch('https://api.select.dev/v2/snowflake-accounts', 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",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'id' => '<string>',
    'name' => '<string>',
    'credentials' => [
        'username' => '<string>',
        'password' => '<string>',
        'private_key' => '<string>',
        'private_key_passphrase' => '<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' => false
  ]),
  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"

	payload := strings.NewReader("{\n  \"id\": \"<string>\",\n  \"name\": \"<string>\",\n  \"credentials\": {\n    \"username\": \"<string>\",\n    \"password\": \"<string>\",\n    \"private_key\": \"<string>\",\n    \"private_key_passphrase\": \"<string>\"\n  },\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\": false\n}")

	req, _ := http.NewRequest("POST", 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.post("https://api.select.dev/v2/snowflake-accounts")
  .header("x-tenant-id", "<x-tenant-id>")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"id\": \"<string>\",\n  \"name\": \"<string>\",\n  \"credentials\": {\n    \"username\": \"<string>\",\n    \"password\": \"<string>\",\n    \"private_key\": \"<string>\",\n    \"private_key_passphrase\": \"<string>\"\n  },\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\": false\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.select.dev/v2/snowflake-accounts")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"id\": \"<string>\",\n  \"name\": \"<string>\",\n  \"credentials\": {\n    \"username\": \"<string>\",\n    \"password\": \"<string>\",\n    \"private_key\": \"<string>\",\n    \"private_key_passphrase\": \"<string>\"\n  },\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\": false\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": [
    {}
  ]
}

Authorizations

Authorization

string

header

required

Organization API key (sl_…).

Headers

x-tenant-id

string

required

The organization ID the request is scoped to.

Body

application/json

The configuration SELECT needs to start reading a Snowflake account.

Every field here is returned by a read of the created account, except the credentials, which are write-only and never returned.

string

required

The account's Snowflake identifier, in ORGANIZATION-ACCOUNT form (e.g. acme-us-east-1). Cannot be changed once the account is added.

Must already be normalized: lower case, no surrounding whitespace, and - rather than . between organization and account. A PrivateLink identifier, which ends in .privatelink, keeps its dots because the host it resolves to does. A value that is not already normalized is rejected rather than rewritten, so what you submit always matches what a subsequent read returns.

name

string

required

Display name for the account, as shown throughout SELECT.

credentials

SnowflakeCredentials · object

required

How SELECT authenticates to the account.

Show child attributes

role

string | null

The Snowflake role SELECT assumes when reading this account. Null uses the user's default role.

warehouse

string | null

The Snowflake warehouse SELECT runs its queries on. Null uses the user's default warehouse.

describe_object_sproc_name

string | null

Fully qualified name of the stored procedure SELECT calls to describe objects it cannot read directly. Null if there is none.

export_storage_integration_name

string | null

Name of the Snowflake storage integration used to export data to SELECT. Mutually exclusive with export_stage_name.

export_stage_name

string | null

Fully qualified name of the Snowflake stage used to export data to SELECT. Mutually exclusive with export_storage_integration_name.

compute_cost_per_credit

number | null

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.

storage_cost_per_tb

number | null

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.

customer_side_sanitization_database_schema

string | null

DATABASE.SCHEMA hosting your own sanitized copies of Snowflake's account usage views, which SELECT reads instead of the originals. Null disables the redirection.

customer_side_sanitization_views

string[] | null

The account usage views to redirect, such as query_history. Null redirects every view SELECT reads. Requires customer_side_sanitization_database_schema.

excluded_users_filter_expression

string | null

JSON-encoded filter selecting Snowflake users whose activity is excluded from SELECT's cost and usage figures.

fivetran_users

string[] | null

Snowflake users that Fivetran runs as, so their activity is attributed to Fivetran.

mode_workspace

string | null

The Mode workspace to attribute queries to.

mode_token_id

string | null

Identifier of the Mode API token SELECT uses.

mode_token_secret

string | null

The Mode API token secret.

sync_enabled

boolean

default:true

Whether SELECT starts syncing data for this account.

query_sanitization_enabled

boolean

default:false

Whether query text is sanitized before SELECT stores it.

Response

Successful Response

A connection to one Snowflake account.

string

required

The account's Snowflake identifier, in ORGANIZATION-ACCOUNT form. Set by the caller when the account is added and cannot be changed afterward.

etag

string

required

read-only

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.

name

string

required

Display name for the account, as shown throughout SELECT.

snowflake_organization_name

string

required

read-only

Name of the Snowflake organization the account belongs to.

snowflake_account_name

string

required

read-only

The account's name within its Snowflake organization.

mode_credentials_configured

boolean

required

read-only

Whether Mode BI credentials are configured for this account. The credentials themselves are never returned.

connection_id

string

required

read-only

Identifier of the underlying connection this account reads through.

sync_enabled

boolean

required

Whether SELECT is currently syncing data for this account.

query_sanitization_enabled

boolean

required

Whether query text is sanitized before SELECT stores it.

has_org_admin_access

boolean

required

read-only

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.

create_time

string

required

read-only

When the account was added to SELECT, as an RFC 3339 UTC timestamp.

update_time

string

required

read-only

When the account was last changed, as an RFC 3339 UTC timestamp.

locator

string | null

The account's Snowflake locator, as returned by current_account().

account_region

string | null

The Snowflake region the account is hosted in.

snowsight_url

string | null

Link to the account in Snowsight.

snowflake_reader_parent_account_name

string | null

For a reader account, the name of the account that created it. Null for a regular account.

role

string | null

The Snowflake role SELECT assumes when reading this account.

warehouse

string | null

The Snowflake warehouse SELECT runs its queries on.

describe_object_sproc_name

string | null

Fully qualified name of the stored procedure SELECT calls to describe objects it cannot read directly.

export_storage_integration_name

string | null

Name of the Snowflake storage integration used to export data to SELECT. Mutually exclusive with export_stage_name.

export_stage_name

string | null

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.

compute_cost_per_credit

number | null

Overrides the credit rate SELECT reads from Snowflake when costing compute. Null uses the rate on the account's contract.

storage_cost_per_tb

number | null

Overrides the rate SELECT uses when costing storage, per terabyte per month. Null uses the rate on the account's contract.

customer_side_sanitization_database_schema

string | null

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.

customer_side_sanitization_views

string[] | null

The account usage views to redirect, such as query_history. Null redirects every view SELECT reads.

excluded_users_filter_expression

string | null

JSON-encoded filter selecting Snowflake users whose activity is excluded from SELECT's cost and usage figures.

fivetran_users

string[] | null

Snowflake users that Fivetran runs as, so their activity is attributed to Fivetran.

mode_workspace

string | null

The Mode workspace to attribute queries to.

mode_token_id

string | null

Identifier of the Mode API token SELECT uses.

has_manage_warehouses_grant

boolean | null

Whether SELECT's role holds manage warehouses on the account, which smart suspension requires. Null until first checked.

added_by_email

string | null

Email address of the user who added the account.

latest_sync_time

string | null

When SELECT last synced data for this account, as an RFC 3339 UTC timestamp.

last_successful_sync_time

string | null

When the account's last sync succeeded, as an RFC 3339 UTC timestamp. Behind latest_sync_time if the most recent attempt failed.

latest_hourly_spend_time

string | null

The most recent hour SELECT holds spend data for, as an RFC 3339 UTC timestamp.

Get Started

Endpoints

Add a Snowflake account

Authorizations

Headers

Body

Response