curl --request GET \
--url https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id} \
--header 'Authorization: Bearer <token>' \
--header 'x-tenant-id: <x-tenant-id>'import requests
url = "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
headers = {
"x-tenant-id": "<x-tenant-id>",
"Authorization": "Bearer <token>"
}
response = requests.get(url, headers=headers)
print(response.text)const options = {
method: 'GET',
headers: {'x-tenant-id': '<x-tenant-id>', Authorization: 'Bearer <token>'}
};
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 => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"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"
"net/http"
"io"
)
func main() {
url := "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("x-tenant-id", "<x-tenant-id>")
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}")
.header("x-tenant-id", "<x-tenant-id>")
.header("Authorization", "Bearer <token>")
.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::Get.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'
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": [
{}
]
}Get a Snowflake account
curl --request GET \
--url https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id} \
--header 'Authorization: Bearer <token>' \
--header 'x-tenant-id: <x-tenant-id>'import requests
url = "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
headers = {
"x-tenant-id": "<x-tenant-id>",
"Authorization": "Bearer <token>"
}
response = requests.get(url, headers=headers)
print(response.text)const options = {
method: 'GET',
headers: {'x-tenant-id': '<x-tenant-id>', Authorization: 'Bearer <token>'}
};
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 => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"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"
"net/http"
"io"
)
func main() {
url := "https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("x-tenant-id", "<x-tenant-id>")
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.select.dev/v2/snowflake-accounts/{snowflake_account_id}")
.header("x-tenant-id", "<x-tenant-id>")
.header("Authorization", "Bearer <token>")
.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::Get.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'
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": [
{}
]
}Authorizations
Organization API key (sl_…).
Headers
The organization ID the request is scoped to.
Path Parameters
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.

