{"name":"ts-data-region_mod.csv_flow","pipeline":{"version":"1.0","doc_type":"pipeline","app_data":{"shaperCreated":true,"replace_space_by_dot":true},"primary_pipeline":"pipeline1","pipelines":[{"id":"pipeline1","nodes":[{"id":"source1","data_asset":{"properties":{"first_line_header":"true","encoding":"UTF-8","invalid_data_handling":"fail","file_format":"csv"},"ref":"37391579-a0f8-4e12-9600-e0c5c7e97093","app_data":{"dataset_name":"ts-data-region_mod.csv"}},"type":"binding","output":{"id":"source1output"}},{"id":"85e6e546-6d88-4359-83f6-7a6299c9e7f5","type":"execution_node","op":"com.ibm.wdp.transformer.FreeformCode","app_data":{"uiParams":{"key":"mutate","code":"mutate(`DATE` = as.Date(lubridate::parse_date_time(`DATE`, orders = c('ymd','ydm'), quiet = TRUE)),`Total_cases` = as.integer(`Total_cases`),`Risk Index` = as.integer(`Risk Index`))","args":{"type":"mutate","conditions":[],"auto":true,"autoConditions":[{"column":"DATE","type":"lubridate::mdy","newColumnName":"","format":"","actualType":"character","removeColumn":false},{"column":"Total_cases","type":"as.integer","newColumnName":"","format":"","actualType":"character","removeColumn":false},{"column":"Risk Index","type":"as.integer","newColumnName":"","format":"","actualType":"character","removeColumn":false}],"version":9},"automatic":true}},"parameters":{"FREEFORM_CODE":"mutate(`DATE` = autoConvertDate(`DATE`),`Total_cases` = as.integer(`Total_cases`),`Risk Index` = as.integer(`Risk Index`))"},"inputs":[{"id":"inputPort1","links":[{"node_id_ref":"source1","port_id_ref":"source1output"}]}],"outputs":[{"id":"outputPort1"}]},{"connection":{"properties":{"schema_name":"public","table_name":"ts-data-region_mod","table_action":"truncate","write_mode":"insert"},"ref":"9c2cd797-cc5c-4090-abc5-26d3b1767b73","app_data":{"path":"/public/ts-data-region_mod","project_name":"Lab-3","description":"","targetType":"relationalConnection"}},"id":"target1","type":"binding","input":{"id":"targetInput1","link":{"node_id_ref":"85e6e546-6d88-4359-83f6-7a6299c9e7f5","port_id_ref":"outputPort1"}}}],"runtime":"Spark"}]}}