$ODCLBRD${"reports":[],"workflow":{"id":"f5b73cdf-ae80-4497-8e22-1a457f0e3b7c","versionNumber":13,"name":"FULL ITH SCENARIO","tags":[],"description":"","notes":null,"createdAt":"2020-05-22T08:32:28.189Z","updatedAt":"2020-05-22T10:06:10.869Z","projects":[{"id":"279c4642-8683-453e-b675-38baeabb1f57","projectType":"USE_CASES","owner":"d40abed4-8cea-4ba3-9716-dd23903fbd9a","name":"Matthi's TestProject","description":null,"notes":null,"tags":[],"createdAt":"2020-02-26T09:16:11.985Z","updatedAt":"2020-02-26T09:16:11.985Z","secured":false,"ownerInformation":null}],"nodes":{"be7cc430-c945-4ca5-acdc-46a0646e58ff":{"id":"be7cc430-c945-4ca5-acdc-46a0646e58ff","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":1150,"y":263,"name":"Result Table","color":"#b39ddb"},"out":{}},"d24f9e2c-d089-48d4-9bc6-f20c59502fe6":{"id":"d24f9e2c-d089-48d4-9bc6-f20c59502fe6","processor":"00000000-0000-0000-0003-000000000001","config":{"tablename":"","query":"SELECT * FROM inputTable i where i.date >= '@spark_ts1@'"},"result":null,"options":{"configEditExpertModeEnabled":false,"x":900,"y":151,"name":"Query","color":"#64b5f6"},"out":{"data":{"75a74200-3e79-49ed-962e-578523caf7fc":"data"}}},"f9086f55-95bc-4349-8477-0b1edf6f218d":{"id":"f9086f55-95bc-4349-8477-0b1edf6f218d","processor":"00000000-0000-0000-1140-000000000001","config":{"autoCastToString":false,"connection":"db571d3a-d07d-44fb-a153-8e6e0eb8d2eb","tablename":"","sqlSelect":"SELECT * from TIMETEST WHERE C_TIMESTAMP < @oracleTS_ts1@","addProps":{"triggerState":false,"values":{"0":{"addPropKey":null,"addPropValue":""}}}},"result":null,"options":{"configEditExpertModeEnabled":false,"x":2299,"y":151,"name":"Database Connection Load (Filter on TS Column)","color":"#f8bbd0"},"out":{"data":{"b1089179-5bc3-424e-8d71-1db427c96a6c":"data"}}},"c69726c6-b6b4-4b45-bc06-b1fbd95170c8":{"id":"c69726c6-b6b4-4b45-bc06-b1fbd95170c8","processor":"00000000-0000-0000-0024-000000000001","config":{"tablename":"","table":{"headers":[{"name":"Col1","unit":"1a10b26e-0dbf-4ec5-992e-71d40c4451a0"},{"name":"Col2","unit":"de438314-4f07-47e6-965a-55e3f1cb191d"}],"rows":[["@spark_ts1@","asd"],["@spark_ts2@","asd"]]}},"result":null,"options":{"configEditExpertModeEnabled":false,"x":300,"y":38,"name":"Using DateTime variable in String Config Elements","color":"#ab47bc"},"out":{"output":{"45efb4a8-4a8c-4ffc-8499-b9fd6e1b3298":"input","3f833fd6-8953-4e28-828b-827496a1286d":"data"}}},"3d6f69d5-75cc-4644-b493-9f82ffbae4df":{"id":"3d6f69d5-75cc-4644-b493-9f82ffbae4df","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":700,"y":151,"name":"Result Table","color":"#64b5f6"},"out":{}},"65ecba73-6287-4c65-bf17-e74531b3fc17":{"id":"65ecba73-6287-4c65-bf17-e74531b3fc17","processor":"00000000-0000-0000-1140-000000000001","config":{"autoCastToString":false,"connection":"db571d3a-d07d-44fb-a153-8e6e0eb8d2eb","tablename":"","sqlSelect":"SELECT * from TIMETEST WHERE B_DATE < @oracleDate_ts1@","addProps":{"triggerState":false,"values":{"0":{"addPropKey":null,"addPropValue":""}}}},"result":null,"options":{"configEditExpertModeEnabled":false,"x":1849,"y":151,"name":"Database Connection Load (Filter on Date Column)","color":"#f8bbd0"},"out":{"data":{"455f485e-d68e-4073-863c-257ff77d0efc":"data"}}},"75a74200-3e79-49ed-962e-578523caf7fc":{"id":"75a74200-3e79-49ed-962e-578523caf7fc","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":900,"y":263,"name":"Result Table","color":"#64b5f6"},"out":{}},"45efb4a8-4a8c-4ffc-8499-b9fd6e1b3298":{"id":"45efb4a8-4a8c-4ffc-8499-b9fd6e1b3298","processor":"00000000-0000-0000-0022-000000000001","config":{"column":[{"name":"Col1"}],"tablename":"","value":"@spark_ts1@","operator":["EQUAL"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":150,"y":151,"name":"Data Filter using sparkTS","color":"#ab47bc"},"out":{"output":{"82e75506-22d4-43cf-b945-29a665b2079b":"data"}}},"82e75506-22d4-43cf-b945-29a665b2079b":{"id":"82e75506-22d4-43cf-b945-29a665b2079b","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":150,"y":263,"name":"Result Table","color":"#ab47bc"},"out":{}},"e3a84752-82aa-4562-9fa5-a0a21b5fa8da":{"id":"e3a84752-82aa-4562-9fa5-a0a21b5fa8da","processor":"00000000-0000-0000-0024-000000000001","config":{"tablename":"","table":{"headers":[{"name":"string","unit":"27626107-685b-41b0-ac07-c6bcae68e3a2"},{"name":"datetime","unit":"1a10b26e-0dbf-4ec5-992e-71d40c4451a0"},{"name":"JUST_TO_REMEMBER_WHAT_IS_WRITTEN","unit":"de438314-4f07-47e6-965a-55e3f1cb191d"}],"rows":[["@Var01@","@Var01@","/@ Var01"],["@Var01[ORACLE_TIMESTAMP]@","@Fallback@","/@ Var01[ORACLE_TIMESTAMP]"],["@Var01[SPARK_TIMESTAMP]@","@Var01[SPARK_TIMESTAMP]@","/@ Var01[SPARK_TIMESTAMP]"],["@Var01[ORACLE_DATE]@","@Fallback@","/@ Var01[ORACLE_DATE]"],["@Var01[STRING]@","@Fallback@","/@ Var01[STRING]"],["@sys_datetime@","@sys_datetime@","/@ sys_datetime"],["@sys_datetime[ORACLE_TIMESTAMP]@","@Fallback@","/@ sys_datetime[ORACLE_TIMESTAMP]"],["@sys_datetime[SPARK_TIMESTAMP]@","@sys_datetime[SPARK_TIMESTAMP]@","/@ sys_datetime[SPARK_TIMESTAMP]"],["@sys_datetime[ORACLE_DATE]@","@Fallback@","/@ sys_datetime[ORACLE_DATE]"],["@sys_datetime[STRING]@","@Fallback@","/@ sys_datetime[STRING]"]]}},"result":null,"options":{"configEditExpertModeEnabled":false,"x":1475,"y":151,"name":"All Modifiers used","color":"#4db6ac"},"out":{"output":{"fa2dc66f-f1d5-4c59-8ef4-e6d317f2e1c8":"data"}}},"44508607-b8ef-4ea8-8543-dec283cd18ad":{"id":"44508607-b8ef-4ea8-8543-dec283cd18ad","processor":"00000000-0000-0000-0024-000000000001","config":{"tablename":"","table":{"headers":[{"name":"Col3","unit":"de438314-4f07-47e6-965a-55e3f1cb191d"},{"name":"date","unit":"1a10b26e-0dbf-4ec5-992e-71d40c4451a0"},{"name":"customStringFormatters","unit":"27626107-685b-41b0-ac07-c6bcae68e3a2"},{"name":"usedStringFormatter","unit":"de438314-4f07-47e6-965a-55e3f1cb191d"}],"rows":[["spark_ts1","@spark_ts1@","@spark_ts1[SPARK_TIMESTAMP|yyyy/MM/dd]@","spark_ts1[SPARK_TIMESTAMP|yyyy/MM/dd]"],["spark_ts2","@spark_ts2@","@spark_ts2[SPARK_TIMESTAMP|dd MMMM yyyy]@","spark_ts2[SPARK_TIMESTAMP|dd MMMM yyyy]"],["oracleDate_ts1","@oracleDate_ts1[SPARK_TIMESTAMP]@","@oracleDate_ts1[STRING|HH:mm]@","oracleDate_ts1[STRING|HH:mm]"],["oracleTS_ts1","@oracleTS_ts1[SPARK_TIMESTAMP]@","@oracleTS_ts1[STRING|yyyy-MM-dd HH]@","oracleTS_ts1[STRING|yyyy-MM-dd HH]"],["string_ts1","@string_ts1[SPARK_TIMESTAMP]@","@string_ts1[STRING|yy-MM-dd HH]@","string_ts1[STRING|yy-MM-dd HH]"],["long_ts1","@long_ts1[SPARK_TIMESTAMP]@","@long_ts1[STRING|MMMM dd, HH:mm]@","long_ts1[STRING|MMMM dd, HH:mm]"]]}},"result":null,"options":{"configEditExpertModeEnabled":false,"x":800,"y":38,"name":"Using custom String formatters","color":"#64b5f6"},"out":{"output":{"3d6f69d5-75cc-4644-b493-9f82ffbae4df":"data","d24f9e2c-d089-48d4-9bc6-f20c59502fe6":"data"}}},"e8c0202c-c08d-444e-8cfa-5b497e169d18":{"id":"e8c0202c-c08d-444e-8cfa-5b497e169d18","processor":"00000000-0000-0000-0255-000000000002","config":{"timestampConversion":{"triggerState":true,"values":{"0":{"timestampConversionCols":[{"name":"Col1"}],"timestampConversionFallback":"@Fallback[LONG]@","timestampConversionFormat":"MM/dd/yyyy HH:mm:ss.S"}}},"intConversion":{"triggerState":false,"values":{"0":{"intConversionCols":[],"intConversionFallback":0,"rounding":["DOWN"]}}},"tablename":"","doubleConversion":{"triggerState":false,"values":{"0":{"doubleConversionCols":[],"doubleConversionFallback":0}}},"stringConversion":{"triggerState":false,"values":{"0":{"stringConversionCols":[]}}}},"result":null,"options":{"configEditExpertModeEnabled":false,"x":1150,"y":151,"name":"Data Type Conversion","color":"#b39ddb"},"out":{"output":{"be7cc430-c945-4ca5-acdc-46a0646e58ff":"data"}}},"fa2dc66f-f1d5-4c59-8ef4-e6d317f2e1c8":{"id":"fa2dc66f-f1d5-4c59-8ef4-e6d317f2e1c8","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":1475,"y":263,"name":"All combinations in strings and datetime","color":"#4db6ac"},"out":{}},"61ba98ba-3912-48a1-ab7a-134fe0fa452b":{"id":"61ba98ba-3912-48a1-ab7a-134fe0fa452b","processor":"00000000-0000-0000-0024-000000000001","config":{"tablename":"","table":{"headers":[{"name":"Col1","unit":"27626107-685b-41b0-ac07-c6bcae68e3a2"}],"rows":[["@string_ts1@"],["@string_ts1@"],["asd"]]}},"result":null,"options":{"configEditExpertModeEnabled":false,"x":1150,"y":38,"name":"Using TS variable in TS config element","color":"#b39ddb"},"out":{"output":{"e8c0202c-c08d-444e-8cfa-5b497e169d18":"input"}}},"9733be9f-0dc7-4e8b-af44-d1975391755b":{"id":"9733be9f-0dc7-4e8b-af44-d1975391755b","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":450,"y":263,"name":"Result Table","color":"#ab47bc"},"out":{}},"b1089179-5bc3-424e-8d71-1db427c96a6c":{"id":"b1089179-5bc3-424e-8d71-1db427c96a6c","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":2300,"y":263,"name":"Result Table","color":"#f8bbd0"},"out":{}},"3f833fd6-8953-4e28-828b-827496a1286d":{"id":"3f833fd6-8953-4e28-828b-827496a1286d","processor":"00000000-0000-0000-0108-000000000001","config":{"colName":"Col2","userInput":"@oracleTS_ts1@","tablename":""},"result":null,"options":{"configEditExpertModeEnabled":false,"x":450,"y":151,"name":"Add Constant String","color":"#ab47bc"},"out":{"addedConstant":{"9733be9f-0dc7-4e8b-af44-d1975391755b":"data"}}},"455f485e-d68e-4073-863c-257ff77d0efc":{"id":"455f485e-d68e-4073-863c-257ff77d0efc","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":1850,"y":263,"name":"Result Table","color":"#f8bbd0"},"out":{}}},"nodeNotes":{},"owner":"d40abed4-8cea-4ba3-9716-dd23903fbd9a","resourceType":"WORKFLOW","groups":[],"auxiliaries":[],"variables":[{"id":"905d4868-8350-439a-9b9d-5ae2df1e9fe3","variableType":"timestamp","name":"spark_ts1","displayName":"spark_ts1","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589091360000,"formatter":"SPARK_TIMESTAMP"}},"variableOrigin":"WORKFLOW"},{"id":"1d4579d3-6df0-4c64-9df7-34901e300c85","variableType":"timestamp","name":"spark_ts2","displayName":"spark_ts2","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589177762879,"formatter":"SPARK_TIMESTAMP"}},"variableOrigin":"WORKFLOW"},{"id":"1b76818e-cc12-4430-81a6-d0eff4d32a37","variableType":"timestamp","name":"oracleDate_ts1","displayName":"oracleDate_ts1","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589177762885,"formatter":"ORACLE_DATE"}},"variableOrigin":"WORKFLOW"},{"id":"cc180096-2ebc-42be-8c13-3312a2ff12fc","variableType":"timestamp","name":"oracleTS_ts1","displayName":"oracleTS_ts1","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589177762891,"formatter":"ORACLE_TIMESTAMP"}},"variableOrigin":"WORKFLOW"},{"id":"ee7c4078-1f40-4002-9e07-aefbb9835a0b","variableType":"timestamp","name":"string_ts1","displayName":"string_ts1","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589177762898,"formatter":"STRING"}},"variableOrigin":"WORKFLOW"},{"id":"ee370145-0385-430f-bd38-66eed70034d3","variableType":"timestamp","name":"long_ts1","displayName":"long_ts1","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589177762908,"formatter":"LONG"}},"variableOrigin":"WORKFLOW"},{"id":"d5204a36-169e-4412-86cf-7cb6980ff9a0","variableType":"timestamp","name":"Var01","displayName":"Var01","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589179359844,"formatter":"SPARK_TIMESTAMP"}},"variableOrigin":"WORKFLOW"},{"id":"bca02b3a-b342-4231-9ae0-c072fed4e1a7","variableType":"timestamp","name":"Fallback","displayName":"Fallback","helpText":"","visualizationDefinition":{"visualizationMode":"DATE_TIME_PICKER","technicalReturnValue":null,"allowEmptySelection":false,"visualizationOptions":{"valueType":"EXACT_VALUE","variableAlternatives":[]}},"value":{"selectionType":"SINGLE_VALUE","variableValue":{"variableType":"timestamp","value":1589179320000,"formatter":"SPARK_TIMESTAMP"}},"variableOrigin":"WORKFLOW"}],"recentExecution":"9249109b-1583-46cc-bf8b-36e92424ffcd","jobNamingRule":"#@sys_job_version@","ownerInformation":{"type":"user","ownerId":"d40abed4-8cea-4ba3-9716-dd23903fbd9a","firstName":"Matthias","lastName":"Rauch"},"permissions":["READ","WRITE","CREATE","DELETE","EXECUTE","SHARE"],"sinks":[]}}