Create AssignmentTable

POST

assignmentTables

curl --request POST \
  --url https://metrics.eu.confidence.dev/v1/assignmentTables \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumn": {
    "name": "<string>",
    "repeated": true
  },
  "timestampColumn": {
    "name": "<string>",
    "repeated": true
  },
  "exposureKeyColumn": {
    "name": "<string>",
    "repeated": true
  },
  "variantKeyColumn": {
    "name": "<string>",
    "repeated": true
  },
  "name": "<string>",
  "description": "<string>",
  "dimensions": [
    {
      "name": "<string>",
      "repeated": true
    }
  ],
  "assignmentDataDeliveredUntilTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>"
}
'

import requests

url = "https://metrics.eu.confidence.dev/v1/assignmentTables"

payload = {
    "sql": "<string>",
    "displayName": "<string>",
    "entityColumn": {
        "name": "<string>",
        "repeated": True
    },
    "timestampColumn": {
        "name": "<string>",
        "repeated": True
    },
    "exposureKeyColumn": {
        "name": "<string>",
        "repeated": True
    },
    "variantKeyColumn": {
        "name": "<string>",
        "repeated": True
    },
    "name": "<string>",
    "description": "<string>",
    "dimensions": [
        {
            "name": "<string>",
            "repeated": True
        }
    ],
    "assignmentDataDeliveredUntilTime": {},
    "labels": [{}],
    "owner": "<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({
    sql: '<string>',
    displayName: '<string>',
    entityColumn: {name: '<string>', repeated: true},
    timestampColumn: {name: '<string>', repeated: true},
    exposureKeyColumn: {name: '<string>', repeated: true},
    variantKeyColumn: {name: '<string>', repeated: true},
    name: '<string>',
    description: '<string>',
    dimensions: [{name: '<string>', repeated: true}],
    assignmentDataDeliveredUntilTime: {},
    labels: [{}],
    owner: '<string>'
  })
};

