CREATE TABLE olap.transactions_intraday_dm (
transaction_id VARCHAR,
account_id VARCHAR,
asset_id VARCHAR,
transaction_valuation_date DATE,
transaction_valuation_timestamp TIMESTAMPTZ,
transaction_settlement_date DATE,
transaction_type_id VARCHAR,
currency_code VARCHAR,
gross_value DECIMAL,
net_value DECIMAL,
quantity DECIMAL,
order_id VARCHAR,
order_side_label_id VARCHAR,
status_label_id VARCHAR,
disabled_at TIMESTAMPTZ,
PRIMARY KEY (transaction_id)
)
WITH (
snapshot='true'
) FROM olap.olap_source TABLE 'olap.transactions_intraday_dm'