The fields for creating a Data Pool.
dataSource required ID
The Data Source that will be used to create the Data Pool.
table required String
The table that the Data Pool will sync from.
timestamp required TimestampInput
The table's primary timestamp column. Propel uses the primary timestamp to order and partition your data in Data Pools. It will serve as the time dimension for your Metrics.
uniqueName optional String
The Data Pool's unique name. If not specified, Propel will set the ID as the unique name.
description optional String
The Data Pool's description.
columns required array of DataPoolColumnInput
The list of columns.
The name of the Data Source column that this Data Pool column derives from.
columns.type required ColumnType
The Data Pool column's type. This may differ from the corresponding Data Source column's type.
The Propel data types.
True or false.
A variable-length string.
A 32-bit signed double-precision floating point number.
A 64-bit signed double-precision floating point number.
An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.
A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.
A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.
A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.
A date without a timestamp. For example, "YYYY-MM-DD".
A date with a timestamp. For example, "yyy-MM-dd HH:mm:ss".
Whether the column is nullable, meaning whether it accepts a null value.
tenant optional TenantInput
The Data Pool's optional tenant ID column. The tenant ID column is used to control access to your data with access policies.
uniqueId optional UniqueIdInput
The Data Pool's unique ID column. Propel uses the primary timestamp and a unique ID to compose a primary key for determining whether records should be inserted, deleted, or updated within the Data Pool.
The fields to specify the Data Pool's unique ID column. Propel uses the primary timestamp and a unique ID to compose a primary key for determining whether records should be inserted, deleted, or updated within the Data Pool.
syncing optional DataPoolSyncingInput
The Data Pool's syncing settings.
The fields for modifying the Data Pool syncing.
syncing.interval required DataPoolSyncInterval
The available Data Pool sync intervals. Specify unit of time between attempts to sync data from your data warehouse.
Note that the syncing interval is approximate. For example, setting the syncing interval to
EVERY_1_HOURdoes not mean that syncing will occur exactly on the hour. Instead, the syncing interval starts relative to when the Data Pool goes
LIVE, and Propel will attempt to sync approximately every hour. Additionally, if you pause or resume syncing, this too can shift the syncing interval around.
accessControlEnabled optional Boolean
Enables or disables access control for the Data Pool.
If the Data Pool has access control enabled, Applications must be assigned Data Pool Access Policies in order to query the Data Pool and its Metrics.