Create a single fact table
POST
/
v1
/
fact-tables
cURL
curl -X POST 'https://api.growthbook.io/api/v1/fact-tables' \
-H 'Authorization: Bearer YOUR_API_KEY' \
-H 'Content-Type: application/json' \
-d '{"name":"Orders","datasource":"ds_abc123","userIdTypes":["id"],"sql":"SELECT * FROM orders"}'import requests
url = "https://api.growthbook.io/api/v1/fact-tables"
payload = {
"name": "<string>",
"datasource": "<string>",
"userIdTypes": ["<string>"],
"sql": "<string>",
"description": "<string>",
"owner": "<string>",
"projects": ["<string>"],
"tags": ["<string>"],
"userIdColumns": {},
"timestampColumn": "<string>",
"eventName": "<string>",
"columns": [
{
"column": "<string>",
"jsonFields": {},
"name": "<string>",
"description": "<string>",
"alwaysInlineFilter": False,
"conditionalInlineFilters": {},
"deleted": False,
"isAutoSliceColumn": False,
"autoSlices": ["<string>"],
"lockedAutoSlices": ["<string>"],
"isVirtual": False,
"sql": "<string>"
}
]
}
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>',
datasource: '<string>',
userIdTypes: ['<string>'],
sql: '<string>',
description: '<string>',
owner: '<string>',
projects: ['<string>'],
tags: ['<string>'],
userIdColumns: {},
timestampColumn: '<string>',
eventName: '<string>',
columns: [
{
column: '<string>',
jsonFields: {},
name: '<string>',
description: '<string>',
alwaysInlineFilter: false,
conditionalInlineFilters: {},
deleted: false,
isAutoSliceColumn: false,
autoSlices: ['<string>'],
lockedAutoSlices: ['<string>'],
isVirtual: false,
sql: '<string>'
}
]
})
};
fetch('https://api.growthbook.io/api/v1/fact-tables', 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/fact-tables",
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>',
'datasource' => '<string>',
'userIdTypes' => [
'<string>'
],
'sql' => '<string>',
'description' => '<string>',
'owner' => '<string>',
'projects' => [
'<string>'
],
'tags' => [
'<string>'
],
'userIdColumns' => [
],
'timestampColumn' => '<string>',
'eventName' => '<string>',
'columns' => [
[
'column' => '<string>',
'jsonFields' => [
],
'name' => '<string>',
'description' => '<string>',
'alwaysInlineFilter' => false,
'conditionalInlineFilters' => [
],
'deleted' => false,
'isAutoSliceColumn' => false,
'autoSlices' => [
'<string>'
],
'lockedAutoSlices' => [
'<string>'
],
'isVirtual' => false,
'sql' => '<string>'
]
]
]),
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/fact-tables"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"datasource\": \"<string>\",\n \"userIdTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\",\n \"description\": \"<string>\",\n \"owner\": \"<string>\",\n \"projects\": [\n \"<string>\"\n ],\n \"tags\": [\n \"<string>\"\n ],\n \"userIdColumns\": {},\n \"timestampColumn\": \"<string>\",\n \"eventName\": \"<string>\",\n \"columns\": [\n {\n \"column\": \"<string>\",\n \"jsonFields\": {},\n \"name\": \"<string>\",\n \"description\": \"<string>\",\n \"alwaysInlineFilter\": false,\n \"conditionalInlineFilters\": {},\n \"deleted\": false,\n \"isAutoSliceColumn\": false,\n \"autoSlices\": [\n \"<string>\"\n ],\n \"lockedAutoSlices\": [\n \"<string>\"\n ],\n \"isVirtual\": false,\n \"sql\": \"<string>\"\n }\n ]\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/fact-tables")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"datasource\": \"<string>\",\n \"userIdTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\",\n \"description\": \"<string>\",\n \"owner\": \"<string>\",\n \"projects\": [\n \"<string>\"\n ],\n \"tags\": [\n \"<string>\"\n ],\n \"userIdColumns\": {},\n \"timestampColumn\": \"<string>\",\n \"eventName\": \"<string>\",\n \"columns\": [\n {\n \"column\": \"<string>\",\n \"jsonFields\": {},\n \"name\": \"<string>\",\n \"description\": \"<string>\",\n \"alwaysInlineFilter\": false,\n \"conditionalInlineFilters\": {},\n \"deleted\": false,\n \"isAutoSliceColumn\": false,\n \"autoSlices\": [\n \"<string>\"\n ],\n \"lockedAutoSlices\": [\n \"<string>\"\n ],\n \"isVirtual\": false,\n \"sql\": \"<string>\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.growthbook.io/api/v1/fact-tables")
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 \"datasource\": \"<string>\",\n \"userIdTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\",\n \"description\": \"<string>\",\n \"owner\": \"<string>\",\n \"projects\": [\n \"<string>\"\n ],\n \"tags\": [\n \"<string>\"\n ],\n \"userIdColumns\": {},\n \"timestampColumn\": \"<string>\",\n \"eventName\": \"<string>\",\n \"columns\": [\n {\n \"column\": \"<string>\",\n \"jsonFields\": {},\n \"name\": \"<string>\",\n \"description\": \"<string>\",\n \"alwaysInlineFilter\": false,\n \"conditionalInlineFilters\": {},\n \"deleted\": false,\n \"isAutoSliceColumn\": false,\n \"autoSlices\": [\n \"<string>\"\n ],\n \"lockedAutoSlices\": [\n \"<string>\"\n ],\n \"isVirtual\": false,\n \"sql\": \"<string>\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"factTable": {
"id": "<string>",
"name": "<string>",
"description": "<string>",
"owner": "<string>",
"projects": [
"<string>"
],
"tags": [
"<string>"
],
"datasource": "<string>",
"userIdTypes": [
"<string>"
],
"sql": "<string>",
"managedBy": "",
"dateCreated": "2023-11-07T05:31:56Z",
"dateUpdated": "2023-11-07T05:31:56Z",
"ownerEmail": "<string>",
"userIdColumns": {},
"aggregatedFactTableSettings": {
"idTypes": [
"<string>"
],
"updateTime": {
"time": "<string>",
"timezone": "<string>"
},
"lookbackWindow": 123,
"restateChunkDays": 4
},
"timestampColumn": "<string>",
"eventName": "<string>",
"columns": [
{
"column": "<string>",
"datatype": "number",
"dataTypeFromWarehouse": "number",
"numberFormat": "",
"jsonFields": {},
"name": "<string>",
"description": "<string>",
"alwaysInlineFilter": false,
"conditionalInlineFilters": {},
"deleted": false,
"isAutoSliceColumn": false,
"autoSlices": [
"<string>"
],
"lockedAutoSlices": [
"<string>"
],
"isVirtual": false,
"sql": "<string>",
"topValues": [
"<string>"
],
"topValuesDate": "2023-11-07T05:31:56Z",
"dateCreated": "2023-11-07T05:31:56Z",
"dateUpdated": "2023-11-07T05:31:56Z"
}
],
"columnsError": "<string>",
"columnRefreshPending": true,
"archived": true,
"autoSliceUpdatesEnabled": true
}
}{
"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
Maps an identifier type to the column holding it, for SQL that does not alias its columns to the identifier type names, e.g. {"user_id": "userId"}. May also be a single-level field path into a JSON column (properties.userId). Unmapped types use the identifier type name as the column name.
Show child attributes
Show child attributes
Was this page helpful?
⌘I
cURL
curl -X POST 'https://api.growthbook.io/api/v1/fact-tables' \
-H 'Authorization: Bearer YOUR_API_KEY' \
-H 'Content-Type: application/json' \
-d '{"name":"Orders","datasource":"ds_abc123","userIdTypes":["id"],"sql":"SELECT * FROM orders"}'import requests
url = "https://api.growthbook.io/api/v1/fact-tables"
payload = {
"name": "<string>",
"datasource": "<string>",
"userIdTypes": ["<string>"],
"sql": "<string>",
"description": "<string>",
"owner": "<string>",
"projects": ["<string>"],
"tags": ["<string>"],
"userIdColumns": {},
"timestampColumn": "<string>",
"eventName": "<string>",
"columns": [
{
"column": "<string>",
"jsonFields": {},
"name": "<string>",
"description": "<string>",
"alwaysInlineFilter": False,
"conditionalInlineFilters": {},
"deleted": False,
"isAutoSliceColumn": False,
"autoSlices": ["<string>"],
"lockedAutoSlices": ["<string>"],
"isVirtual": False,
"sql": "<string>"
}
]
}
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>',
datasource: '<string>',
userIdTypes: ['<string>'],
sql: '<string>',
description: '<string>',
owner: '<string>',
projects: ['<string>'],
tags: ['<string>'],
userIdColumns: {},
timestampColumn: '<string>',
eventName: '<string>',
columns: [
{
column: '<string>',
jsonFields: {},
name: '<string>',
description: '<string>',
alwaysInlineFilter: false,
conditionalInlineFilters: {},
deleted: false,
isAutoSliceColumn: false,
autoSlices: ['<string>'],
lockedAutoSlices: ['<string>'],
isVirtual: false,
sql: '<string>'
}
]
})
};
fetch('https://api.growthbook.io/api/v1/fact-tables', 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/fact-tables",
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>',
'datasource' => '<string>',
'userIdTypes' => [
'<string>'
],
'sql' => '<string>',
'description' => '<string>',
'owner' => '<string>',
'projects' => [
'<string>'
],
'tags' => [
'<string>'
],
'userIdColumns' => [
],
'timestampColumn' => '<string>',
'eventName' => '<string>',
'columns' => [
[
'column' => '<string>',
'jsonFields' => [
],
'name' => '<string>',
'description' => '<string>',
'alwaysInlineFilter' => false,
'conditionalInlineFilters' => [
],
'deleted' => false,
'isAutoSliceColumn' => false,
'autoSlices' => [
'<string>'
],
'lockedAutoSlices' => [
'<string>'
],
'isVirtual' => false,
'sql' => '<string>'
]
]
]),
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/fact-tables"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"datasource\": \"<string>\",\n \"userIdTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\",\n \"description\": \"<string>\",\n \"owner\": \"<string>\",\n \"projects\": [\n \"<string>\"\n ],\n \"tags\": [\n \"<string>\"\n ],\n \"userIdColumns\": {},\n \"timestampColumn\": \"<string>\",\n \"eventName\": \"<string>\",\n \"columns\": [\n {\n \"column\": \"<string>\",\n \"jsonFields\": {},\n \"name\": \"<string>\",\n \"description\": \"<string>\",\n \"alwaysInlineFilter\": false,\n \"conditionalInlineFilters\": {},\n \"deleted\": false,\n \"isAutoSliceColumn\": false,\n \"autoSlices\": [\n \"<string>\"\n ],\n \"lockedAutoSlices\": [\n \"<string>\"\n ],\n \"isVirtual\": false,\n \"sql\": \"<string>\"\n }\n ]\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/fact-tables")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"datasource\": \"<string>\",\n \"userIdTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\",\n \"description\": \"<string>\",\n \"owner\": \"<string>\",\n \"projects\": [\n \"<string>\"\n ],\n \"tags\": [\n \"<string>\"\n ],\n \"userIdColumns\": {},\n \"timestampColumn\": \"<string>\",\n \"eventName\": \"<string>\",\n \"columns\": [\n {\n \"column\": \"<string>\",\n \"jsonFields\": {},\n \"name\": \"<string>\",\n \"description\": \"<string>\",\n \"alwaysInlineFilter\": false,\n \"conditionalInlineFilters\": {},\n \"deleted\": false,\n \"isAutoSliceColumn\": false,\n \"autoSlices\": [\n \"<string>\"\n ],\n \"lockedAutoSlices\": [\n \"<string>\"\n ],\n \"isVirtual\": false,\n \"sql\": \"<string>\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.growthbook.io/api/v1/fact-tables")
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 \"datasource\": \"<string>\",\n \"userIdTypes\": [\n \"<string>\"\n ],\n \"sql\": \"<string>\",\n \"description\": \"<string>\",\n \"owner\": \"<string>\",\n \"projects\": [\n \"<string>\"\n ],\n \"tags\": [\n \"<string>\"\n ],\n \"userIdColumns\": {},\n \"timestampColumn\": \"<string>\",\n \"eventName\": \"<string>\",\n \"columns\": [\n {\n \"column\": \"<string>\",\n \"jsonFields\": {},\n \"name\": \"<string>\",\n \"description\": \"<string>\",\n \"alwaysInlineFilter\": false,\n \"conditionalInlineFilters\": {},\n \"deleted\": false,\n \"isAutoSliceColumn\": false,\n \"autoSlices\": [\n \"<string>\"\n ],\n \"lockedAutoSlices\": [\n \"<string>\"\n ],\n \"isVirtual\": false,\n \"sql\": \"<string>\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"factTable": {
"id": "<string>",
"name": "<string>",
"description": "<string>",
"owner": "<string>",
"projects": [
"<string>"
],
"tags": [
"<string>"
],
"datasource": "<string>",
"userIdTypes": [
"<string>"
],
"sql": "<string>",
"managedBy": "",
"dateCreated": "2023-11-07T05:31:56Z",
"dateUpdated": "2023-11-07T05:31:56Z",
"ownerEmail": "<string>",
"userIdColumns": {},
"aggregatedFactTableSettings": {
"idTypes": [
"<string>"
],
"updateTime": {
"time": "<string>",
"timezone": "<string>"
},
"lookbackWindow": 123,
"restateChunkDays": 4
},
"timestampColumn": "<string>",
"eventName": "<string>",
"columns": [
{
"column": "<string>",
"datatype": "number",
"dataTypeFromWarehouse": "number",
"numberFormat": "",
"jsonFields": {},
"name": "<string>",
"description": "<string>",
"alwaysInlineFilter": false,
"conditionalInlineFilters": {},
"deleted": false,
"isAutoSliceColumn": false,
"autoSlices": [
"<string>"
],
"lockedAutoSlices": [
"<string>"
],
"isVirtual": false,
"sql": "<string>",
"topValues": [
"<string>"
],
"topValuesDate": "2023-11-07T05:31:56Z",
"dateCreated": "2023-11-07T05:31:56Z",
"dateUpdated": "2023-11-07T05:31:56Z"
}
],
"columnsError": "<string>",
"columnRefreshPending": true,
"archived": true,
"autoSliceUpdatesEnabled": true
}
}{
"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>"
}
