{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"6721f273b97222a25eb4bce2","instance_id":"ffeffeba-f809-4aa4-ab78-1966e64ca263","instance_version":6,"link_map":{"link125":{"dst_id":"b19ed82c-d671-4959-8b8c-f28ee15b0980","dst_view_id":"inputRows","src_id":"3bc5716f-2b1e-4910-95d5-c4be01396732","src_view_id":"outputRows","isGoto":false},"link127":{"dst_id":"b19ed82c-d671-4959-8b8c-f28ee15b0980","dst_view_id":"input104","src_id":"3bc5716f-2b1e-4910-95d5-c4be01396732","src_view_id":"output102","isGoto":false},"link131":{"dst_id":"3bc5716f-2b1e-4910-95d5-c4be01396732","dst_view_id":"input103","src_id":"c8f38c94-0ce9-4ba3-bb1d-f2c1b3b9cc6b","src_view_id":"output0","isGoto":false}},"link_serial":132,"property_map":{"info":{"label":{"value":"Snowflake_Snowpipe Streaming - Test Snap to create a table and stream S3"},"author":{"value":"lmanda@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"b19ed82c-d671-4959-8b8c-f28ee15b0980_error0":{"view_type":{"value":"document"},"label":{"value":"Snowflake - Snowpipe Streaming - error0"}},"error_behavior":{"value":"none"}},"settings":{"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]},"cache_pipelines":{"value":[]}},"input":{},"output":{"b19ed82c-d671-4959-8b8c-f28ee15b0980_output0":{"view_type":{"value":"document"},"label":{"value":"Snowflake - Snowpipe Streaming - output0"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"650d2c07bf87226317660e4f","detail_map":{"b19ed82c-d671-4959-8b8c-f28ee15b0980":{"grid_x_int":5,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"error":{"error0":{"rot_int":0,"dx_int":0,"dy_int":-1}},"input":{"input104":{"rot_int":0,"dx_int":0,"dy_int":1}},"output":{}},"3bc5716f-2b1e-4910-95d5-c4be01396732":{"grid_x_int":4,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"output":{"output102":{"rot_int":0,"dx_int":0,"dy_int":1}}},"c8f38c94-0ce9-4ba3-bb1d-f2c1b3b9cc6b":{"grid_x_int":3,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}}}},"snap_map":{"b19ed82c-d671-4959-8b8c-f28ee15b0980":{"class_fqid":"com-snaplogic-snaps-snowflake-snowpipestreaming_1-1725080507","class_id":"com-snaplogic-snaps-snowflake-snowpipestreaming","class_version":1,"instance_fqid":"b19ed82c-d671-4959-8b8c-f28ee15b0980_1","instance_id":"b19ed82c-d671-4959-8b8c-f28ee15b0980","instance_version":1,"property_map":{"info":{"label":{"value":"Snowflake - Snowpipe Streaming"},"notes":{}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}},"input104":{"label":{"value":"input1"},"view_type":{"value":"document"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"settings":{"maxClientLag":{"value":"1000","expression":false},"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Validate & Execute"},"schemaName":{"value":"\"PUBLIC\"","expression":false},"retryIntervalProp":{"value":1,"expression":false},"createTable":{"value":true},"preserveCaseSensistiveness":{"value":false},"tableName":{"value":"\"PUBLIC\".\"STREAMINGINGEST3\"","expression":false},"executable_during_suggest":{"value":false}},"account":{"account_ref":{"value":{"label":{"value":"DG_SNOWFLAKE_S3_KEYPAIR","label":"DG_SNOWFLAKE_S3_KEYPAIR","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"ref_id":{"value":"96a5a47b-f0f5-44ed-b809-e404086146c9","expression":false}}}},"view_serial":104},"class_build_tag":"1725080507"},"3bc5716f-2b1e-4910-95d5-c4be01396732":{"class_fqid":"com-snaplogic-snaps-snowflake-select_1-PR27996","class_id":"com-snaplogic-snaps-snowflake-select","class_version":1,"instance_fqid":"3bc5716f-2b1e-4910-95d5-c4be01396732_5","instance_id":"3bc5716f-2b1e-4910-95d5-c4be01396732","instance_version":5,"property_map":{"info":{"label":{"value":"Snowflake - Select"},"notes":{}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}},"output102":{"label":{"value":"output1"},"view_type":{"value":"document"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"orderBy":{"value":[]},"handleDateTimeValues":{"value":"Default Date Time format in UTC Time Zone","expression":false},"autoCommit":{"value":"False"},"maxRetryProp":{"value":0,"expression":false},"timeTravelProps":{"value":[]},"execution_mode":{"value":"Validate & Execute"},"matchDataTypes":{"value":false},"schemaName":{"value":"\"PUBLIC\"","expression":false},"limitOffset":{"value":null,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"limitRows":{"value":null,"expression":false},"passThrough":{"value":false},"whereClause":{"value":null,"expression":false},"ignoreEmptyResult":{"value":false},"tableName":{"value":"\"PUBLIC\".\"SAMPLE0912\"","expression":false},"fetchOutputFieldsInSchema":{"value":false},"outputFields":{"value":[]},"sqlQueryManagement":{"value":"Continue to execute queued queries when pipeline is stopped or if it fails"},"stagingMode":{"value":"In memory"}},"account":{"account_ref":{"value":{"label":{"value":"DG_SNOWFLAKE_OAUTH_AZURE","label":"../shared/DG_SNOWFLAKE_OAUTH_AZURE","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakeazureoauth2account"},"ref_id":{"value":"2fde0f8a-e420-4d2a-beea-cd59030981fa","expression":false}},"expression":false}},"view_serial":103,"input":{"input103":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"PR27996"},"c8f38c94-0ce9-4ba3-bb1d-f2c1b3b9cc6b":{"class_fqid":"com-snaplogic-snaps-snowflake-execute_1-PR28107","class_id":"com-snaplogic-snaps-snowflake-execute","class_version":1,"instance_fqid":"c8f38c94-0ce9-4ba3-bb1d-f2c1b3b9cc6b_1","instance_id":"c8f38c94-0ce9-4ba3-bb1d-f2c1b3b9cc6b","instance_version":1,"property_map":{"info":{"label":{"value":"Snowflake - Execute"},"notes":{}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"sqlStatement":{"value":"DROP TABLE if exists \"PUBLIC\".\"STREAMINGINGEST3\";","expression":false},"queryType":{"value":"Auto","expression":false},"useResultQuery":{"value":false},"handleDateTimeValues":{"value":"Default Date Time format in UTC Time Zone"},"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Validate & Execute"},"retryIntervalProp":{"value":1,"expression":false},"passThrough":{"value":true},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":false},"sqlQueryManagement":{"value":"Continue to execute queued queries when pipeline is stopped or if it fails"}},"account":{"account_ref":{"value":{"label":{"value":"DG_SNOWFLAKE_S3_KEYPAIR","label":"DG_SNOWFLAKE_S3_KEYPAIR","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"ref_id":{"value":"96a5a47b-f0f5-44ed-b809-e404086146c9","expression":false}}}},"view_serial":100,"input":{}},"class_build_tag":"PR28107"}},"path_id":"/QA/Documentation/shared","path_snode":"5e5ccffa9e044610986b5664","target_runtime":"standard"}