Untitled

CREATE MATERIALIZED VIEW hobs_ods_staging.hos_cart_details_by_businessid_status AS
    SELECT *
    FROM hobs_ods_staging.hos_cart_details
    WHERE hoscd_businessid IS NOT NULL AND hoscd_status IS NOT NULL AND hoscd_event_date IS NOT NULL AND hoscd_key IS NOT NULL
    PRIMARY KEY ((hoscd_businessid, hoscd_status), hoscd_event_date, hoscd_key)
    WITH CLUSTERING ORDER BY (hoscd_event_date ASC, hoscd_key ASC);