{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5967459f95526e370bb234e7","instance_id":"e24d8c94-719e-4f5e-96d0-65c106dc7747","instance_version":28,"link_map":{"link119":{"src_view_id":"outputRows","dst_view_id":"inputRows","src_id":"5e09d89f-58da-4fe4-bb0a-2176a1f64826","dst_id":"489f712d-581d-46d1-ad37-3ae49082f007","isGoto":false},"link120":{"src_view_id":"output101","dst_view_id":"input101","src_id":"489f712d-581d-46d1-ad37-3ae49082f007","dst_id":"28ad953e-d69c-45f5-9115-4610f8aceab5","isGoto":false},"link117":{"src_view_id":"output102","dst_view_id":"input101","src_id":"ede4e1fe-99c2-48c2-95e2-67b47dcb150f","dst_id":"aba5c32b-696a-45d2-895e-544dcda5222c","isGoto":false},"link109":{"src_view_id":"output0","dst_view_id":"input101","src_id":"28ad953e-d69c-45f5-9115-4610f8aceab5","dst_id":"ede4e1fe-99c2-48c2-95e2-67b47dcb150f","isGoto":false}},"link_serial":121,"property_map":{"info":{"notes":{"value":null},"label":{"value":"redshift-advanced-usecase"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"pmanzoor@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"ede4e1fe-99c2-48c2-95e2-67b47dcb150f_error0":{"label":{"value":"Redshift - Delete - error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"none"}},"output":{"aba5c32b-696a-45d2-895e-544dcda5222c_outputRows":{"label":{"value":"Redshift - Select - rows"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"57b6522095526e322e8c46ff","scale_ratio":1,"detail_map":{"28ad953e-d69c-45f5-9115-4610f8aceab5":{"grid_x_int":4,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"489f712d-581d-46d1-ad37-3ae49082f007":{"grid_x_int":3,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"ede4e1fe-99c2-48c2-95e2-67b47dcb150f":{"grid_x_int":5,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}}},"aba5c32b-696a-45d2-895e-544dcda5222c":{"grid_x_int":6,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"5e09d89f-58da-4fe4-bb0a-2176a1f64826":{"grid_x_int":2,"rot_int":0,"grid_y_int":2,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"28ad953e-d69c-45f5-9115-4610f8aceab5":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsrc797","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"28ad953e-d69c-45f5-9115-4610f8aceab5_1","instance_id":"28ad953e-d69c-45f5-9115-4610f8aceab5","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":101,"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$socialgroup"},"expression":{"expression":false,"value":"SOCIAL"}}]},"mappingRoot":{"value":"$"}}}},"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":"snapsrc797"},"489f712d-581d-46d1-ad37-3ae49082f007":{"class_fqid":"com-snaplogic-snaps-redshift-bulkload_1-rs8","class_id":"com-snaplogic-snaps-redshift-bulkload","class_version":1,"instance_fqid":"489f712d-581d-46d1-ad37-3ae49082f007_3","instance_id":"489f712d-581d-46d1-ad37-3ae49082f007","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Bulk Load"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"76d0b2eb-abbf-459f-b559-086de681c12c"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"expression":false,"value":"redshift_teja3"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"settings":{"maxError":{"value":100},"disableCompression":{"value":false},"truncateColumns":{"value":true},"truncate":{"value":false},"createTable":{"value":false},"invalidChars":{"value":true},"tableName":{"expression":false,"value":"\"prasanna\".\"redshiftdeletedemo\""},"executable_during_suggest":{"value":true},"vacuumType":{"value":"NONE"},"loadEmptyStrings":{"value":false},"parallelism":{"value":1},"ServerSideEncryption":{"value":false},"additionalOptions":{"value":null},"schemaName":{"expression":false,"value":"\"prasanna\""},"updateStats":{"value":false},"IAM_Role":{"value":false},"vacuumThreshold":{"value":null}},"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":"rs8"},"ede4e1fe-99c2-48c2-95e2-67b47dcb150f":{"class_fqid":"com-snaplogic-snaps-redshift-delete_1-rs8","class_id":"com-snaplogic-snaps-redshift-delete","class_version":1,"instance_fqid":"ede4e1fe-99c2-48c2-95e2-67b47dcb150f_5","instance_id":"ede4e1fe-99c2-48c2-95e2-67b47dcb150f","instance_version":5,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Delete"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"redshift_teja3"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"ref_id":{"expression":false,"value":"76d0b2eb-abbf-459f-b559-086de681c12c"}}}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"schemaName":{"expression":false,"value":"\"prasanna\""},"deleteCondition":{"value":"outlook_product_group_c=$socialgroup"},"tableName":{"expression":false,"value":"\"prasanna\".\"redshiftdeletedemo\""},"executable_during_suggest":{"value":true}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"output":{"output102":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"rs8"},"aba5c32b-696a-45d2-895e-544dcda5222c":{"class_fqid":"com-snaplogic-snaps-redshift-select_3-rs8","class_id":"com-snaplogic-snaps-redshift-select","class_version":3,"instance_fqid":"aba5c32b-696a-45d2-895e-544dcda5222c_4","instance_id":"aba5c32b-696a-45d2-895e-544dcda5222c","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Select"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"76d0b2eb-abbf-459f-b559-086de681c12c"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"expression":false,"value":"redshift_teja3"}}}},"settings":{"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"prasanna\".\"redshiftdeletedemo\""},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"advancedSnapProperties":{"value":[]},"schemaName":{"expression":false,"value":"\"prasanna\""},"ignoreEmptyResult":{"value":false}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"rs8"},"5e09d89f-58da-4fe4-bb0a-2176a1f64826":{"class_fqid":"com-snaplogic-snaps-mysql-select_3-002","class_id":"com-snaplogic-snaps-mysql-select","class_version":3,"instance_fqid":"5e09d89f-58da-4fe4-bb0a-2176a1f64826_5","instance_id":"5e09d89f-58da-4fe4-bb0a-2176a1f64826","instance_version":5,"property_map":{"info":{"notes":{"value":null},"label":{"value":"MySQL - Select"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"e9b77e6e-6022-41ce-bb0a-348b7ebaec68"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-mysqldatabaseaccount"},"label":{"expression":false,"value":"Prasanna-diag-mysql"}}}},"settings":{"orderBy":{"value":[]},"limitRows":{"expression":false,"value":"1000"},"passThrough":{"value":true},"tableName":{"expression":false,"value":"`mysqlqa`.`adobedatanew`"},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"`mysqlqa`"},"ignoreEmptyResult":{"value":false}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"label":{"value":"rows"},"view_type":{"value":"document"}}}},"class_build_tag":"002"}},"path_id":"/snaplogic/projects/Patan Manzoor","path_snode":"579ae9e995526e01c128002d"}