CREATE TABLE olap.tasks_dm (
task_id VARCHAR,
name VARCHAR,
description VARCHAR,
due_date DATE,
status VARCHAR,
priority VARCHAR,
assignee_id VARCHAR,
created_by VARCHAR,
updated_by VARCHAR,
created_at TIMESTAMPTZ,
updated_at TIMESTAMPTZ,
is_automated BOOLEAN,
automation_type VARCHAR,
resource_account_id VARCHAR,
resource_client_id VARCHAR,
resource_portfolio_id VARCHAR,
resource_party_id VARCHAR,
resource_draft_account_id VARCHAR,
resource_referral_id VARCHAR,
disabled_at TIMESTAMPTZ,
PRIMARY KEY (task_id)
)
WITH (
snapshot='true'
) FROM olap.olap_source TABLE 'olap.tasks_dm'