Update DimensionTable

PATCH

dimensionTables

{dimensionTable}

curl --request PATCH \
  --url https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "<string>",
  "displayName": "<string>",
  "name": "<string>",
  "description": "<string>",
  "valueMappings": [
    {
      "column": "<string>",
      "mappings": [
        {
          "inputDimensionValue": {
            "value": "<string>"
          },
          "outputDimensionValue": {
            "value": "<string>"
          }
        }
      ]
    }
  ],
  "dimensionDataDeliveredUntilTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>"
}
'

import requests

url = "https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}"

payload = {
    "sql": "<string>",
    "displayName": "<string>",
    "name": "<string>",
    "description": "<string>",
    "valueMappings": [
        {
            "column": "<string>",
            "mappings": [
                {
                    "inputDimensionValue": { "value": "<string>" },
                    "outputDimensionValue": { "value": "<string>" }
                }
            ]
        }
    ],
    "dimensionDataDeliveredUntilTime": {},
    "labels": [{}],
    "owner": "<string>"
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.patch(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PATCH',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    sql: '<string>',
    displayName: '<string>',
    name: '<string>',
    description: '<string>',
    valueMappings: [
      {
        column: '<string>',
        mappings: [
          {
            inputDimensionValue: {value: '<string>'},
            outputDimensionValue: {value: '<string>'}
          }
        ]
      }
    ],
    dimensionDataDeliveredUntilTime: {},
    labels: [{}],
    owner: '<string>'
  })
};

