CREATE TABLE olap.transactions_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,
unit_price DECIMAL,
order_id VARCHAR,
external_reference VARCHAR,
disabled_at TIMESTAMPTZ,
PRIMARY KEY (transaction_id)
)
WITH (
snapshot='true'
) FROM olap.olap_source TABLE 'olap.transactions_dm'