CREATE TABLE olap.holding_values_intraday_ft (
id BIGINT,
account_id VARCHAR,
asset_id VARCHAR,
currency_code VARCHAR,
holding_timestamp TIMESTAMPTZ,
purchased_quantity DECIMAL,
market_value DECIMAL,
average_cost DECIMAL,
average_cost_per_unit DECIMAL,
average_cost_per_unit_system_currency DECIMAL,
market_value_system_currency DECIMAL,
disabled_at TIMESTAMPTZ,
PRIMARY KEY (id),
WATERMARK FOR holding_timestamp AS holding_timestamp - INTERVAL '5 YEARS' WITH TTL
)
WITH (
snapshot='true'
) FROM olap.olap_source TABLE 'olap.holding_values_intraday_ft'