CREATE TABLE olap.ibor_holding_candidates (
candidate_id VARCHAR,
source_system VARCHAR,
source_account_ref VARCHAR,
source_asset_ref VARCHAR,
account_id VARCHAR,
asset_id VARCHAR,
business_date DATE,
quantity DECIMAL,
market_value DECIMAL,
market_value_currency VARCHAR,
average_cost_per_unit DECIMAL,
source_revision BIGINT,
superseded_revision BIGINT,
reconciled_revision BIGINT,
updated_at TIMESTAMPTZ,
PRIMARY KEY (candidate_id)
)
WITH (
snapshot='true'
) FROM olap.olap_source TABLE 'olap.ibor_holding_candidates'