create table account_d

create_table account_d.sql

(
    account_id bigint encode bytedict,
    account_name varchar(100) encode ztsd,
    account_update_date date,
    primary key (account_id)
)
distsyle all
sortkey(account_id)
;

create table campaign_d
(
    account_id bigint encode bytedict,
    campaign_id bigint encode bytedict,
    campaign_name varchar(150) encode ztsd,
    campaign_update_date date,
    primary key (account_id, campaign_id)
)
distsyle all
sortkey(account_id, campaign_id)
;

create table campaign_performance_f
(
    performance_date date,
    account_id bigint encode bytedict,
    campaign_id bigint encode bytedict,
    impressions int encode bytedict,
    clicks int encode bytedict,
    cost float encode bytedict,
    load_date date,
    primary key (performance_date, account_id, campaign_id)
)
distsyle auto
sortkey(performance_date,account_id,campaign_id)