{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"593b2b83f7c359638bcf6d48","instance_id":"b4fb9c1c-6e2e-4e2b-ba7c-3ba738766e77","instance_version":31,"link_map":{"link100":{"src_view_id":"output0","dst_view_id":"input101","src_id":"7b025290-91b9-4814-91aa-5f53a3c10f1a","dst_id":"a7f39fbb-29f5-4dc5-9fc9-8c7f85faea0b","isGoto":false}},"link_serial":101,"property_map":{"info":{"notes":{"value":null},"label":{"value":"redshift-select"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"admin@snaplogic.com"}},"input":{"7b025290-91b9-4814-91aa-5f53a3c10f1a_input0":{"label":{"value":"Mapper - input0"},"view_type":{"value":"document"}}},"settings":{"param_table":{"value":[{"capture":{"value":false},"value":{"value":"0001"},"key":{"value":"id"}}]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"a5bd659d-5b01-41c6-b3dd-51610b8c574a_outputRows":{"view_type":{"value":"document"},"label":{"value":"Redshift - Select Pipeline Param - rows"}},"a7f39fbb-29f5-4dc5-9fc9-8c7f85faea0b_outputRows":{"label":{"value":"Redshift - Select With Expr - rows"},"view_type":{"value":"document"}},"c86e216f-50f0-487d-8d6d-a53ba032d4ff_outputRows":{"view_type":{"value":"document"},"label":{"value":"Redshift - Select w/o Expr - rows"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"578e57a81d05e557f2dce3eb","scale_ratio":1,"detail_map":{"a5bd659d-5b01-41c6-b3dd-51610b8c574a":{"grid_x_int":6,"rot_int":0,"grid_y_int":4,"rot_tail_int":0},"c86e216f-50f0-487d-8d6d-a53ba032d4ff":{"grid_x_int":7,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"a7f39fbb-29f5-4dc5-9fc9-8c7f85faea0b":{"grid_x_int":7,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"7b025290-91b9-4814-91aa-5f53a3c10f1a":{"grid_x_int":6,"rot_int":0,"grid_y_int":3,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"a5bd659d-5b01-41c6-b3dd-51610b8c574a":{"class_fqid":"com-snaplogic-snaps-redshift-select_3-SNAPSHOT","class_id":"com-snaplogic-snaps-redshift-select","class_version":3,"instance_fqid":"a5bd659d-5b01-41c6-b3dd-51610b8c574a_3","instance_id":"a5bd659d-5b01-41c6-b3dd-51610b8c574a","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Select Pipeline Param"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"redshift-diagnostic"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"ref_id":{"expression":false,"value":"456d4833-7bf4-481c-b88e-6b1645573001"}}}},"settings":{"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"public\".\"demo_guest\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":true,"value":"\"id = '\"+ _id + \"'\""},"schemaName":{"expression":false,"value":"\"public\""},"limitOffset":{"expression":false,"value":null}},"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":"SNAPSHOT"},"c86e216f-50f0-487d-8d6d-a53ba032d4ff":{"class_fqid":"com-snaplogic-snaps-redshift-select_3-SNAPSHOT","class_id":"com-snaplogic-snaps-redshift-select","class_version":3,"instance_fqid":"c86e216f-50f0-487d-8d6d-a53ba032d4ff_2","instance_id":"c86e216f-50f0-487d-8d6d-a53ba032d4ff","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Select w/o Expr"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"456d4833-7bf4-481c-b88e-6b1645573001"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"expression":false,"value":"redshift-diagnostic"}}}},"settings":{"orderBy":{"value":[{"columns":{"expression":false,"value":"inst_dt"}}]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"public\".\"demo_guest\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":"name='Tom'"},"schemaName":{"expression":false,"value":"\"public\""},"limitOffset":{"expression":false,"value":null}},"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":"SNAPSHOT"},"a7f39fbb-29f5-4dc5-9fc9-8c7f85faea0b":{"class_fqid":"com-snaplogic-snaps-redshift-select_3-SNAPSHOT","class_id":"com-snaplogic-snaps-redshift-select","class_version":3,"instance_fqid":"a7f39fbb-29f5-4dc5-9fc9-8c7f85faea0b_20","instance_id":"a7f39fbb-29f5-4dc5-9fc9-8c7f85faea0b","instance_version":20,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Redshift - Select With Expr"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"456d4833-7bf4-481c-b88e-6b1645573001"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-redshiftdatabaseaccount"},"label":{"expression":false,"value":"redshift-diagnostic"}}}},"settings":{"orderBy":{"value":[{"columns":{"expression":false,"value":"inst_dt"}}]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"public\".\"demo_guest\""},"outputFields":{"value":[]},"whereClause":{"expression":true,"value":"\"inst_dt < '\" + $current_date + \"'\""},"limitOffset":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"\"public\""},"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":"SNAPSHOT"},"7b025290-91b9-4814-91aa-5f53a3c10f1a":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"7b025290-91b9-4814-91aa-5f53a3c10f1a_2","instance_id":"7b025290-91b9-4814-91aa-5f53a3c10f1a","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"Date.now()"},"targetPath":{"value":"$current_date"}}]},"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":"SNAPSHOT"}},"path_id":"/snaplogic/projects/shared","path_snode":"578e579f1d05e55764b12f36"}