Create ExposureTable

POST

exposureTables

curl --request POST \
  --url https://metrics.eu.confidence.dev/v1/exposureTables \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "<string>",
  "displayName": "<string>",
  "entity": "<string>",
  "firstExposureTimeColumn": {
    "name": "<string>",
    "repeated": true
  },
  "entityIdColumn": {
    "name": "<string>",
    "repeated": true
  },
  "groupNameColumn": {
    "name": "<string>",
    "repeated": true
  },
  "exposureDataDeliveredUntilTime": {},
  "dimensions": [
    {
      "name": "<string>",
      "repeated": true
    }
  ],
  "labels": [
    {}
  ],
  "owner": "<string>"
}
'

import requests

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

payload = {
    "sql": "<string>",
    "displayName": "<string>",
    "entity": "<string>",
    "firstExposureTimeColumn": {
        "name": "<string>",
        "repeated": True
    },
    "entityIdColumn": {
        "name": "<string>",
        "repeated": True
    },
    "groupNameColumn": {
        "name": "<string>",
        "repeated": True
    },
    "exposureDataDeliveredUntilTime": {},
    "dimensions": [
        {
            "name": "<string>",
            "repeated": True
        }
    ],
    "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>',
    entity: '<string>',
    firstExposureTimeColumn: {name: '<string>', repeated: true},
    entityIdColumn: {name: '<string>', repeated: true},
    groupNameColumn: {name: '<string>', repeated: true},
    exposureDataDeliveredUntilTime: {},
    dimensions: [{name: '<string>', repeated: true}],
    labels: [{}],
    owner: '<string>'
  })
};

fetch('https://metrics.eu.confidence.dev/v1/exposureTables', 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/exposureTables",
  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>',
    'entity' => '<string>',
    'firstExposureTimeColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'entityIdColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'groupNameColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'exposureDataDeliveredUntilTime' => [
        
    ],
    'dimensions' => [
        [
                'name' => '<string>',
                'repeated' => true
        ]
    ],
    '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/exposureTables"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entity\": \"<string>\",\n  \"firstExposureTimeColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"entityIdColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"groupNameColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureDataDeliveredUntilTime\": {},\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\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/exposureTables")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entity\": \"<string>\",\n  \"firstExposureTimeColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"entityIdColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"groupNameColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureDataDeliveredUntilTime\": {},\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

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

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  \"entity\": \"<string>\",\n  \"firstExposureTimeColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"entityIdColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"groupNameColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureDataDeliveredUntilTime\": {},\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "entity": "<string>",
  "firstExposureTimeColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "entityIdColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "groupNameColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "exposureDataDeliveredUntilTime": {},
  "exposedEntitiesMetric": "<string>",
  "firstExposureTruncation": {
    "window": "TRUNCATION_WINDOW_UNSPECIFIED",
    "behaviour": "TRUNCATION_BEHAVIOR_UNSPECIFIED",
    "timeZone": "TRUNCATION_TIME_ZONE_UNSPECIFIED"
  },
  "exposureFilterColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "labels": [
    {}
  ],
  "owner": "<string>",
  "scheduledExposureCalculation": "<string>",
  "exposureCalculation": "<string>",
  "deleteTime": {},
  "systemCreated": true
}

Authorizations

Authorization

string

header

required

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

Query Parameters

exposureTableId

string

The id to the give the created exposure 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 from the exposure table table.

displayName

string

required

Human friendly name of the exposure table.

entity

string

required

Resource name of the entity that is being exposed.

firstExposureTimeColumn

object

required

The column of the table that represents the time of exposure.

Show child attributes

entityIdColumn

object

required

Column of the table that represents the identifier of the entity.

Show child attributes

groupNameColumn

object

required

Column of the table that contains the group name.

Show child attributes

exposureDataDeliveredUntilTime

object

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

firstExposureTruncation

object

Defines how time is truncated in the first_exposure_time_column.

Show child attributes

exposureFilterColumn

object

Column of the table that contains what exposure filter this row refers to, if exposure filtering is enabled.

Show child attributes

dimensions

object[]

Mapping between columns and dimensions.

Show child attributes

labels

object[]

Custom labels for this exposure 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 ExposureTable.

An exposure table is describes how to compute exposures from assignments.

sql

string

required

A data warehouse-specific query to get the data from the exposure table table.

displayName

string

required

Human friendly name of the exposure table.

entity

string

required

Resource name of the entity that is being exposed.

firstExposureTimeColumn

object

required

The column of the table that represents the time of exposure.

Show child attributes

entityIdColumn

object

required

Column of the table that represents the identifier of the entity.

Show child attributes

groupNameColumn

object

required

Column of the table that contains the group name.

Show child attributes

state

enum<string>

required

Current state of the 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 exposure table.