fetch('https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}', 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/dimensionTables/{dimensionTable}",
  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([
    'sql' => '<string>',
    'displayName' => '<string>',
    'name' => '<string>',
    'description' => '<string>',
    'valueMappings' => [
        [
                'column' => '<string>',
                'mappings' => [
                                [
                                                                'inputDimensionValue' => [
                                                                                                                                'value' => '<string>'
                                                                ],
                                                                'outputDimensionValue' => [
                                                                                                                                'value' => '<string>'
                                                                ]
                                ]
                ]
        ]
    ],
    'dimensionDataDeliveredUntilTime' => [
        
    ],
    '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/dimensionTables/{dimensionTable}"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"valueMappings\": [\n    {\n      \"column\": \"<string>\",\n      \"mappings\": [\n        {\n          \"inputDimensionValue\": {\n            \"value\": \"<string>\"\n          },\n          \"outputDimensionValue\": {\n            \"value\": \"<string>\"\n          }\n        }\n      ]\n    }\n  ],\n  \"dimensionDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")

	req, _ := http.NewRequest("PATCH", 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.patch("https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"valueMappings\": [\n    {\n      \"column\": \"<string>\",\n      \"mappings\": [\n        {\n          \"inputDimensionValue\": {\n            \"value\": \"<string>\"\n          },\n          \"outputDimensionValue\": {\n            \"value\": \"<string>\"\n          }\n        }\n      ]\n    }\n  ],\n  \"dimensionDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"valueMappings\": [\n    {\n      \"column\": \"<string>\",\n      \"mappings\": [\n        {\n          \"inputDimensionValue\": {\n            \"value\": \"<string>\"\n          },\n          \"outputDimensionValue\": {\n            \"value\": \"<string>\"\n          }\n        }\n      ]\n    }\n  ],\n  \"dimensionDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumnMapping": {
    "column": {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    },
    "entity": "<string>"
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "timeConfig": {
    "timestampColumn": {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    },
    "window": {}
  },
  "valueMappings": [
    {
      "column": "<string>",
      "mappings": [
        {
          "inputDimensionValue": {
            "value": "<string>"
          },
          "outputDimensionValue": {
            "value": "<string>"
          }
        }
      ]
    }
  ],
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "dimensionDataDeliveredUntilTime": {},
  "partitionedUpdateStrategyState": {
    "currentPartitionLastCheckTime": {},
    "existsCheckDuration": {},
    "state": "STATE_UNSPECIFIED",
    "usualLateness": {},
    "count": 123
  },
  "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.

Path Parameters

dimensionTable

string

required

Query Parameters

updateMask

object

The list of fields to update. Fields are specified relative to the DimensionTable (e.g. display_name, sql; not dimension_table.display_name or dimension_table.sql).

Body

application/json

sql

string

required

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

displayName

string

required

Human friendly name of the dimension table.

name

string

Unique identifier of the dimension table. For example: dimensionTables/0smva5nxuhv4yts6paxt

description

string

Human readable description of the dimension table.

valueMappings

object[]

An optional mapping for dimension values.

Show child attributes

dimensionDataDeliveredUntilTime

object

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

dataDeliveredUntilUpdateStrategyConfig

object

The strategy for updating dimension_data_delivered_until_time in the fact table.

Show child attributes

labels

object[]

Custom labels for this dimension 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 DimensionTable.

A description of a dataset that contains one or more dimensions of an entity.

sql

string

required

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

displayName

string

required

Human friendly name of the dimension table.

entityColumnMapping

object

required

Mapping between columns and entities.

Show child attributes

dimensions

object[]

required

Mapping between columns and dimensions of the entities.

Show child attributes

state

enum<string>

required

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

createTime

object

required

Time when the dimension table was first created.

updateTime

object

required

Time when the dimension table was last updated.

creator

string

required

Reference to the identity that created this dimension table.

updater

string

required

Reference to the identity that last updated this dimension table.

name

string

Unique identifier of the dimension table. For example: dimensionTables/0smva5nxuhv4yts6paxt

description

string

Human readable description of the dimension table.

timeConfig

object

If set, the dimension is allowed to change over time, if not they are considered static.

Show child attributes

valueMappings

object[]

An optional mapping for dimension values.

Show child attributes

error

object

Indicates whether an errors has occurred.

Show child attributes

dimensionDataDeliveredUntilTime

object

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

partitionedUpdateStrategyState

object

Current state for checking for new data.

Show child attributes

dataDeliveredUntilUpdateStrategyConfig

object

The strategy for updating dimension_data_delivered_until_time in the fact table.

Show child attributes

deleteTime

object

Time when the dimension table was deleted.

labels

object[]

Custom labels for this dimension 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

Update DimensionTable

curl --request PATCH \
  --url https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "<string>",
  "displayName": "<string>",
  "name": "<string>",
  "description": "<string>",
  "valueMappings": [
    {
      "column": "<string>",
      "mappings": [
        {
          "inputDimensionValue": {
            "value": "<string>"
          },
          "outputDimensionValue": {
            "value": "<string>"
          }
        }
      ]
    }
  ],
  "dimensionDataDeliveredUntilTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>"
}
'

import requests

url = "https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}"

payload = {
    "sql": "<string>",
    "displayName": "<string>",
    "name": "<string>",
    "description": "<string>",
    "valueMappings": [
        {
            "column": "<string>",
            "mappings": [
                {
                    "inputDimensionValue": { "value": "<string>" },
                    "outputDimensionValue": { "value": "<string>" }
                }
            ]
        }
    ],
    "dimensionDataDeliveredUntilTime": {},
    "labels": [{}],
    "owner": "<string>"
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.patch(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PATCH',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    sql: '<string>',
    displayName: '<string>',
    name: '<string>',
    description: '<string>',
    valueMappings: [
      {
        column: '<string>',
        mappings: [
          {
            inputDimensionValue: {value: '<string>'},
            outputDimensionValue: {value: '<string>'}
          }
        ]
      }
    ],
    dimensionDataDeliveredUntilTime: {},
    labels: [{}],
    owner: '<string>'
  })
};

fetch('https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}', 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/dimensionTables/{dimensionTable}",
  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([
    'sql' => '<string>',
    'displayName' => '<string>',
    'name' => '<string>',
    'description' => '<string>',
    'valueMappings' => [
        [
                'column' => '<string>',
                'mappings' => [
                                [
                                                                'inputDimensionValue' => [
                                                                                                                                'value' => '<string>'
                                                                ],
                                                                'outputDimensionValue' => [
                                                                                                                                'value' => '<string>'
                                                                ]
                                ]
                ]
        ]
    ],
    'dimensionDataDeliveredUntilTime' => [
        
    ],
    '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/dimensionTables/{dimensionTable}"

	payload := strings.NewReader("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"valueMappings\": [\n    {\n      \"column\": \"<string>\",\n      \"mappings\": [\n        {\n          \"inputDimensionValue\": {\n            \"value\": \"<string>\"\n          },\n          \"outputDimensionValue\": {\n            \"value\": \"<string>\"\n          }\n        }\n      ]\n    }\n  ],\n  \"dimensionDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")

	req, _ := http.NewRequest("PATCH", 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.patch("https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"valueMappings\": [\n    {\n      \"column\": \"<string>\",\n      \"mappings\": [\n        {\n          \"inputDimensionValue\": {\n            \"value\": \"<string>\"\n          },\n          \"outputDimensionValue\": {\n            \"value\": \"<string>\"\n          }\n        }\n      ]\n    }\n  ],\n  \"dimensionDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"sql\": \"<string>\",\n  \"displayName\": \"<string>\",\n  \"name\": \"<string>\",\n  \"description\": \"<string>\",\n  \"valueMappings\": [\n    {\n      \"column\": \"<string>\",\n      \"mappings\": [\n        {\n          \"inputDimensionValue\": {\n            \"value\": \"<string>\"\n          },\n          \"outputDimensionValue\": {\n            \"value\": \"<string>\"\n          }\n        }\n      ]\n    }\n  ],\n  \"dimensionDataDeliveredUntilTime\": {},\n  \"labels\": [\n    {}\n  ],\n  \"owner\": \"<string>\"\n}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumnMapping": {
    "column": {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    },
    "entity": "<string>"
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "timeConfig": {
    "timestampColumn": {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    },
    "window": {}
  },
  "valueMappings": [
    {
      "column": "<string>",
      "mappings": [
        {
          "inputDimensionValue": {
            "value": "<string>"
          },
          "outputDimensionValue": {
            "value": "<string>"
          }
        }
      ]
    }
  ],
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "dimensionDataDeliveredUntilTime": {},
  "partitionedUpdateStrategyState": {
    "currentPartitionLastCheckTime": {},
    "existsCheckDuration": {},
    "state": "STATE_UNSPECIFIED",
    "usualLateness": {},
    "count": 123
  },
  "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

Path Parameters

Query Parameters

Body

Response