/* Creates a table of Canvas event logs from the described courses*/
CREATE OR REPLACE TABLE `iu-uits-pti-elearninglab.elliot_canvas_logs.log_data_1_13_21` AS  

SELECT id,type, action,course_offering_id,event_time,event  FROM `udp-iu-prod.event_store.events` WHERE course_offering_id in 
('1783993','1784008','1800282','1799568','1783979','1832627','1832633','1832718','1832713','1832816','1832859','1849195','1870791','1870988','1871017','1885475','1870795','1938229','1923503','1935329','1916898','1916712') AND type IN ('NavigationEvent','SessionEvent','ViewEvent','MediaEvent','Event')
/* Execution Time: 1 minute 45 seconds on 1/14/2021; bytes processed: 4.4 TiB/4.84 TB