{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"66e13b151049ddb1178fd1c1","instance_id":"e9df8217-c5c0-4d09-99c8-7967f74e2af2","instance_version":60,"link_map":{"link113":{"dst_id":"c3d4e0f5-ce61-46af-8813-d5eeb8eceea8","dst_view_id":"inputRows","src_id":"3c5d10dd-d524-4799-a9c8-7524e7edb65f","src_view_id":"output0","isGoto":false},"link114":{"dst_id":"3c5d10dd-d524-4799-a9c8-7524e7edb65f","dst_view_id":"input0","src_id":"7746b163-7295-437a-a013-d128024f3c41","src_view_id":"output0","isGoto":false},"link115":{"dst_id":"7746b163-7295-437a-a013-d128024f3c41","dst_view_id":"input101","src_id":"c9a844d0-1d18-47da-8655-f85f4c3f4bc1","src_view_id":"output0","isGoto":false},"link116":{"dst_id":"c9a844d0-1d18-47da-8655-f85f4c3f4bc1","dst_view_id":"input0","src_id":"2710c543-463d-4f78-a506-6108706dca93","src_view_id":"output0","isGoto":false}},"link_serial":117,"property_map":{"info":{"label":{"value":"Snowflake Snowpipe Streaming"},"author":{"value":"lmanda@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"error_behavior":{"value":"none"}},"settings":{"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]}},"input":{"2710c543-463d-4f78-a506-6108706dca93_input101":{"label":{"value":"Sequence - input0"},"view_type":{"value":"document"}}},"output":{"c3d4e0f5-ce61-46af-8813-d5eeb8eceea8_output0":{"view_type":{"value":"document"},"label":{"value":"Snowflake - Snowpipe Streaming - output0"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"650d27afbf87226317660d8a","detail_map":{"c3d4e0f5-ce61-46af-8813-d5eeb8eceea8":{"grid_x_int":8,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0},"2710c543-463d-4f78-a506-6108706dca93":{"grid_x_int":4,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0},"7746b163-7295-437a-a013-d128024f3c41":{"grid_x_int":6,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0},"3c5d10dd-d524-4799-a9c8-7524e7edb65f":{"grid_x_int":7,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"c9a844d0-1d18-47da-8655-f85f4c3f4bc1":{"grid_x_int":5,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0}}},"snap_map":{"c3d4e0f5-ce61-46af-8813-d5eeb8eceea8":{"class_fqid":"com-snaplogic-snaps-snowflake-snowpipestreaming_1-PR27996","class_id":"com-snaplogic-snaps-snowflake-snowpipestreaming","class_version":1,"instance_fqid":"c3d4e0f5-ce61-46af-8813-d5eeb8eceea8_20","instance_id":"c3d4e0f5-ce61-46af-8813-d5eeb8eceea8","instance_version":20,"property_map":{"info":{"label":{"value":"Snowflake - Snowpipe Streaming"},"notes":{}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"createTable":{"value":true},"maxClientLag":{"value":"10000","expression":false},"schemaName":{"value":"\"PUBLIC\"","expression":false},"tableName":{"value":"\"PUBLIC\".\"LUX\"","expression":false}},"account":{"account_ref":{"value":{"label":{"value":"DG_SNOWFLAKE_S3_KEYPAIR","label":"../../shared/DG_SNOWFLAKE_S3_KEYPAIR","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"ref_id":{"value":"96a5a47b-f0f5-44ed-b809-e404086146c9","expression":false}},"expression":false}},"view_serial":100},"class_build_tag":"PR27996"},"2710c543-463d-4f78-a506-6108706dca93":{"class_fqid":"com-snaplogic-snaps-transform-sequence_1-438patches27959","class_id":"com-snaplogic-snaps-transform-sequence","class_version":1,"instance_fqid":"2710c543-463d-4f78-a506-6108706dca93_5","instance_id":"2710c543-463d-4f78-a506-6108706dca93","instance_version":5,"property_map":{"info":{"label":{"value":"Sequence"},"notes":{}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"initialValueProp":{"value":1,"expression":false},"stepValueProp":{"value":1,"expression":false},"numberOfDocumentsProp":{"value":10,"expression":false},"passThroughProp":{"value":true}},"view_serial":101,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"438patches27959"},"7746b163-7295-437a-a013-d128024f3c41":{"class_fqid":"com-snaplogic-snaps-snowflake-execute_1-439patches28928","class_id":"com-snaplogic-snaps-snowflake-execute","class_version":1,"instance_fqid":"7746b163-7295-437a-a013-d128024f3c41_6","instance_id":"7746b163-7295-437a-a013-d128024f3c41","instance_version":6,"property_map":{"info":{"label":{"value":"Snowflake - Execute"},"notes":{}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"sqlStatement":{"value":"Create or Replace TABLE \"PUBLIC\".\"LUX\" (NUM INT);","expression":false},"queryType":{"value":"Auto","expression":false},"useResultQuery":{"value":false},"handleDateTimeValues":{"value":"Default Date Time format in UTC Time Zone"},"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Validate & Execute"},"retryIntervalProp":{"value":1,"expression":false},"passThrough":{"value":true},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":false},"sqlQueryManagement":{"value":"Continue to execute queued queries when pipeline is stopped or if it fails"}},"account":{"account_ref":{"value":{"label":{"value":"DG_SNOWFLAKE_S3_KEYPAIR","label":"../../shared/DG_SNOWFLAKE_S3_KEYPAIR","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"ref_id":{"value":"96a5a47b-f0f5-44ed-b809-e404086146c9","expression":false}},"expression":false}},"view_serial":101,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"439patches28928"},"3c5d10dd-d524-4799-a9c8-7524e7edb65f":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-438patches27959","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"3c5d10dd-d524-4799-a9c8-7524e7edb65f_1","instance_id":"3c5d10dd-d524-4799-a9c8-7524e7edb65f","instance_version":1,"property_map":{"info":{"label":{"value":"Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":false},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"expression":true,"value":"$original.num"},"targetPath":{"value":"num"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"438patches27959"},"c9a844d0-1d18-47da-8655-f85f4c3f4bc1":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-438patches27959","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"c9a844d0-1d18-47da-8655-f85f4c3f4bc1_3","instance_id":"c9a844d0-1d18-47da-8655-f85f4c3f4bc1","instance_version":3,"property_map":{"info":{"label":{"value":"Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":false},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"expression":true,"value":"$value"},"targetPath":{"value":"num"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"438patches27959"}},"path_id":"/QA/Shared_Assets/Ent","path_snode":"662b5b9523553baa2110c18b","target_runtime":"standard"}