Fact Table

string

required

name

string

required

description

string

required

Maximum string length: 10000

owner

string

required

The userId of the owner (or raw owner name/email for legacy records)

projects

string[]

required

tags

string[]

required

datasource

string

required

userIdTypes

string[]

required

sql

string

required

managedBy

enum<string>

required

Where this fact table must be managed from. If not set (empty string), it can be managed from anywhere.

Available options:

api,

admin

dateCreated

string<date-time>

required

dateUpdated

string<date-time>

required

ownerEmail

string

The email address of the owner, when the owner can be resolved to a known user.

aggregatedFactTableSettings

object

Settings for maintaining shared daily aggregated tables (a subset of userIdTypes plus the daily update time and restate lookback window) used to speed up CUPED. Requires the data pipeline (pipeline-mode) feature.

Show child attributes

eventName

string

The event name used in SQL template variables

columns

object[]

Array of column definitions for this fact table

Show child attributes

columnsError

string | null

Error message if there was an issue parsing the SQL schema

archived

boolean

{ "id": "<string>", "name": "<string>", "description": "<string>", "owner": "<string>", "projects": [ "<string>" ], "tags": [ "<string>" ], "datasource": "<string>", "userIdTypes": [ "<string>" ], "sql": "<string>", "dateCreated": "2023-11-07T05:31:56Z", "dateUpdated": "2023-11-07T05:31:56Z", "ownerEmail": "<string>", "eventName": "<string>", "columns": [ { "column": "<string>", "jsonFields": {}, "name": "<string>", "description": "<string>", "alwaysInlineFilter": false, "deleted": false, "isAutoSliceColumn": false, "autoSlices": [ "<string>" ], "lockedAutoSlices": [ "<string>" ], "dateCreated": "2023-11-07T05:31:56Z", "dateUpdated": "2023-11-07T05:31:56Z" } ], "columnsError": "<string>", "archived": true }

Introduction

Endpoints

Models