airflow-tutorial-gist-02.sql

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

CREATE TABLE clickstream (
  click_id uuid PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
  click_timestamp TIMESTAMP WITH TIME ZONE,
  user_id UUID,
  is_ad_display_event BOOLEAN,
  is_ad_search_event BOOLEAN
);

CREATE TABLE clickstream_aggregated (
  click_date DATE,
  nb_ad_display_events BIGINT,
  nb_ad_search_events BIGINT
);