Update a connection

curl --request PATCH \
  --url https://api.select.dev/v2/connections/{connection_id} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'x-tenant-id: <x-tenant-id>' \
  --data '
{
  "looker_base_url": "<string>",
  "looker_client_id": "<string>",
  "looker_client_secret": "<string>"
}
'

import requests

url = "https://api.select.dev/v2/connections/{connection_id}"

payload = {
    "looker_base_url": "<string>",
    "looker_client_id": "<string>",
    "looker_client_secret": "<string>"
}
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({
    looker_base_url: '<string>',
    looker_client_id: '<string>',
    looker_client_secret: '<string>'
  })
};

fetch('https://api.select.dev/v2/connections/{connection_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/connections/{connection_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([
    'looker_base_url' => '<string>',
    'looker_client_id' => '<string>',
    'looker_client_secret' => '<string>'
  ]),
  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/connections/{connection_id}"

	payload := strings.NewReader("{\n  \"looker_base_url\": \"<string>\",\n  \"looker_client_id\": \"<string>\",\n  \"looker_client_secret\": \"<string>\"\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/connections/{connection_id}")
  .header("x-tenant-id", "<x-tenant-id>")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"looker_base_url\": \"<string>\",\n  \"looker_client_id\": \"<string>\",\n  \"looker_client_secret\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.select.dev/v2/connections/{connection_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  \"looker_base_url\": \"<string>\",\n  \"looker_client_id\": \"<string>\",\n  \"looker_client_secret\": \"<string>\"\n}"

response = http.request(request)
puts response.read_body

{
  "id": "<string>",
  "etag": "<string>",
  "name": "<string>",
  "connection_type": "snowflake",
  "sync_enabled": true,
  "query_sanitization_enabled": true,
  "looker_credentials_configured": true,
  "create_time": "<string>",
  "update_time": "<string>",
  "looker_base_url": "<string>",
  "looker_client_id": "<string>",
  "added_by_email": "<string>",
  "last_successful_sync_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": [
    {}
  ]
}

PATCH

connections

{connection_id}

Update a connection

curl --request PATCH \
  --url https://api.select.dev/v2/connections/{connection_id} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'x-tenant-id: <x-tenant-id>' \
  --data '
{
  "looker_base_url": "<string>",
  "looker_client_id": "<string>",
  "looker_client_secret": "<string>"
}
'

import requests

url = "https://api.select.dev/v2/connections/{connection_id}"

payload = {
    "looker_base_url": "<string>",
    "looker_client_id": "<string>",
    "looker_client_secret": "<string>"
}
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({
    looker_base_url: '<string>',
    looker_client_id: '<string>',
    looker_client_secret: '<string>'
  })
};

fetch('https://api.select.dev/v2/connections/{connection_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/connections/{connection_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([
    'looker_base_url' => '<string>',
    'looker_client_id' => '<string>',
    'looker_client_secret' => '<string>'
  ]),
  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/connections/{connection_id}"

	payload := strings.NewReader("{\n  \"looker_base_url\": \"<string>\",\n  \"looker_client_id\": \"<string>\",\n  \"looker_client_secret\": \"<string>\"\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/connections/{connection_id}")
  .header("x-tenant-id", "<x-tenant-id>")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"looker_base_url\": \"<string>\",\n  \"looker_client_id\": \"<string>\",\n  \"looker_client_secret\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.select.dev/v2/connections/{connection_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  \"looker_base_url\": \"<string>\",\n  \"looker_client_id\": \"<string>\",\n  \"looker_client_secret\": \"<string>\"\n}"

response = http.request(request)
puts response.read_body

{
  "id": "<string>",
  "etag": "<string>",
  "name": "<string>",
  "connection_type": "snowflake",
  "sync_enabled": true,
  "query_sanitization_enabled": true,
  "looker_credentials_configured": true,
  "create_time": "<string>",
  "update_time": "<string>",
  "looker_base_url": "<string>",
  "looker_client_id": "<string>",
  "added_by_email": "<string>",
  "last_successful_sync_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

Authorization

string

header

required

Organization API key (sl_…).

Headers

If-Match

string | null

x-tenant-id

string

required

The organization ID the request is scoped to.

Path Parameters

connection_id

string

required

Body

application/json

A merge-patch update to an existing connection. Omitted fields are left unchanged; null clears a field.

Only Looker fields can be updated here. name, sync_enabled, and query_sanitization_enabled are updated through the platform-specific resource instead (e.g. PATCH /v2/snowflake-accounts).

looker_client_secret cannot be cleared on its own, since it's only meaningful together with looker_base_url and looker_client_id. To disconnect Looker entirely, set looker_base_url to null, which clears all three fields together.

looker_base_url

string | null

Base URL of the Looker instance to query.

looker_client_id

string | null

Identifier of the Looker API client SELECT uses.

looker_client_secret

string | null

The Looker API client secret. Cannot be cleared with null; disconnect Looker with looker_base_url: null instead.

Response

Successful Response

A connection between SELECT and one data platform.

string

required

read-only

The unique identifier of the connection.

etag

string

required

read-only

Opaque strong ETag for this connection's configuration. Matches the ETag response header, and is what If-Match requires on a write. It changes whenever a configurable field on the connection changes.

name

string

required

Display name for the connection, as shown throughout SELECT.

connection_type

enum<string>

required

read-only

The data platform this connection reads from. Fixed when the connection is added; a connection cannot be moved to another platform.

Available options:

snowflake,

tableau,

databricks,

bigquery,

aws,

azure

sync_enabled

boolean

required

Whether SELECT is currently syncing data for this connection.

query_sanitization_enabled

boolean

required

Whether query text is sanitized before SELECT stores it.

looker_credentials_configured

boolean

required

read-only

Whether Looker credentials are configured for this connection. The credentials themselves are never returned.

create_time

string

required

read-only

When the connection was added.

update_time

string

required

read-only

When the connection was last changed.

looker_base_url

string | null

Base URL of the Looker instance to query.

looker_client_id

string | null

Identifier of the Looker API client SELECT uses.

added_by_email

string | null

Email address of the person who added the connection. Null when it was not added by a person.

last_successful_sync_time

string | null

When SELECT last completed a sync for this connection. Null before the first one succeeds.

Get Started

Endpoints

Update a connection

Authorizations

Headers

Path Parameters

Body

Response