createTime

object

required

Time when the exposure table was first created.

updateTime

object

required

Time when the exposure table was last updated.

creator

string

required

Reference to the identity that created this exposure table.

updater

string

required

Reference to the identity that last updated this exposure table.

name

string

Unique identifier of the exposure table. For example: exposureTables/0smva5nxuhv4yts6paxt

exposureDataDeliveredUntilTime

object

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

exposedEntitiesMetric

string

Resource name of the metric that counts exposures.

firstExposureTruncation

object

Defines how time is truncated in the first_exposure_time_column.

Show child attributes

exposureFilterColumn

object

Column of the table that contains what exposure filter this row refers to, if exposure filtering is enabled.

Show child attributes

dimensions

object[]

Mapping between columns and dimensions.

Show child attributes

error

object

Indicates whether an errors has occurred.

Show child attributes

labels

object[]

Custom labels for this exposure table.

Show child attributes

owner

string

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

scheduledExposureCalculation

string

exposureCalculation

string

deleteTime

object

Time when the exposure table was deleted.

systemCreated

boolean

If this exposure table is automatically created.

⌘I

Create ExposureTable

curl --request POST \
  --url https://metrics.eu.confidence.dev/v1/exposureTables \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "<string>",
  "displayName": "<string>",
  "entity": "<string>",
  "firstExposureTimeColumn": {
    "name": "<string>",
    "repeated": true
  },
  "entityIdColumn": {
    "name": "<string>",
    "repeated": true
  },
  "groupNameColumn": {
    "name": "<string>",
    "repeated": true
  },
  "exposureDataDeliveredUntilTime": {},
  "dimensions": [
    {
      "name": "<string>",
      "repeated": true
    }
  ],
  "labels": [
    {}
  ],
  "owner": "<string>"
}
'

import requests

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

payload = {
    "sql": "<string>",
    "displayName": "<string>",
    "entity": "<string>",
    "firstExposureTimeColumn": {
        "name": "<string>",
        "repeated": True
    },
    "entityIdColumn": {
        "name": "<string>",
        "repeated": True
    },
    "groupNameColumn": {
        "name": "<string>",
        "repeated": True
    },
    "exposureDataDeliveredUntilTime": {},
    "dimensions": [
        {
            "name": "<string>",
            "repeated": True
        }
    ],
    "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>',
    entity: '<string>',
    firstExposureTimeColumn: {name: '<string>', repeated: true},
    entityIdColumn: {name: '<string>', repeated: true},
    groupNameColumn: {name: '<string>', repeated: true},
    exposureDataDeliveredUntilTime: {},
    dimensions: [{name: '<string>', repeated: true}],
    labels: [{}],
    owner: '<string>'
  })
};

fetch('https://metrics.eu.confidence.dev/v1/exposureTables', 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/exposureTables",
  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>',
    'entity' => '<string>',
    'firstExposureTimeColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'entityIdColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'groupNameColumn' => [
        'name' => '<string>',
        'repeated' => true
    ],
    'exposureDataDeliveredUntilTime' => [
        
    ],
    'dimensions' => [
        [
                'name' => '<string>',
                'repeated' => true
        ]
    ],
    '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/exposureTables"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entity\": \"<string>\",\n  \"firstExposureTimeColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"entityIdColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"groupNameColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureDataDeliveredUntilTime\": {},\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\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/exposureTables")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"entity\": \"<string>\",\n  \"firstExposureTimeColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"entityIdColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"groupNameColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureDataDeliveredUntilTime\": {},\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

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

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  \"entity\": \"<string>\",\n  \"firstExposureTimeColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"entityIdColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"groupNameColumn\": {\n    \"name\": \"<string>\",\n    \"repeated\": true\n  },\n  \"exposureDataDeliveredUntilTime\": {},\n  \"dimensions\": [\n    {\n      \"name\": \"<string>\",\n      \"repeated\": true\n    }\n  ],\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "entity": "<string>",
  "firstExposureTimeColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "entityIdColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "groupNameColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "exposureDataDeliveredUntilTime": {},
  "exposedEntitiesMetric": "<string>",
  "firstExposureTruncation": {
    "window": "TRUNCATION_WINDOW_UNSPECIFIED",
    "behaviour": "TRUNCATION_BEHAVIOR_UNSPECIFIED",
    "timeZone": "TRUNCATION_TIME_ZONE_UNSPECIFIED"
  },
  "exposureFilterColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "labels": [
    {}
  ],
  "owner": "<string>",
  "scheduledExposureCalculation": "<string>",
  "exposureCalculation": "<string>",
  "deleteTime": {},
  "systemCreated": true
}

Get Started

Feature Flags

Metrics

Stats

Experiments

Surfaces

IAM

Connectors

Authorizations

Query Parameters

Body

Response