{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5a01446095526e7752683b8b","instance_id":"226470e3-52fd-49b6-87ae-efc38e4158bc","instance_version":8,"link_map":{"link100":{"src_view_id":"outputRows","dst_view_id":"input0","src_id":"826f023e-b885-415d-8d2e-56a011495a7c","dst_id":"93014d98-e954-4b24-9a56-6019e4e5e774","isGoto":false},"link101":{"src_view_id":"output0","dst_view_id":"input101","src_id":"93014d98-e954-4b24-9a56-6019e4e5e774","dst_id":"cb945905-dc27-4045-96ae-7882d77e43e9","isGoto":false}},"link_serial":102,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Google bulk load streaming-> SQL server to google bulk load (on-Prem to cloud migration)"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"pkoppishetty@snaplogic.com"}},"input":{},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{"cb945905-dc27-4045-96ae-7882d77e43e9_output0":{"label":{"value":"Google BigQuery Execute - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"cb945905-dc27-4045-96ae-7882d77e43e9":{"grid_x_int":4,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"826f023e-b885-415d-8d2e-56a011495a7c":{"grid_x_int":2,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"93014d98-e954-4b24-9a56-6019e4e5e774":{"grid_x_int":3,"rot_int":0,"grid_y_int":1,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"cb945905-dc27-4045-96ae-7882d77e43e9":{"class_fqid":"com-snaplogic-snaps-google-bigquery-execute_1-snapsrc900","class_id":"com-snaplogic-snaps-google-bigquery-execute","class_version":1,"instance_fqid":"cb945905-dc27-4045-96ae-7882d77e43e9_4","instance_id":"cb945905-dc27-4045-96ae-7882d77e43e9","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Google BigQuery Execute"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Syed's Service Account"},"ref_class_id":{"value":"com-snaplogic-snaps-google-bigquery-googleserviceaccount"},"ref_id":{"expression":false,"value":"7a13ce49-f65f-4006-977f-0a928295bf67"}}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"DestTableAction":{"value":"OVERWRITE"},"DestTableID":{"expression":false,"value":null},"executable_during_suggest":{"value":true},"ProjectID":{"expression":false,"value":"case16370"},"Query":{"expression":false,"value":"SELECT * FROM babynames.Salesforcedata LIMIT 1000"},"DestDatasetID":{"expression":false,"value":null}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsrc900"},"826f023e-b885-415d-8d2e-56a011495a7c":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-snapsrc900","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"826f023e-b885-415d-8d2e-56a011495a7c_1","instance_id":"826f023e-b885-415d-8d2e-56a011495a7c","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server - Select"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"SQL Server Diagnostic Account XL"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"expression":false,"value":"6d621fcb-f8c0-4d0d-9d26-bcd9fea1b666"}}}},"settings":{"autoCommit":{"value":"False"},"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"dbo\".\"salesforce_leads_random\""},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null},"schemaName":{"expression":false,"value":null},"ignoreEmptyResult":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}}},"class_build_tag":"snapsrc900"},"93014d98-e954-4b24-9a56-6019e4e5e774":{"class_fqid":"com-snaplogic-snaps-google-bigquery-bulkloadwithstreaming_1-snapsrc900","class_id":"com-snaplogic-snaps-google-bigquery-bulkloadwithstreaming","class_version":1,"instance_fqid":"93014d98-e954-4b24-9a56-6019e4e5e774_2","instance_id":"93014d98-e954-4b24-9a56-6019e4e5e774","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Google BigQuery Bulk Load (Streaming)"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Syed's Service Account"},"ref_class_id":{"value":"com-snaplogic-snaps-google-bigquery-googleserviceaccount"},"ref_id":{"expression":false,"value":"7a13ce49-f65f-4006-977f-0a928295bf67"}}}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"ProjectID":{"expression":false,"value":"case16370"},"batchSize":{"value":1000},"retryDelay":{"value":500},"executable_during_suggest":{"value":true},"createTable":{"value":true},"TableID":{"expression":false,"value":"Salesforcedata"},"batchTimeout":{"value":2000},"retryCount":{"value":0},"DatasetID":{"expression":false,"value":"babynames"}},"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":"snapsrc900"}},"path_id":"/QA/projects/diagnostic","path_snode":"540e8026ec77034feacff4eb"}