{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5976cedfe8ac6e67c2fd283c","instance_id":"2e251971-5e49-4243-a106-8f7d16a73cfb","instance_version":34,"link_map":{"link111":{"src_view_id":"output0","dst_view_id":"input0","src_id":"92f899ff-8b1b-44f6-bc0b-00494960c901","dst_id":"613d27b1-60d5-4855-8539-c45698f14c02","isGoto":false},"link107":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"cc96d730-85a7-4a79-b137-af7b3565ed43","dst_id":"db83a96e-f08f-40a3-b663-bd3f73ad12cd","isGoto":false},"link104":{"src_view_id":"outputRows","dst_view_id":"input0","src_id":"c9d2d3a8-7285-417c-b97d-f5df4c059b9f","dst_id":"cc96d730-85a7-4a79-b137-af7b3565ed43","isGoto":false},"link110":{"src_view_id":"output101","dst_view_id":"input0","src_id":"db83a96e-f08f-40a3-b663-bd3f73ad12cd","dst_id":"92f899ff-8b1b-44f6-bc0b-00494960c901","isGoto":false}},"link_serial":112,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL_to_Redshift"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"akallamsetti@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"613d27b1-60d5-4855-8539-c45698f14c02_output0":{"view_type":{"value":"document"},"label":{"value":"Redshift - Lookup - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"52e99449640a9a03d8682304","scale_ratio":1,"detail_map":{"cc96d730-85a7-4a79-b137-af7b3565ed43":{"grid_x_int":2,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"c9d2d3a8-7285-417c-b97d-f5df4c059b9f":{"grid_x_int":1,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"db83a96e-f08f-40a3-b663-bd3f73ad12cd":{"grid_x_int":3,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"92f899ff-8b1b-44f6-bc0b-00494960c901":{"grid_x_int":4,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"613d27b1-60d5-4855-8539-c45698f14c02":{"grid_x_int":5,"rot_int":0,"grid_y_int":1,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"613d27b1-60d5-4855-8539-c45698f14c02":{"class_fqid":"com-snaplogic-snaps-redshift-lookup_3-snapsmrc405","class_id":"com-snaplogic-snaps-redshift-lookup","class_version":3,"instance_fqid":"613d27b1-60d5-4855-8539-c45698f14c02_9","instance_id":"613d27b1-60d5-4855-8539-c45698f14c02","instance_version":9,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Lookup"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"redshift test"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"ref_id":{"expression":false,"value":"ca34dd49-5ba9-45bc-a00c-a5bc8ff7bb7d"}}}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"lookupConditions":{"value":[{"column":{"expression":false,"value":"\"emp_no\""},"value":{"expression":true,"value":"$original.emp_no"}}]},"passThrough":{"value":false},"schemaName":{"expression":false,"value":"\"!@#$%^prasanna\""},"outputFields":{"value":[]},"tableName":{"expression":false,"value":"\"!@#$%^prasanna\".\"test12red\""}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc405"},"92f899ff-8b1b-44f6-bc0b-00494960c901":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-flow3094","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"92f899ff-8b1b-44f6-bc0b-00494960c901_2","instance_id":"92f899ff-8b1b-44f6-bc0b-00494960c901","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Filter"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"filterExpression":{"expression":true,"value":"$original.emp_no == \"10008\""}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"flow3094"},"db83a96e-f08f-40a3-b663-bd3f73ad12cd":{"class_fqid":"com-snaplogic-snaps-redshift-insert_1-snapsmrc405","class_id":"com-snaplogic-snaps-redshift-insert","class_version":1,"instance_fqid":"db83a96e-f08f-40a3-b663-bd3f73ad12cd_14","instance_id":"db83a96e-f08f-40a3-b663-bd3f73ad12cd","instance_version":14,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Insert"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"redshift test"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"ref_id":{"expression":false,"value":"ca34dd49-5ba9-45bc-a00c-a5bc8ff7bb7d"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"settings":{"schemaName":{"expression":false,"value":"\"!@#$%^prasanna\""},"createTable":{"value":true},"tableName":{"expression":false,"value":"\"!@#$%^prasanna\".\"test12red\""},"executable_during_suggest":{"value":true}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc405"},"c9d2d3a8-7285-417c-b97d-f5df4c059b9f":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-snapsmrc405","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"c9d2d3a8-7285-417c-b97d-f5df4c059b9f_1","instance_id":"c9d2d3a8-7285-417c-b97d-f5df4c059b9f","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server - Select"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"sql server prasa"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"expression":false,"value":"fe6674e5-0ece-4541-946c-40c31eed8310"}}}},"settings":{"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"platform_qa\".\"employees\""},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"\"platform_qa\""},"ignoreEmptyResult":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}}},"class_build_tag":"snapsmrc405"},"cc96d730-85a7-4a79-b137-af7b3565ed43":{"class_fqid":"com-snaplogic-snaps-flow-head_1-flow3094","class_id":"com-snaplogic-snaps-flow-head","class_version":1,"instance_fqid":"cc96d730-85a7-4a79-b137-af7b3565ed43_2","instance_id":"cc96d730-85a7-4a79-b137-af7b3565ed43","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Head"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"numberOfDocs":{"value":25},"offset":{"value":0}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"flow3094"}},"path_id":"/snaplogic/projects/Dummy_Pipe","path_snode":"59411a5244ecb477d455bcda"}