Undelete FactTable

POST

factTables

{factTable}

:undelete

Undelete FactTable

curl --request POST \
  --url https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{}'

import requests

url = "https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete"

payload = {}
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({})
};

fetch('https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete', 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/factTables/{factTable}:undelete",
  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([
    
  ]),
  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/factTables/{factTable}:undelete"

	payload := strings.NewReader("{}")

	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/factTables/{factTable}:undelete")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete")

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 = "{}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "timestampColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "entities": [
    {
      "column": {
        "name": "<string>",
        "type": "COLUMN_TYPE_UNSPECIFIED",
        "repeated": true
      },
      "entity": "<string>"
    }
  ],
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "measures": [
    {
      "column": {
        "name": "<string>",
        "type": "COLUMN_TYPE_UNSPECIFIED",
        "repeated": true
      },
      "displayName": "<string>",
      "unit": {
        "baseUnitMultiplier": 123,
        "baseUnit": "BASE_UNIT_UNSPECIFIED",
        "currencyCode": "<string>",
        "customUnit": "<string>",
        "entity": "<string>",
        "factTable": "<string>"
      },
      "declaredType": "COLUMN_TYPE_UNSPECIFIED"
    }
  ],
  "partitionedUpdateStrategyState": {
    "currentPartitionLastCheckTime": {},
    "existsCheckDuration": {},
    "state": "STATE_UNSPECIFIED",
    "usualLateness": {},
    "count": 123
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "factDataDeliveredUntilTime": {},
  "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

factTable

string

required

Body

application/json

The body is of type object.

Response

200 - application/json

Returns a FactTable.

A set of events from some business process, for example, a sale occurred.

sql

string

required

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

displayName

string

required

Human friendly name of the fact table.

timestampColumn

object

required

The column of the fact table that represents the time the event occurred.

Show child attributes

entities

object[]

required

Mapping between columns and the entities involved in the event.

Show child attributes

state

enum<string>

required

Current state of the fact 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 fact table was first created.

updateTime

object

required

Time when the fact table was last updated.

creator

string

required

Reference to the identity that created this fact table.

updater

string

required

Reference to the identity that last updated this fact table.

name

string

Unique identifier of the fact table. For example: factTables/0smva5nxuhv4yts6paxt

description

string

Human readable description of the fact table.

measures

object[]

Mapping between columns of the underlying table and measures.

Show child attributes

partitionedUpdateStrategyState

object

Show child attributes

dimensions

object[]

Mapping between columns and dimensions of the entities.

Show child attributes

error

object

Indicates whether an errors has occurred.

Show child attributes

factDataDeliveredUntilTime

object

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

dataDeliveredUntilUpdateStrategyConfig

object

The strategy for updating fact_data_delivered_until_time in the fact table.

Show child attributes

deleteTime

object

Time when the fact table table was deleted.

labels

object[]

Custom labels for this fact table.

Show child attributes

owner

string

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

systemCreated

boolean

If this fact table is an automatically created fact table.

⌘I

Undelete FactTable

curl --request POST \
  --url https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{}'

import requests

url = "https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete"

payload = {}
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({})
};

fetch('https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete', 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/factTables/{factTable}:undelete",
  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([
    
  ]),
  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/factTables/{factTable}:undelete"

	payload := strings.NewReader("{}")

	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/factTables/{factTable}:undelete")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://metrics.eu.confidence.dev/v1/factTables/{factTable}:undelete")

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 = "{}"

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

{
  "sql": "<string>",
  "displayName": "<string>",
  "timestampColumn": {
    "name": "<string>",
    "type": "COLUMN_TYPE_UNSPECIFIED",
    "repeated": true
  },
  "entities": [
    {
      "column": {
        "name": "<string>",
        "type": "COLUMN_TYPE_UNSPECIFIED",
        "repeated": true
      },
      "entity": "<string>"
    }
  ],
  "state": "TABLE_STATE_UNSPECIFIED",
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "measures": [
    {
      "column": {
        "name": "<string>",
        "type": "COLUMN_TYPE_UNSPECIFIED",
        "repeated": true
      },
      "displayName": "<string>",
      "unit": {
        "baseUnitMultiplier": 123,
        "baseUnit": "BASE_UNIT_UNSPECIFIED",
        "currencyCode": "<string>",
        "customUnit": "<string>",
        "entity": "<string>",
        "factTable": "<string>"
      },
      "declaredType": "COLUMN_TYPE_UNSPECIFIED"
    }
  ],
  "partitionedUpdateStrategyState": {
    "currentPartitionLastCheckTime": {},
    "existsCheckDuration": {},
    "state": "STATE_UNSPECIFIED",
    "usualLateness": {},
    "count": 123
  },
  "dimensions": [
    {
      "name": "<string>",
      "type": "COLUMN_TYPE_UNSPECIFIED",
      "repeated": true
    }
  ],
  "error": {
    "message": "<string>",
    "details": [
      "<string>"
    ]
  },
  "factDataDeliveredUntilTime": {},
  "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

Body

Response