{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"62aac7a6c1e88cc2e00c0c6b","instance_id":"0db84737-770d-43fe-9d9e-a0fca81dd032","instance_version":317,"link_map":{"link133":{"src_view_id":"outputRows","dst_view_id":"inputRows","src_id":"7c2b062b-9540-4d9b-a101-74cf5aaa9b83","dst_id":"204ead42-e33b-44db-998b-76f072f95cce","isGoto":false},"link100":{"src_view_id":"output0","dst_view_id":"input0","src_id":"171d145f-687f-4be3-985f-3f88eec247c7","dst_id":"68d1ef57-f4ad-4ea9-90b3-c72f9cb04f3a","isGoto":false},"link101":{"src_view_id":"output101","dst_view_id":"input0","src_id":"204ead42-e33b-44db-998b-76f072f95cce","dst_id":"171d145f-687f-4be3-985f-3f88eec247c7","isGoto":false}},"link_serial":134,"property_map":{"info":{"notes":{"value":null},"label":{"value":"AzureSynapseSQL-BulkTest"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"svatada@snaplogic.com"}},"input":{},"settings":{"imports":{"value":[]},"suspendable":{"value":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{}},"render_map":{"pan_x_num":0,"default_snaplex":"62a8347807710cd92eb02caa","scale_ratio":1,"detail_map":{"204ead42-e33b-44db-998b-76f072f95cce":{"grid_x_int":4,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"171d145f-687f-4be3-985f-3f88eec247c7":{"grid_x_int":5,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"7c2b062b-9540-4d9b-a101-74cf5aaa9b83":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"input":{},"rot_int":0},"68d1ef57-f4ad-4ea9-90b3-c72f9cb04f3a":{"grid_x_int":6,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"output":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"204ead42-e33b-44db-998b-76f072f95cce":{"class_fqid":"com-snaplogic-snaps-azuresynapsesql-bulkload_1-102","class_id":"com-snaplogic-snaps-azuresynapsesql-bulkload","class_version":1,"instance_fqid":"204ead42-e33b-44db-998b-76f072f95cce_126","instance_id":"204ead42-e33b-44db-998b-76f072f95cce","instance_version":126,"property_map":{"info":{"notes":{},"label":{"value":"Azure Synapse SQL - Bulk Load"}},"view_serial":101,"account":{"account_ref":{"value":{"label":{"expression":false,"value":"SynapseQA-accessKey","label":"SynapseQA-accessKey"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresynapsesqldatabaseaccount"},"ref_id":{"expression":false,"value":"dc7e967c-5cfb-484a-a94f-5760f07b2c4f"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"settings":{"fileFormatOptionList":{"value":[]},"retryInterval":{"expression":false,"value":1},"execution_mode":{"value":"Validate & Execute"},"tableName":{"expression":false,"value":"\"dbo\".\"PerfHugeDataTest\""},"ConvertInputKeyNamesToUpperCase":{"value":false},"transferOptions":{"value":{"blockSize":{"value":2},"maxConcurrency":{"value":2}}},"loadEmptyStrings":{"value":true},"advancedProperties":{"value":[]},"preventURLEncoding":{"value":false},"validate":{"value":false},"fileAction":{"value":"OVERWRITE"},"flushIntervalKb":{"value":-1},"filename":{"expression":false,"value":null},"writeEmptyFile":{"value":false},"copyOptionList":{"value":[{"copyOption":{"expression":false,"value":"ENCODING = 'UTF8' "}},{"copyOption":{"expression":false,"value":"MAXERRORS = 1000"}}]},"columnList":{"value":[]},"schemaName":{"expression":false,"value":"\"dbo\""},"createDir":{"value":false},"truncate":{"value":false},"retries":{"expression":false,"value":0},"writeHeader":{"value":false},"cannedAcls":{"value":"None"},"additionalOptions":{"value":[{"copyOption":{"expression":false,"value":"ERRORFILE='https://snapdev.blob.core.windows.net/snapdev/'"}},{"copyOption":{"expression":false,"value":"ERRORFILE_CREDENTIAL=(IDENTITY = 'Storage Account Key', SECRET = '6eG2tpdIXv45X5jgODoslqhczrliBhe+jl1U9H9acl8v9MCeJGt/A/zuWIOU/kQMuaI8ciS4ts8N+ASt3icJxQ==')"}}]},"executable_during_suggest":{"value":false},"fileList":{"value":[{"file":{"expression":false,"value":"file1.csv"}},{"file":{"expression":false,"value":"file3.csv"}}]},"filePattern":{"expression":false,"value":null},"validationMode":{"value":"NONE"},"fileFormatType":{"expression":false,"value":"CSV"},"purge":{"value":false},"createTable":{"value":true},"UserPermissionsKey":{"value":[]},"dataSource":{"value":"Input view"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"102"},"171d145f-687f-4be3-985f-3f88eec247c7":{"class_fqid":"com-snaplogic-snaps-transform-jsonformatter_2-develop16570","class_id":"com-snaplogic-snaps-transform-jsonformatter","class_version":2,"instance_fqid":"171d145f-687f-4be3-985f-3f88eec247c7_1","instance_id":"171d145f-687f-4be3-985f-3f88eec247c7","instance_version":1,"property_map":{"info":{"label":{"value":"JSON Formatter"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"deriveSchemaLimit":{"value":"None"},"execution_mode":{"value":"Validate & Execute"},"prettyPrint":{"value":false},"contentPath":{"value":"$"},"jsonLines":{"value":false},"ignoreEmptyStream":{"value":false},"header":{"value":[{"expression":{"expression":true,"value":""}}]},"formatSingleDocument":{"value":false},"supportTypeExts":{"value":false}},"error":{"error0":{"view_type":{"value":"binary"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"binary"},"label":{"value":"output0"}}}},"class_build_tag":"develop16570"},"7c2b062b-9540-4d9b-a101-74cf5aaa9b83":{"class_fqid":"com-snaplogic-snaps-snowflake-select_1-develop16653","class_id":"com-snaplogic-snaps-snowflake-select","class_version":1,"instance_fqid":"7c2b062b-9540-4d9b-a101-74cf5aaa9b83_54","instance_id":"7c2b062b-9540-4d9b-a101-74cf5aaa9b83","instance_version":54,"property_map":{"info":{"notes":{},"label":{"value":"Snowflake - Select"}},"view_serial":100,"account":{"account_ref":{"value":{"ref_id":{"expression":false,"value":"28e7af18-06f9-4377-a04b-a89dfa6add69"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"label":{"expression":false,"value":"Snowflake-engdev","label":"../../shared/Snowflake-engdev"}}}},"settings":{"orderBy":{"value":[]},"autoCommit":{"value":"False"},"execution_mode":{"value":"Validate & Execute"},"maxRetryProp":{"expression":false,"value":0},"stagingMode":{"value":"On disk"},"tableName":{"expression":false,"value":"\"PRASANNA\".\"INVOICEDATA\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"sqlQueryManagement":{"value":"Continue to execute queued queries when pipeline is stopped or if it fails"},"matchDataTypes":{"value":false},"fetchOutputFieldsInSchema":{"value":false},"handleDateTimeValues":{"expression":false,"value":"Default Date Time format in UTC Time Zone"},"schemaName":{"expression":false,"value":"\"PRASANNA\""},"limitOffset":{"expression":false,"value":"1000"},"retryIntervalProp":{"expression":false,"value":1},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{}},"class_build_tag":"develop16653"},"68d1ef57-f4ad-4ea9-90b3-c72f9cb04f3a":{"class_fqid":"com-snaplogic-snaps-binary-write_3-develop16570","class_id":"com-snaplogic-snaps-binary-write","class_version":3,"instance_fqid":"68d1ef57-f4ad-4ea9-90b3-c72f9cb04f3a_2","instance_id":"68d1ef57-f4ad-4ea9-90b3-c72f9cb04f3a","instance_version":2,"property_map":{"info":{"notes":{},"label":{"value":"File Writer"}},"view_serial":100,"account":{"account_ref":{"value":{}}},"settings":{"retryInterval":{"expression":false,"value":1},"retries":{"expression":false,"value":0},"execution_mode":{"value":"Validate & Execute"},"flushIntervalKb":{"value":-1},"writeHeader":{"value":false},"cannedAcls":{"value":"None"},"createDir":{"value":false},"executable_during_suggest":{"value":false},"filename":{"expression":false,"value":"synapsebulkout.json"},"writeEmptyFile":{"value":false},"UserPermissionsKey":{"value":[]},"advancedProperties":{"value":[]},"validate":{"value":false},"preventURLEncoding":{"value":false},"fileAction":{"value":"OVERWRITE"}},"output":{},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"binary"}}}},"class_build_tag":"develop16570"}},"path_id":"/QA/projects/Satish Vatada","path_snode":"5b06a12436b98b03f55cc5f8","target_runtime":"standard"}