{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"65418571b5631a16be247181","instance_id":"997ca4e4-ecaa-4f5f-b514-f6a740ff51d5","instance_version":4,"link_map":{"link109":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"e85bac8d-d3dc-4706-b6d7-7b6e96a24f5a","dst_id":"805c631f-605f-44a5-9bee-651174870d85","isGoto":false},"link105":{"src_view_id":"output0","dst_view_id":"input101","src_id":"805c631f-605f-44a5-9bee-651174870d85","dst_id":"b9e438b0-3bb5-4bc5-9ae0-60307ac41770","isGoto":false},"link103":{"src_view_id":"outputRows","dst_view_id":"input0","src_id":"f7593557-849e-4601-b72b-73387ad54d66","dst_id":"e85bac8d-d3dc-4706-b6d7-7b6e96a24f5a","isGoto":false},"link100":{"src_view_id":"output0","dst_view_id":"input101","src_id":"2db0524a-c819-4b00-96e9-bda52946d2cf","dst_id":"f7593557-849e-4601-b72b-73387ad54d66","isGoto":false}},"link_serial":115,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SNAP-11445_Postgre_to_Snowflake"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"phegde@snaplogic.com"}},"error":{"error_behavior":{"value":"none"}},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null},"suspendable":{"value":false}},"input":{},"output":{"b9e438b0-3bb5-4bc5-9ae0-60307ac41770_output0":{"view_type":{"value":"document"},"label":{"value":"Snowflake - Execute1 - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"6385afc7c0cb3b06784f697c","scale_ratio":1,"detail_map":{"e85bac8d-d3dc-4706-b6d7-7b6e96a24f5a":{"grid_x_int":4,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0,"input":{},"output":{},"error":{}},"f7593557-849e-4601-b72b-73387ad54d66":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0,"input":{},"output":{},"error":{}},"805c631f-605f-44a5-9bee-651174870d85":{"grid_x_int":5,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0,"input":{},"output":{},"error":{}},"b9e438b0-3bb5-4bc5-9ae0-60307ac41770":{"grid_x_int":6,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0,"input":{},"output":{},"error":{}},"2db0524a-c819-4b00-96e9-bda52946d2cf":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"input":{},"rot_int":0,"output":{},"error":{}}},"pan_y_num":0},"snap_map":{"e85bac8d-d3dc-4706-b6d7-7b6e96a24f5a":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-431patches19385","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"e85bac8d-d3dc-4706-b6d7-7b6e96a24f5a_1","instance_id":"e85bac8d-d3dc-4706-b6d7-7b6e96a24f5a","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$museum_name"},"targetPath":{"value":"$MUSEUM_NAME"}},{"expression":{"expression":true,"value":"$country"},"targetPath":{"value":"$COUNTRY"}},{"expression":{"expression":true,"value":"$perimeter"},"targetPath":{"value":"$PERIMETER"}}]},"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":"431patches19385"},"f7593557-849e-4601-b72b-73387ad54d66":{"class_fqid":"com-snaplogic-snaps-postgres-select_1-431patches19421","class_id":"com-snaplogic-snaps-postgres-select","class_version":1,"instance_fqid":"f7593557-849e-4601-b72b-73387ad54d66_1","instance_id":"f7593557-849e-4601-b72b-73387ad54d66","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"PostgreSQL - Select"}},"view_serial":101,"account":{"account_ref":{"value":{"label":{"value":"PostgreSQL_Geospatial","label":"PostgreSQL_Geospatial","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-postgresdatabaseaccount"},"ref_id":{"value":"001c7d93-3bda-457f-9560-7215e9aaf7ec","expression":false}}}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"orderBy":{"value":[]},"autoCommit":{"value":"False"},"maxRetryProp":{"expression":false,"value":0},"execution_mode":{"value":"Validate & Execute"},"matchDataTypes":{"value":false},"schemaName":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"retryIntervalProp":{"expression":false,"value":1},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"whereClause":{"expression":false,"value":null},"ignoreEmptyResult":{"value":false},"tableName":{"expression":false,"value":"\"public\".\"museum_bulkload\""},"fetchOutputFieldsInSchema":{"value":false},"outputFields":{"value":[]},"stagingMode":{"value":"In memory"}},"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":"431patches19421"},"805c631f-605f-44a5-9bee-651174870d85":{"class_fqid":"com-snaplogic-snaps-snowflake-insert_1-PR19358","class_id":"com-snaplogic-snaps-snowflake-insert","class_version":1,"instance_fqid":"805c631f-605f-44a5-9bee-651174870d85_1","instance_id":"805c631f-605f-44a5-9bee-651174870d85","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"Snowflake - Insert"}},"view_serial":100,"account":{"account_ref":{"value":{"ref_id":{"expression":false,"value":"29a50da1-d771-4a07-8091-02ff5ccd0ac0"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"label":{"expression":false,"value":"Snowflake S3 GeoSpatial","label":"Snowflake S3 GeoSpatial"}}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"maxRetryProp":{"expression":false,"value":0},"tableName":{"expression":false,"value":"\"PUBLIC\".\"C12284263\""},"preserveCaseSensistiveness":{"value":false},"executable_during_suggest":{"value":false},"sqlQueryManagement":{"value":"Continue to execute queued queries when pipeline is stopped or if it fails"},"createTable":{"value":false},"schemaName":{"expression":false,"value":null},"retryIntervalProp":{"expression":false,"value":1}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}}},"class_build_tag":"PR19358"},"b9e438b0-3bb5-4bc5-9ae0-60307ac41770":{"class_fqid":"com-snaplogic-snaps-snowflake-execute_1-PR19358","class_id":"com-snaplogic-snaps-snowflake-execute","class_version":1,"instance_fqid":"b9e438b0-3bb5-4bc5-9ae0-60307ac41770_1","instance_id":"b9e438b0-3bb5-4bc5-9ae0-60307ac41770","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"Snowflake - Execute1"}},"view_serial":101,"account":{"account_ref":{"value":{"label":{"expression":false,"value":"Snowflake S3 GeoSpatial","label":"Snowflake S3 GeoSpatial"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"ref_id":{"expression":false,"value":"29a50da1-d771-4a07-8091-02ff5ccd0ac0"}}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"maxRetryProp":{"expression":false,"value":0},"passThrough":{"value":true},"useResultQuery":{"value":false},"executable_during_suggest":{"value":false},"sqlStatement":{"expression":false,"value":"select museum_name, country, st_ASEWKT(perimeter) as perimeter from \"PUBLIC\".\"C12284263\""},"sqlQueryManagement":{"value":"Continue to execute queued queries when pipeline is stopped or if it fails"},"handleDateTimeValues":{"value":"Default Date Time format in UTC Time Zone"},"ignoreEmptyResult":{"value":false},"retryIntervalProp":{"expression":false,"value":1}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"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":"PR19358"},"2db0524a-c819-4b00-96e9-bda52946d2cf":{"class_fqid":"com-snaplogic-snaps-snowflake-execute_1-PR19358","class_id":"com-snaplogic-snaps-snowflake-execute","class_version":1,"instance_fqid":"2db0524a-c819-4b00-96e9-bda52946d2cf_1","instance_id":"2db0524a-c819-4b00-96e9-bda52946d2cf","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"Snowflake - Execute"}},"view_serial":100,"account":{"account_ref":{"value":{"label":{"expression":false,"value":"Snowflake S3 GeoSpatial","label":"Snowflake S3 GeoSpatial"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"ref_id":{"expression":false,"value":"29a50da1-d771-4a07-8091-02ff5ccd0ac0"}}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"maxRetryProp":{"expression":false,"value":0},"passThrough":{"value":true},"useResultQuery":{"value":false},"executable_during_suggest":{"value":false},"sqlStatement":{"expression":false,"value":"truncate table if exists \"PUBLIC\".\"C12284263\""},"sqlQueryManagement":{"value":"Continue to execute queued queries when pipeline is stopped or if it fails"},"handleDateTimeValues":{"value":"Default Date Time format in UTC Time Zone"},"ignoreEmptyResult":{"value":false},"retryIntervalProp":{"expression":false,"value":1}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{}},"class_build_tag":"PR19358"}},"path_id":"/QA/qa_diagnostic_space/db_diagnostic","path_snode":"5cf3e65f36b98b00174974b0","target_runtime":"standard"}