fetch('https://metrics.eu.confidence.dev/v1/assignmentTables', 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://metrics.eu.confidence.dev/v1/assignmentTables",
  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([
    'sql' => '<string>',
    'displayName' => '<string>',
    'entityColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'timestampColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'exposureKeyColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'variantKeyColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'name' => '<string>',
    'description' => '<string>',
    'dimensions' => [
        [
                'name' => '<string>',
                'repeated' => true
        ]
    ],
    'assignmentDataDeliveredUntilTime' => [
        
    ],
    'labels' => [
        [
                
        ]
    ],
    'owner' => '<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://metrics.eu.confidence.dev/v1/assignmentTables"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entityColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"timestampColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"variantKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"assignmentDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\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://metrics.eu.confidence.dev/v1/assignmentTables")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entityColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"timestampColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"variantKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"assignmentDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://metrics.eu.confidence.dev/v1/assignmentTables")

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  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entityColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"timestampColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"variantKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"assignmentDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "timestampColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "exposureKeyColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "variantKeyColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "timestampTruncation": {
    "window": "TRUNCATION_WINDOW_UNSPECIFIED",
    "behaviour": "TRUNCATION_BEHAVIOR_UNSPECIFIED",
    "timeZone": "TRUNCATION_TIME_ZONE_UNSPECIFIED"
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "assignmentDataDeliveredUntilTime": {},
  "partitionedUpdateStrategyState": {
    "currentPartitionLastCheckTime": {},
    "existsCheckDuration": {},
    "state": "STATE_UNSPECIFIED",
    "usualLateness": {},
    "count": 123
  },
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "dataDeliveredUntilUpdateStrategyConfig": {
    "strategy": "STRATEGY_UNSPECIFIED",
    "disableEmptyPartitions": true,
    "automaticUpdateConfig": {
      "commitDelay": {},
      "incrementDuration": {},
      "changeThreshold": {
        "value": "<string>"
      }
    },
    "dailyUpdateConfig": {
      "maxZeroDuration": {}
    },
    "hourlyUpdateConfig": {
      "maxZeroDuration": {}
    }
  },
  "deleteTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>",
  "systemCreated": true
}

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

assignmentTableId

string

The id to the give the created assignment table. If a not set a random one will be generated.

Body

application/json

sql

string

required

A data warehouse-specific query to get the data of the assignment table.

displayName

string

required

Human friendly name of the assignment table.

entityColumn

object

required

The column of the assignment table that represents the entity

Show child attributes

timestampColumn

object

required

The column of the assignment table that represents the time the assignment occurred.

Show child attributes

exposureKeyColumn

object

required

The column of the table that represents what the group of variants that the entity was assigned to, this would typically be the rule id or the flag name.

Show child attributes

variantKeyColumn

object

required

The column of the table that represents the variant that was assigned.

Show child attributes

name

string

Unique identifier of the assignment table. For example: assignmentTables/0smva5nxuhv4yts6paxt

description

string

Human readable description of the assignment table.

timestampTruncation

object

Defines how time is truncated in the timestamp column.

Show child attributes

dimensions

object[]

Mapping between columns and dimensions of the entities.

Show child attributes

assignmentDataDeliveredUntilTime

object

The current maximum time point where there is available data for the assignment table.

dataDeliveredUntilUpdateStrategyConfig

object

The strategy for updating assignment_data_delivered_until_time in the assignment table.

Show child attributes

labels

object[]

Custom labels for this assignment table.

Show child attributes

owner

string

The owner of the resource. If not set will default to the creator.

Response

200 - application/json

Returns a AssignmentTable.

An assignment table is a description of a dataset of how entities have been assigned to variants.

sql

string

required

A data warehouse-specific query to get the data of the assignment table.

displayName

string

required

Human friendly name of the assignment table.

entityColumn

object

required

The column of the assignment table that represents the entity

Show child attributes

timestampColumn

object

required

The column of the assignment table that represents the time the assignment occurred.

Show child attributes

exposureKeyColumn

object

required

The column of the table that represents what the group of variants that the entity was assigned to, this would typically be the rule id or the flag name.

Show child attributes

variantKeyColumn

object

required

The column of the table that represents the variant that was assigned.

Show child attributes

state

enum<string>

required

The current state of the assignment table.

Available options:

TABLE_STATE_UNSPECIFIED,

TABLE_STATE_CREATING,

TABLE_STATE_ACTIVE,

TABLE_STATE_FAILED,

TABLE_STATE_UPDATING,

TABLE_STATE_DELETED

schemaValidationJob

string

required

Resource name of the sql job that was used to validate the schema of the fact table.

createTime

object

required

Time when the assignment table was first created.

updateTime

object

required

Time when the assignment table was last updated.

creator

string

required

Reference to the identity that created this assignment table.

updater

string

required

Reference to the identity that last updated this assignment table.

name

string

Unique identifier of the assignment table. For example: assignmentTables/0smva5nxuhv4yts6paxt

description

string

Human readable description of the assignment table.

timestampTruncation

object

Defines how time is truncated in the timestamp column.

Show child attributes

dimensions

object[]

Mapping between columns and dimensions of the entities.

Show child attributes

assignmentDataDeliveredUntilTime

object

The current maximum time point where there is available data for the assignment table.

partitionedUpdateStrategyState

object

Show child attributes

error

object

Indicates whether an errors has occurred.

Show child attributes

dataDeliveredUntilUpdateStrategyConfig

object

The strategy for updating assignment_data_delivered_until_time in the assignment table.

Show child attributes

deleteTime

object

Time when the assignment table was deleted.

labels

object[]

Custom labels for this assignment table.

Show child attributes

owner

string

The owner of the resource. If not set will default to the creator.

systemCreated

boolean

If this table is an automatically created internal table.

⌘I

Create AssignmentTable

curl --request POST \
  --url https://metrics.eu.confidence.dev/v1/assignmentTables \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumn": {
    "name": "<string>",
    "repeated": true
  },
  "timestampColumn": {
    "name": "<string>",
    "repeated": true
  },
  "exposureKeyColumn": {
    "name": "<string>",
    "repeated": true
  },
  "variantKeyColumn": {
    "name": "<string>",
    "repeated": true
  },
  "name": "<string>",
  "description": "<string>",
  "dimensions": [
    {
      "name": "<string>",
      "repeated": true
    }
  ],
  "assignmentDataDeliveredUntilTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>"
}
'

import requests

url = "https://metrics.eu.confidence.dev/v1/assignmentTables"

payload = {
    "sql": "<string>",
    "displayName": "<string>",
    "entityColumn": {
        "name": "<string>",
        "repeated": True
    },
    "timestampColumn": {
        "name": "<string>",
        "repeated": True
    },
    "exposureKeyColumn": {
        "name": "<string>",
        "repeated": True
    },
    "variantKeyColumn": {
        "name": "<string>",
        "repeated": True
    },
    "name": "<string>",
    "description": "<string>",
    "dimensions": [
        {
            "name": "<string>",
            "repeated": True
        }
    ],
    "assignmentDataDeliveredUntilTime": {},
    "labels": [{}],
    "owner": "<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({
    sql: '<string>',
    displayName: '<string>',
    entityColumn: {name: '<string>', repeated: true},
    timestampColumn: {name: '<string>', repeated: true},
    exposureKeyColumn: {name: '<string>', repeated: true},
    variantKeyColumn: {name: '<string>', repeated: true},
    name: '<string>',
    description: '<string>',
    dimensions: [{name: '<string>', repeated: true}],
    assignmentDataDeliveredUntilTime: {},
    labels: [{}],
    owner: '<string>'
  })
};

