Create a data source
Tests the connection and validates each assignment query against the warehouse before saving. The Managed Warehouse, Google Analytics and Event Forwarders are set up in the app.
POST
/
v1
/
data-sources
cURL
curl -X POST 'https://api.growthbook.io/api/v1/data-sources' \
-H 'Authorization: Bearer YOUR_API_KEY'import requests
url = "https://api.growthbook.io/api/v1/data-sources"
payload = {
"name": "<string>",
"connection": {
"type": "postgres",
"host": "<string>",
"port": 123,
"database": "<string>",
"user": "<string>",
"password": "<string>",
"defaultSchema": "<string>",
"ssl": True,
"caCert": "<string>",
"clientCert": "<string>",
"clientKey": "<string>"
},
"description": "<string>",
"projectIds": ["<string>"],
"identifierTypes": [
{
"id": "<string>",
"description": "<string>"
}
],
"assignmentQueries": [
{
"name": "<string>",
"sql": "<string>",
"id": "<string>",
"description": "<string>",
"identifierTypes": ["<string>"],
"identifierType": "<string>",
"includesNameColumns": True,
"dimensionColumns": ["<string>"],
"projects": ["<string>"],
"columnMapping": {
"experimentIdColumn": "<string>",
"variationIdColumn": "<string>",
"timestampColumn": "<string>",
"userIdColumns": {},
"experimentNameColumn": "<string>",
"variationNameColumn": "<string>"
}
}
],
"identifierJoinQueries": [
{
"identifierTypes": ["<string>"],
"sql": "<string>"
}
],
"mixpanelSettings": {
"viewedExperimentEventName": "<string>",
"experimentIdProperty": "<string>",
"variationIdProperty": "<string>",
"extraUserIdProperty": "<string>"
},
"pipelineSettings": {
"allowWriting": True,
"writeDatabase": "<string>",
"writeDataset": "<string>",
"unitsTableRetentionHours": 123,
"unitsTableDeletion": True,
"includedExperimentIds": ["<string>"],
"excludedExperimentIds": ["<string>"],
"incrementalOptInExperimentIds": ["<string>"]
},
"maxConcurrentQueries": 1,
"queryCacheTTLMins": 1
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
name: '<string>',
connection: {
type: 'postgres',
host: '<string>',
port: 123,
database: '<string>',
user: '<string>',
password: '<string>',
defaultSchema: '<string>',
ssl: true,
caCert: '<string>',
clientCert: '<string>',
clientKey: '<string>'
},
description: '<string>',
projectIds: ['<string>'],
identifierTypes: [{id: '<string>', description: '<string>'}],
assignmentQueries: [
{
name: '<string>',
sql: '<string>',
id: '<string>',
description: '<string>',
identifierTypes: ['<string>'],
identifierType: '<string>',
includesNameColumns: true,
dimensionColumns: ['<string>'],
projects: ['<string>'],
columnMapping: {
experimentIdColumn: '<string>',
variationIdColumn: '<string>',
timestampColumn: '<string>',
userIdColumns: {},
experimentNameColumn: '<string>',
variationNameColumn: '<string>'
}
}
],
identifierJoinQueries: [{identifierTypes: ['<string>'], sql: '<string>'}],
mixpanelSettings: {
viewedExperimentEventName: '<string>',
experimentIdProperty: '<string>',
variationIdProperty: '<string>',
extraUserIdProperty: '<string>'
},
pipelineSettings: {
allowWriting: true,
writeDatabase: '<string>',
writeDataset: '<string>',
unitsTableRetentionHours: 123,
unitsTableDeletion: true,
includedExperimentIds: ['<string>'],
excludedExperimentIds: ['<string>'],
incrementalOptInExperimentIds: ['<string>']
},
maxConcurrentQueries: 1,
queryCacheTTLMins: 1
})
};
fetch('https://api.growthbook.io/api/v1/data-sources', 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.growthbook.io/api/v1/data-sources",
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([
'name' => '<string>',
'connection' => [
'type' => 'postgres',
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'user' => '<string>',
'password' => '<string>',
'defaultSchema' => '<string>',
'ssl' => true,
'caCert' => '<string>',
'clientCert' => '<string>',
'clientKey' => '<string>'
],
'description' => '<string>',
'projectIds' => [
'<string>'
],
'identifierTypes' => [
[
'id' => '<string>',
'description' => '<string>'
]
],
'assignmentQueries' => [
[
'name' => '<string>',
'sql' => '<string>',
'id' => '<string>',
'description' => '<string>',
'identifierTypes' => [
'<string>'
],
'identifierType' => '<string>',
'includesNameColumns' => true,
'dimensionColumns' => [
'<string>'
],
'projects' => [
'<string>'
],
'columnMapping' => [
'experimentIdColumn' => '<string>',
'variationIdColumn' => '<string>',
'timestampColumn' => '<string>',
'userIdColumns' => [
],
'experimentNameColumn' => '<string>',
'variationNameColumn' => '<string>'
]
]
],
'identifierJoinQueries' => [
[
'identifierTypes' => [
'<string>'
],
'sql' => '<string>'
]
],
'mixpanelSettings' => [
'viewedExperimentEventName' => '<string>',
'experimentIdProperty' => '<string>',
'variationIdProperty' => '<string>',
'extraUserIdProperty' => '<string>'
],
'pipelineSettings' => [
'allowWriting' => true,
'writeDatabase' => '<string>',
'writeDataset' => '<string>',
'unitsTableRetentionHours' => 123,
'unitsTableDeletion' => true,
'includedExperimentIds' => [
'<string>'
],
'excludedExperimentIds' => [
'<string>'
],
'incrementalOptInExperimentIds' => [
'<string>'
]
],
'maxConcurrentQueries' => 1,
'queryCacheTTLMins' => 1
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$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.growthbook.io/api/v1/data-sources"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"connection\": {\n \"type\": \"postgres\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"user\": \"<string>\",\n \"password\": \"<string>\",\n \"defaultSchema\": \"<string>\",\n \"ssl\": true,\n \"caCert\": \"<string>\",\n \"clientCert\": \"<string>\",\n \"clientKey\": \"<string>\"\n },\n \"description\": \"<string>\",\n \"projectIds\": [\n \"<string>\"\n ],\n \"identifierTypes\": [\n {\n \"id\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"assignmentQueries\": [\n {\n \"name\": \"<string>\",\n \"sql\": \"<string>\",\n \"id\": \"<string>\",\n \"description\": \"<string>\",\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"identifierType\": \"<string>\",\n \"includesNameColumns\": true,\n \"dimensionColumns\": [\n \"<string>\"\n ],\n \"projects\": [\n \"<string>\"\n ],\n \"columnMapping\": {\n \"experimentIdColumn\": \"<string>\",\n \"variationIdColumn\": \"<string>\",\n \"timestampColumn\": \"<string>\",\n \"userIdColumns\": {},\n \"experimentNameColumn\": \"<string>\",\n \"variationNameColumn\": \"<string>\"\n }\n }\n ],\n \"identifierJoinQueries\": [\n {\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\"\n }\n ],\n \"mixpanelSettings\": {\n \"viewedExperimentEventName\": \"<string>\",\n \"experimentIdProperty\": \"<string>\",\n \"variationIdProperty\": \"<string>\",\n \"extraUserIdProperty\": \"<string>\"\n },\n \"pipelineSettings\": {\n \"allowWriting\": true,\n \"writeDatabase\": \"<string>\",\n \"writeDataset\": \"<string>\",\n \"unitsTableRetentionHours\": 123,\n \"unitsTableDeletion\": true,\n \"includedExperimentIds\": [\n \"<string>\"\n ],\n \"excludedExperimentIds\": [\n \"<string>\"\n ],\n \"incrementalOptInExperimentIds\": [\n \"<string>\"\n ]\n },\n \"maxConcurrentQueries\": 1,\n \"queryCacheTTLMins\": 1\n}")
req, _ := http.NewRequest("POST", url, payload)
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.growthbook.io/api/v1/data-sources")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"connection\": {\n \"type\": \"postgres\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"user\": \"<string>\",\n \"password\": \"<string>\",\n \"defaultSchema\": \"<string>\",\n \"ssl\": true,\n \"caCert\": \"<string>\",\n \"clientCert\": \"<string>\",\n \"clientKey\": \"<string>\"\n },\n \"description\": \"<string>\",\n \"projectIds\": [\n \"<string>\"\n ],\n \"identifierTypes\": [\n {\n \"id\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"assignmentQueries\": [\n {\n \"name\": \"<string>\",\n \"sql\": \"<string>\",\n \"id\": \"<string>\",\n \"description\": \"<string>\",\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"identifierType\": \"<string>\",\n \"includesNameColumns\": true,\n \"dimensionColumns\": [\n \"<string>\"\n ],\n \"projects\": [\n \"<string>\"\n ],\n \"columnMapping\": {\n \"experimentIdColumn\": \"<string>\",\n \"variationIdColumn\": \"<string>\",\n \"timestampColumn\": \"<string>\",\n \"userIdColumns\": {},\n \"experimentNameColumn\": \"<string>\",\n \"variationNameColumn\": \"<string>\"\n }\n }\n ],\n \"identifierJoinQueries\": [\n {\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\"\n }\n ],\n \"mixpanelSettings\": {\n \"viewedExperimentEventName\": \"<string>\",\n \"experimentIdProperty\": \"<string>\",\n \"variationIdProperty\": \"<string>\",\n \"extraUserIdProperty\": \"<string>\"\n },\n \"pipelineSettings\": {\n \"allowWriting\": true,\n \"writeDatabase\": \"<string>\",\n \"writeDataset\": \"<string>\",\n \"unitsTableRetentionHours\": 123,\n \"unitsTableDeletion\": true,\n \"includedExperimentIds\": [\n \"<string>\"\n ],\n \"excludedExperimentIds\": [\n \"<string>\"\n ],\n \"incrementalOptInExperimentIds\": [\n \"<string>\"\n ]\n },\n \"maxConcurrentQueries\": 1,\n \"queryCacheTTLMins\": 1\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.growthbook.io/api/v1/data-sources")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"connection\": {\n \"type\": \"postgres\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"user\": \"<string>\",\n \"password\": \"<string>\",\n \"defaultSchema\": \"<string>\",\n \"ssl\": true,\n \"caCert\": \"<string>\",\n \"clientCert\": \"<string>\",\n \"clientKey\": \"<string>\"\n },\n \"description\": \"<string>\",\n \"projectIds\": [\n \"<string>\"\n ],\n \"identifierTypes\": [\n {\n \"id\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"assignmentQueries\": [\n {\n \"name\": \"<string>\",\n \"sql\": \"<string>\",\n \"id\": \"<string>\",\n \"description\": \"<string>\",\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"identifierType\": \"<string>\",\n \"includesNameColumns\": true,\n \"dimensionColumns\": [\n \"<string>\"\n ],\n \"projects\": [\n \"<string>\"\n ],\n \"columnMapping\": {\n \"experimentIdColumn\": \"<string>\",\n \"variationIdColumn\": \"<string>\",\n \"timestampColumn\": \"<string>\",\n \"userIdColumns\": {},\n \"experimentNameColumn\": \"<string>\",\n \"variationNameColumn\": \"<string>\"\n }\n }\n ],\n \"identifierJoinQueries\": [\n {\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\"\n }\n ],\n \"mixpanelSettings\": {\n \"viewedExperimentEventName\": \"<string>\",\n \"experimentIdProperty\": \"<string>\",\n \"variationIdProperty\": \"<string>\",\n \"extraUserIdProperty\": \"<string>\"\n },\n \"pipelineSettings\": {\n \"allowWriting\": true,\n \"writeDatabase\": \"<string>\",\n \"writeDataset\": \"<string>\",\n \"unitsTableRetentionHours\": 123,\n \"unitsTableDeletion\": true,\n \"includedExperimentIds\": [\n \"<string>\"\n ],\n \"excludedExperimentIds\": [\n \"<string>\"\n ],\n \"incrementalOptInExperimentIds\": [\n \"<string>\"\n ]\n },\n \"maxConcurrentQueries\": 1,\n \"queryCacheTTLMins\": 1\n}"
response = http.request(request)
puts response.read_body{
"dataSource": {
"id": "<string>",
"dateCreated": "2023-11-07T05:31:56Z",
"dateUpdated": "2023-11-07T05:31:56Z",
"type": "<string>",
"name": "<string>",
"description": "<string>",
"projectIds": [
"<string>"
],
"eventTracker": "<string>",
"identifierTypes": [
{
"id": "<string>",
"description": "<string>"
}
],
"assignmentQueries": [
{
"id": "<string>",
"name": "<string>",
"description": "<string>",
"identifierTypes": [
"<string>"
],
"identifierType": "<string>",
"sql": "<string>",
"includesNameColumns": true,
"dimensionColumns": [
"<string>"
],
"projects": [
"<string>"
],
"columnMapping": {
"experimentIdColumn": "<string>",
"variationIdColumn": "<string>",
"timestampColumn": "<string>",
"userIdColumns": {},
"experimentNameColumn": "<string>",
"variationNameColumn": "<string>"
},
"error": "<string>"
}
],
"identifierJoinQueries": [
{
"identifierTypes": [
"<string>"
],
"sql": "<string>"
}
],
"mixpanelSettings": {
"viewedExperimentEventName": "<string>",
"experimentIdProperty": "<string>",
"variationIdProperty": "<string>",
"extraUserIdProperty": "<string>"
},
"pipelineSettings": {
"allowWriting": true,
"mode": "ephemeral",
"writeDataset": "<string>",
"unitsTableRetentionHours": 123,
"writeDatabase": "<string>",
"unitsTableDeletion": true,
"includedExperimentIds": [
"<string>"
],
"excludedExperimentIds": [
"<string>"
],
"incrementalOptInExperimentIds": [
"<string>"
]
},
"maxConcurrentQueries": 1,
"queryCacheTTLMins": 1
}
}{
"confirmation": {
"id": "<string>",
"status": "pending",
"actions": [
{
"action": "feature.create",
"environments": [
"<string>"
]
}
],
"summary": "<string>",
"url": "<string>",
"expiresAt": "<string>",
"response": {
"status": 123,
"body": "<unknown>"
},
"note": "<string>"
},
"message": "<string>"
}Authorizations
bearerAuthbasicAuth
Pass your API key as the Bearer token. See Authentication.
Body
application/json
Credentials are stored encrypted and never returned
- Postgres Connection
- Redshift Connection
- Vertica Connection
- Mysql Connection
- Mssql Connection
- Snowflake Connection
- Big Query Connection
- Athena Connection
- Presto Connection
- Databricks Connection
- Click House Connection
- Mixpanel Connection
- Adobe Experience Platform Query Service Connection
Show child attributes
Show child attributes
Merged into the stored settings: fields left out keep their values, but any change must leave allowWriting, mode, writeDataset and unitsTableRetentionHours set, with a non-empty writeDataset when allowWriting is true. Send [] to clear excludedExperimentIds or incrementalOptInExperimentIds, and includedExperimentIds: null to apply the mode to every experiment again ([] applies it to none).
Show child attributes
Show child attributes
Was this page helpful?
⌘I
cURL
curl -X POST 'https://api.growthbook.io/api/v1/data-sources' \
-H 'Authorization: Bearer YOUR_API_KEY'import requests
url = "https://api.growthbook.io/api/v1/data-sources"
payload = {
"name": "<string>",
"connection": {
"type": "postgres",
"host": "<string>",
"port": 123,
"database": "<string>",
"user": "<string>",
"password": "<string>",
"defaultSchema": "<string>",
"ssl": True,
"caCert": "<string>",
"clientCert": "<string>",
"clientKey": "<string>"
},
"description": "<string>",
"projectIds": ["<string>"],
"identifierTypes": [
{
"id": "<string>",
"description": "<string>"
}
],
"assignmentQueries": [
{
"name": "<string>",
"sql": "<string>",
"id": "<string>",
"description": "<string>",
"identifierTypes": ["<string>"],
"identifierType": "<string>",
"includesNameColumns": True,
"dimensionColumns": ["<string>"],
"projects": ["<string>"],
"columnMapping": {
"experimentIdColumn": "<string>",
"variationIdColumn": "<string>",
"timestampColumn": "<string>",
"userIdColumns": {},
"experimentNameColumn": "<string>",
"variationNameColumn": "<string>"
}
}
],
"identifierJoinQueries": [
{
"identifierTypes": ["<string>"],
"sql": "<string>"
}
],
"mixpanelSettings": {
"viewedExperimentEventName": "<string>",
"experimentIdProperty": "<string>",
"variationIdProperty": "<string>",
"extraUserIdProperty": "<string>"
},
"pipelineSettings": {
"allowWriting": True,
"writeDatabase": "<string>",
"writeDataset": "<string>",
"unitsTableRetentionHours": 123,
"unitsTableDeletion": True,
"includedExperimentIds": ["<string>"],
"excludedExperimentIds": ["<string>"],
"incrementalOptInExperimentIds": ["<string>"]
},
"maxConcurrentQueries": 1,
"queryCacheTTLMins": 1
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
name: '<string>',
connection: {
type: 'postgres',
host: '<string>',
port: 123,
database: '<string>',
user: '<string>',
password: '<string>',
defaultSchema: '<string>',
ssl: true,
caCert: '<string>',
clientCert: '<string>',
clientKey: '<string>'
},
description: '<string>',
projectIds: ['<string>'],
identifierTypes: [{id: '<string>', description: '<string>'}],
assignmentQueries: [
{
name: '<string>',
sql: '<string>',
id: '<string>',
description: '<string>',
identifierTypes: ['<string>'],
identifierType: '<string>',
includesNameColumns: true,
dimensionColumns: ['<string>'],
projects: ['<string>'],
columnMapping: {
experimentIdColumn: '<string>',
variationIdColumn: '<string>',
timestampColumn: '<string>',
userIdColumns: {},
experimentNameColumn: '<string>',
variationNameColumn: '<string>'
}
}
],
identifierJoinQueries: [{identifierTypes: ['<string>'], sql: '<string>'}],
mixpanelSettings: {
viewedExperimentEventName: '<string>',
experimentIdProperty: '<string>',
variationIdProperty: '<string>',
extraUserIdProperty: '<string>'
},
pipelineSettings: {
allowWriting: true,
writeDatabase: '<string>',
writeDataset: '<string>',
unitsTableRetentionHours: 123,
unitsTableDeletion: true,
includedExperimentIds: ['<string>'],
excludedExperimentIds: ['<string>'],
incrementalOptInExperimentIds: ['<string>']
},
maxConcurrentQueries: 1,
queryCacheTTLMins: 1
})
};
fetch('https://api.growthbook.io/api/v1/data-sources', 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.growthbook.io/api/v1/data-sources",
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([
'name' => '<string>',
'connection' => [
'type' => 'postgres',
'host' => '<string>',
'port' => 123,
'database' => '<string>',
'user' => '<string>',
'password' => '<string>',
'defaultSchema' => '<string>',
'ssl' => true,
'caCert' => '<string>',
'clientCert' => '<string>',
'clientKey' => '<string>'
],
'description' => '<string>',
'projectIds' => [
'<string>'
],
'identifierTypes' => [
[
'id' => '<string>',
'description' => '<string>'
]
],
'assignmentQueries' => [
[
'name' => '<string>',
'sql' => '<string>',
'id' => '<string>',
'description' => '<string>',
'identifierTypes' => [
'<string>'
],
'identifierType' => '<string>',
'includesNameColumns' => true,
'dimensionColumns' => [
'<string>'
],
'projects' => [
'<string>'
],
'columnMapping' => [
'experimentIdColumn' => '<string>',
'variationIdColumn' => '<string>',
'timestampColumn' => '<string>',
'userIdColumns' => [
],
'experimentNameColumn' => '<string>',
'variationNameColumn' => '<string>'
]
]
],
'identifierJoinQueries' => [
[
'identifierTypes' => [
'<string>'
],
'sql' => '<string>'
]
],
'mixpanelSettings' => [
'viewedExperimentEventName' => '<string>',
'experimentIdProperty' => '<string>',
'variationIdProperty' => '<string>',
'extraUserIdProperty' => '<string>'
],
'pipelineSettings' => [
'allowWriting' => true,
'writeDatabase' => '<string>',
'writeDataset' => '<string>',
'unitsTableRetentionHours' => 123,
'unitsTableDeletion' => true,
'includedExperimentIds' => [
'<string>'
],
'excludedExperimentIds' => [
'<string>'
],
'incrementalOptInExperimentIds' => [
'<string>'
]
],
'maxConcurrentQueries' => 1,
'queryCacheTTLMins' => 1
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$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.growthbook.io/api/v1/data-sources"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"connection\": {\n \"type\": \"postgres\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"user\": \"<string>\",\n \"password\": \"<string>\",\n \"defaultSchema\": \"<string>\",\n \"ssl\": true,\n \"caCert\": \"<string>\",\n \"clientCert\": \"<string>\",\n \"clientKey\": \"<string>\"\n },\n \"description\": \"<string>\",\n \"projectIds\": [\n \"<string>\"\n ],\n \"identifierTypes\": [\n {\n \"id\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"assignmentQueries\": [\n {\n \"name\": \"<string>\",\n \"sql\": \"<string>\",\n \"id\": \"<string>\",\n \"description\": \"<string>\",\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"identifierType\": \"<string>\",\n \"includesNameColumns\": true,\n \"dimensionColumns\": [\n \"<string>\"\n ],\n \"projects\": [\n \"<string>\"\n ],\n \"columnMapping\": {\n \"experimentIdColumn\": \"<string>\",\n \"variationIdColumn\": \"<string>\",\n \"timestampColumn\": \"<string>\",\n \"userIdColumns\": {},\n \"experimentNameColumn\": \"<string>\",\n \"variationNameColumn\": \"<string>\"\n }\n }\n ],\n \"identifierJoinQueries\": [\n {\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\"\n }\n ],\n \"mixpanelSettings\": {\n \"viewedExperimentEventName\": \"<string>\",\n \"experimentIdProperty\": \"<string>\",\n \"variationIdProperty\": \"<string>\",\n \"extraUserIdProperty\": \"<string>\"\n },\n \"pipelineSettings\": {\n \"allowWriting\": true,\n \"writeDatabase\": \"<string>\",\n \"writeDataset\": \"<string>\",\n \"unitsTableRetentionHours\": 123,\n \"unitsTableDeletion\": true,\n \"includedExperimentIds\": [\n \"<string>\"\n ],\n \"excludedExperimentIds\": [\n \"<string>\"\n ],\n \"incrementalOptInExperimentIds\": [\n \"<string>\"\n ]\n },\n \"maxConcurrentQueries\": 1,\n \"queryCacheTTLMins\": 1\n}")
req, _ := http.NewRequest("POST", url, payload)
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.growthbook.io/api/v1/data-sources")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"connection\": {\n \"type\": \"postgres\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"user\": \"<string>\",\n \"password\": \"<string>\",\n \"defaultSchema\": \"<string>\",\n \"ssl\": true,\n \"caCert\": \"<string>\",\n \"clientCert\": \"<string>\",\n \"clientKey\": \"<string>\"\n },\n \"description\": \"<string>\",\n \"projectIds\": [\n \"<string>\"\n ],\n \"identifierTypes\": [\n {\n \"id\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"assignmentQueries\": [\n {\n \"name\": \"<string>\",\n \"sql\": \"<string>\",\n \"id\": \"<string>\",\n \"description\": \"<string>\",\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"identifierType\": \"<string>\",\n \"includesNameColumns\": true,\n \"dimensionColumns\": [\n \"<string>\"\n ],\n \"projects\": [\n \"<string>\"\n ],\n \"columnMapping\": {\n \"experimentIdColumn\": \"<string>\",\n \"variationIdColumn\": \"<string>\",\n \"timestampColumn\": \"<string>\",\n \"userIdColumns\": {},\n \"experimentNameColumn\": \"<string>\",\n \"variationNameColumn\": \"<string>\"\n }\n }\n ],\n \"identifierJoinQueries\": [\n {\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\"\n }\n ],\n \"mixpanelSettings\": {\n \"viewedExperimentEventName\": \"<string>\",\n \"experimentIdProperty\": \"<string>\",\n \"variationIdProperty\": \"<string>\",\n \"extraUserIdProperty\": \"<string>\"\n },\n \"pipelineSettings\": {\n \"allowWriting\": true,\n \"writeDatabase\": \"<string>\",\n \"writeDataset\": \"<string>\",\n \"unitsTableRetentionHours\": 123,\n \"unitsTableDeletion\": true,\n \"includedExperimentIds\": [\n \"<string>\"\n ],\n \"excludedExperimentIds\": [\n \"<string>\"\n ],\n \"incrementalOptInExperimentIds\": [\n \"<string>\"\n ]\n },\n \"maxConcurrentQueries\": 1,\n \"queryCacheTTLMins\": 1\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.growthbook.io/api/v1/data-sources")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"connection\": {\n \"type\": \"postgres\",\n \"host\": \"<string>\",\n \"port\": 123,\n \"database\": \"<string>\",\n \"user\": \"<string>\",\n \"password\": \"<string>\",\n \"defaultSchema\": \"<string>\",\n \"ssl\": true,\n \"caCert\": \"<string>\",\n \"clientCert\": \"<string>\",\n \"clientKey\": \"<string>\"\n },\n \"description\": \"<string>\",\n \"projectIds\": [\n \"<string>\"\n ],\n \"identifierTypes\": [\n {\n \"id\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"assignmentQueries\": [\n {\n \"name\": \"<string>\",\n \"sql\": \"<string>\",\n \"id\": \"<string>\",\n \"description\": \"<string>\",\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"identifierType\": \"<string>\",\n \"includesNameColumns\": true,\n \"dimensionColumns\": [\n \"<string>\"\n ],\n \"projects\": [\n \"<string>\"\n ],\n \"columnMapping\": {\n \"experimentIdColumn\": \"<string>\",\n \"variationIdColumn\": \"<string>\",\n \"timestampColumn\": \"<string>\",\n \"userIdColumns\": {},\n \"experimentNameColumn\": \"<string>\",\n \"variationNameColumn\": \"<string>\"\n }\n }\n ],\n \"identifierJoinQueries\": [\n {\n \"identifierTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\"\n }\n ],\n \"mixpanelSettings\": {\n \"viewedExperimentEventName\": \"<string>\",\n \"experimentIdProperty\": \"<string>\",\n \"variationIdProperty\": \"<string>\",\n \"extraUserIdProperty\": \"<string>\"\n },\n \"pipelineSettings\": {\n \"allowWriting\": true,\n \"writeDatabase\": \"<string>\",\n \"writeDataset\": \"<string>\",\n \"unitsTableRetentionHours\": 123,\n \"unitsTableDeletion\": true,\n \"includedExperimentIds\": [\n \"<string>\"\n ],\n \"excludedExperimentIds\": [\n \"<string>\"\n ],\n \"incrementalOptInExperimentIds\": [\n \"<string>\"\n ]\n },\n \"maxConcurrentQueries\": 1,\n \"queryCacheTTLMins\": 1\n}"
response = http.request(request)
puts response.read_body{
"dataSource": {
"id": "<string>",
"dateCreated": "2023-11-07T05:31:56Z",
"dateUpdated": "2023-11-07T05:31:56Z",
"type": "<string>",
"name": "<string>",
"description": "<string>",
"projectIds": [
"<string>"
],
"eventTracker": "<string>",
"identifierTypes": [
{
"id": "<string>",
"description": "<string>"
}
],
"assignmentQueries": [
{
"id": "<string>",
"name": "<string>",
"description": "<string>",
"identifierTypes": [
"<string>"
],
"identifierType": "<string>",
"sql": "<string>",
"includesNameColumns": true,
"dimensionColumns": [
"<string>"
],
"projects": [
"<string>"
],
"columnMapping": {
"experimentIdColumn": "<string>",
"variationIdColumn": "<string>",
"timestampColumn": "<string>",
"userIdColumns": {},
"experimentNameColumn": "<string>",
"variationNameColumn": "<string>"
},
"error": "<string>"
}
],
"identifierJoinQueries": [
{
"identifierTypes": [
"<string>"
],
"sql": "<string>"
}
],
"mixpanelSettings": {
"viewedExperimentEventName": "<string>",
"experimentIdProperty": "<string>",
"variationIdProperty": "<string>",
"extraUserIdProperty": "<string>"
},
"pipelineSettings": {
"allowWriting": true,
"mode": "ephemeral",
"writeDataset": "<string>",
"unitsTableRetentionHours": 123,
"writeDatabase": "<string>",
"unitsTableDeletion": true,
"includedExperimentIds": [
"<string>"
],
"excludedExperimentIds": [
"<string>"
],
"incrementalOptInExperimentIds": [
"<string>"
]
},
"maxConcurrentQueries": 1,
"queryCacheTTLMins": 1
}
}{
"confirmation": {
"id": "<string>",
"status": "pending",
"actions": [
{
"action": "feature.create",
"environments": [
"<string>"
]
}
],
"summary": "<string>",
"url": "<string>",
"expiresAt": "<string>",
"response": {
"status": 123,
"body": "<unknown>"
},
"note": "<string>"
},
"message": "<string>"
}
