CREATE TABLE olap.clients_dm (
id VARCHAR,
display_name VARCHAR,
local_display_name VARCHAR,
preferred_name VARCHAR,
base_currency_code VARCHAR,
customer_identification_file VARCHAR,
type VARCHAR,
segment_label_id VARCHAR,
status_label_id VARCHAR,
prefix VARCHAR,
suffix VARCHAR,
first_name VARCHAR,
last_name VARCHAR,
onboarding_date DATE,
next_kyc_review_date DATE,
closing_date DATE,
disabled_at TIMESTAMPTZ,
created_at TIMESTAMPTZ,
m_is_stub BOOLEAN,
PRIMARY KEY (id)
)
WITH (
snapshot='true'
) FROM olap.olap_source TABLE 'olap.clients_dm'