fetch('https://metrics.eu.confidence.dev/v1/assignmentTables', 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://metrics.eu.confidence.dev/v1/assignmentTables",
  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([
    'sql' => '<string>',
    'displayName' => '<string>',
    'entityColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'timestampColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'exposureKeyColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'variantKeyColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'name' => '<string>',
    'description' => '<string>',
    'dimensions' => [
        [
                'name' => '<string>',
                'repeated' => true
        ]
    ],
    'assignmentDataDeliveredUntilTime' => [
        
    ],
    'labels' => [
        [
                
        ]
    ],
    'owner' => '<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://metrics.eu.confidence.dev/v1/assignmentTables"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entityColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"timestampColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"variantKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"assignmentDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\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://metrics.eu.confidence.dev/v1/assignmentTables")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entityColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"timestampColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"variantKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"assignmentDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://metrics.eu.confidence.dev/v1/assignmentTables")

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  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entityColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"timestampColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"variantKeyColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"assignmentDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "timestampColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "exposureKeyColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "variantKeyColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "timestampTruncation": {
    "window": "TRUNCATION_WINDOW_UNSPECIFIED",
    "behaviour": "TRUNCATION_BEHAVIOR_UNSPECIFIED",
    "timeZone": "TRUNCATION_TIME_ZONE_UNSPECIFIED"
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "assignmentDataDeliveredUntilTime": {},
  "partitionedUpdateStrategyState": {
    "currentPartitionLastCheckTime": {},
    "existsCheckDuration": {},
    "state": "STATE_UNSPECIFIED",
    "usualLateness": {},
    "count": 123
  },
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "dataDeliveredUntilUpdateStrategyConfig": {
    "strategy": "STRATEGY_UNSPECIFIED",
    "disableEmptyPartitions": true,
    "automaticUpdateConfig": {
      "commitDelay": {},
      "incrementDuration": {},
      "changeThreshold": {
        "value": "<string>"
      }
    },
    "dailyUpdateConfig": {
      "maxZeroDuration": {}
    },
    "hourlyUpdateConfig": {
      "maxZeroDuration": {}
    }
  },
  "deleteTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>",
  "systemCreated": true
}

Get Started

Feature Flags

Metrics

Stats

Experiments

Surfaces

IAM

Connectors

Authorizations

Query Parameters

Body

Response