v1.AggregatedFact
export interface AggregatedFact
Properties
Property | Modifiers | Type | Description |
|---|---|---|---|
“MIN” | “MAX” | “SUM” | “APPROXIMATE_COUNT” | Aggregation method for the fact. Mapped to sourceFactReference in the API. | ||
string | ID of the source fact this aggregated fact is based on. Mapped to sourceFactReference in the API. | ||
“INT” | “STRING” | “DATE” | “NUMERIC” | “TIMESTAMP” | “TIMESTAMP_TZ” | “BOOLEAN” | “HLL” | A column data type in the physical database. | ||
string | (Optional) An optional description of the field. | ||
boolean | (Optional) Optional flag to indicate if the aggregated fact can contain null values. | ||
string | (Optional) Optional value which can be used as replacement for NULL in join conditions. | ||
string | (Optional) A column name in the physical database. Optional, equals to id by default. | ||
(Optional) | |||
“aggregated_fact” |
Property details
v1.AggregatedFact.aggregated_asproperty
Aggregation method for the fact. Mapped to sourceFactReference in the API.
aggregated_as: "MIN" | "MAX" | "SUM" | "APPROXIMATE_COUNT";
v1.AggregatedFact.assigned_toproperty
ID of the source fact this aggregated fact is based on. Mapped to sourceFactReference in the API.
assigned_to: string;
v1.AggregatedFact.data_typeproperty
A column data type in the physical database.
data_type: "INT" | "STRING" | "DATE" | "NUMERIC" | "TIMESTAMP" | "TIMESTAMP_TZ" | "BOOLEAN" | "HLL";
v1.AggregatedFact.descriptionproperty
An optional description of the field.
description?: string;
v1.AggregatedFact.is_nullableproperty
Optional flag to indicate if the aggregated fact can contain null values.
is_nullable?: boolean;
v1.AggregatedFact.null_value_join_replacementproperty
Optional value which can be used as replacement for NULL in join conditions.
null_value_join_replacement?: string;
v1.AggregatedFact.source_columnproperty
A column name in the physical database. Optional, equals to id by default.
source_column?: string;
v1.AggregatedFact.tagsproperty
tags?: Tags4;
v1.AggregatedFact.typeproperty
type: "aggregated_fact";