DROP TABLE events_mv;
DROP TABLE materialized_events;
DROP TABLE session_events;

CREATE TABLE session_events(
    clientId UUID,
    sessionId UUID,
    pageId UUID,
    timestamp DateTime,
    type String
) ORDER BY (timestamp);

CREATE MATERIALIZED VIEW events_mv
TO materialized_events
AS SELECT
    clientId,
    sessionId,
    pageId,
    timestamp,
    type
FROM session_events;

CREATE TABLE materialized_events(
    clientId UUID,
    sessionId UUID,
    pageId UUID,
    timestamp DateTime,
    type String
) ORDER BY (timestamp);

DROP USER user_1;
CREATE USER user_1 IDENTIFIED WITH sha256_password BY 'My_password123@';
GRANT INSERT ON default.session_events TO user_1;
GRANT SELECT ON default.session_events TO user_1;