{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"67bc3a2d0596373ebcc130b6","instance_id":"6bcde896-daea-4b7f-8f6a-9ddf5cac67c9","instance_version":11,"link_map":{"link102":{"dst_id":"fe378ad8-4f21-4d0c-8a9a-05f459d9fe82","dst_view_id":"in","src_id":"2955951e-d1c0-4a33-bbe9-fcb655006b62","src_view_id":"out","isGoto":false},"link105":{"dst_id":"d5426515-3440-44c4-8eef-f6956ddaff32","dst_view_id":"input0","src_id":"fe378ad8-4f21-4d0c-8a9a-05f459d9fe82","src_view_id":"out","isGoto":false}},"link_serial":114,"property_map":{"info":{"label":{"value":"ex-athena-query"},"author":{"value":"amsingh@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":{"2955951e-d1c0-4a33-bbe9-fcb655006b62_in":{"view_type":{"value":"document"},"label":{"value":"Athena Query - Input view"}}},"output":{"d5426515-3440-44c4-8eef-f6956ddaff32_output0":{"view_type":{"value":"document"},"label":{"value":"Mapper - output0"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"5d9e1e9d48bd893bfeea4095","detail_map":{"2955951e-d1c0-4a33-bbe9-fcb655006b62":{"grid_x_int":3,"grid_y_int":3,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"fe378ad8-4f21-4d0c-8a9a-05f459d9fe82":{"grid_x_int":4,"grid_y_int":3,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"d5426515-3440-44c4-8eef-f6956ddaff32":{"grid_x_int":5,"grid_y_int":3,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0}}},"snap_map":{"2955951e-d1c0-4a33-bbe9-fcb655006b62":{"class_fqid":"com-snaplogic-snaps-amazonathena-query_1-PR29167","class_id":"com-snaplogic-snaps-amazonathena-query","class_version":1,"instance_fqid":"2955951e-d1c0-4a33-bbe9-fcb655006b62_3","instance_id":"2955951e-d1c0-4a33-bbe9-fcb655006b62","instance_version":3,"property_map":{"info":{"label":{"value":"Athena Query"},"notes":{}},"input":{"in":{"view_type":{"value":"document"},"label":{"value":"Input view"}}},"output":{"out":{"view_type":{"value":"document"},"label":{"value":"Output view"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"maxRetries":{"value":3,"expression":false},"database":{"value":"snapqateam","expression":false},"query":{"value":"CREATE EXTERNAL TABLE IF NOT EXISTS employees_info (\n  EmployeeID INT,\n  Name STRING,\n  Age INT,\n  Salary DOUBLE,\n  IsManager BOOLEAN,\n  JoinDate DATE,\n  LastLogin TIMESTAMP,\n  Skills ARRAY<STRING>,\n  Address STRUCT<\n    Street: STRING,\n    City: STRING,\n    ZipCode: INT\n  >,\n  PerformanceRatings ARRAY<INT>\n)\nROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'\nLOCATION 's3://qa-athena-bucket/yugandhar/JSON/'\nTBLPROPERTIES ('has_encrypted_data'='false');","expression":false}},"account":{"account_ref":{"value":{"label":{"value":"Dg_Athena_snapqa","label":"Dg_Athena_snapqa","expression":false},"ref_class_id":{"value":"com-snaplogic-snaps-amazonathena-auth-amazonathenaaccount"},"ref_id":{"value":"5ae30428-1453-4d34-8405-3de74ab99e51","expression":false}}}},"view_serial":100},"class_build_tag":"PR29167"},"fe378ad8-4f21-4d0c-8a9a-05f459d9fe82":{"class_fqid":"com-snaplogic-snaps-amazonathena-select_1-PR29167","class_id":"com-snaplogic-snaps-amazonathena-select","class_version":1,"instance_fqid":"fe378ad8-4f21-4d0c-8a9a-05f459d9fe82_2","instance_id":"fe378ad8-4f21-4d0c-8a9a-05f459d9fe82","instance_version":2,"property_map":{"info":{"label":{"value":"Athena Select"},"notes":{}},"input":{"in":{"view_type":{"value":"document"},"label":{"value":"Input view"}}},"output":{"out":{"view_type":{"value":"document"},"label":{"value":"Output view"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"orderBy":{"value":[]},"where":{"value":"ismanager = true","expression":false},"execution_mode":{"value":"Validate & Execute"},"clientSettings":{"value":{"maxRetries":{"value":3,"expression":false},"fetchSize":{"value":10000,"expression":false}}},"connParams":{"value":[]},"offset":{"value":null,"expression":false},"limitRows":{"value":1,"expression":false},"groupBy":{"value":[]},"tableName":{"value":"employees_info","expression":false},"outputFields":{"value":[]},"database":{"value":"snapqateam","expression":false}},"account":{"account_ref":{"value":{"label":{"value":"Dg_Athena_snapqa","label":"amritesh singh/Dg_Athena_snapqa","expression":false},"ref_class_id":{"value":"com-snaplogic-snaps-amazonathena-auth-amazonathenaaccount"},"ref_id":{"value":"5ae30428-1453-4d34-8405-3de74ab99e51","expression":false}}}},"view_serial":100},"class_build_tag":"PR29167"},"d5426515-3440-44c4-8eef-f6956ddaff32":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-439patches29237","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"d5426515-3440-44c4-8eef-f6956ddaff32_2","instance_id":"d5426515-3440-44c4-8eef-f6956ddaff32","instance_version":2,"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":{"orderBy":{"value":[]},"where":{"value":null,"expression":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"value":"$employeeid","expression":true},"targetPath":{"value":"$employeeid","expression":true}},{"expression":{"value":"$name","expression":true},"targetPath":{"value":"$name","expression":true}},{"expression":{"value":"$performanceratings","expression":true},"targetPath":{"value":"$performanceratings","expression":true}},{"expression":{"value":"$salary","expression":true},"targetPath":{"value":"$salary","expression":true}}]}}},"clientSettings":{"value":{"maxRetries":{"value":null,"expression":false},"fetchSize":{"value":null,"expression":false}}},"connParams":{"value":[]},"offset":{"value":null,"expression":false},"limitRows":{"value":null,"expression":false},"passThrough":{"value":false},"groupBy":{"value":[]},"nullSafeAccess":{"value":false},"tableName":{"value":null,"expression":false},"outputFields":{"value":[]},"database":{"value":null,"expression":false}},"view_serial":100},"class_build_tag":"439patches29237"}},"path_id":"/QA/projects/amritesh singh","path_snode":"63dcb778cea4391d895d637b","target_runtime":"standard"}