airflow-tutorial-gist-06.sql

BEGIN;

INSERT INTO clickstream
(click_timestamp, user_id, is_ad_display_event, is_ad_search_event)
VALUES
('2018–10–01 03:00:00', uuid_generate_v4(), TRUE, FALSE),
('2018–10–01 04:00:00', uuid_generate_v4(), FALSE, TRUE),
('2018–10–02 03:00:00', uuid_generate_v4(), TRUE, FALSE),
('2018–10–02 05:00:00', uuid_generate_v4(), TRUE, FALSE),
('2018–10–03 04:00:00', uuid_generate_v4(), FALSE, TRUE),
('2018–10–04 03:00:00', uuid_generate_v4(), TRUE, FALSE),
('2018–10–05 03:00:00', uuid_generate_v4(), TRUE, FALSE),
('2018–10–06 04:00:00', uuid_generate_v4(), FALSE, TRUE),
('2018–10–07 03:00:00', uuid_generate_v4(), TRUE, FALSE);
COMMIT;

SELECT * FROM clickstream LIMIT 100;