{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"62d70279a8ad45d6d52922a0","instance_id":"a1a4c51c-22d9-4e74-bceb-fbf8db3eecd8","instance_version":3,"link_map":{},"link_serial":105,"property_map":{"info":{"notes":{"value":null},"author":{"value":"avedam@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Databricks_FEP1_MergeInto"}},"input":{},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null},"param_table":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"d394713c-6001-4f32-8657-953dfd151ccb_output0":{"label":{"value":"Databricks - Merge into - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"62a79c1ad5446c1b71957919","scale_ratio":1,"detail_map":{"d394713c-6001-4f32-8657-953dfd151ccb":{"grid_x_int":1,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"output":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"d394713c-6001-4f32-8657-953dfd151ccb":{"class_fqid":"com-snaplogic-snaps-databricks-mergeinto_1-429patches16955","class_id":"com-snaplogic-snaps-databricks-mergeinto","class_version":1,"instance_fqid":"d394713c-6001-4f32-8657-953dfd151ccb_1","instance_id":"d394713c-6001-4f32-8657-953dfd151ccb","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"Databricks - Merge into"}},"view_serial":101,"account":{"account_ref":{"value":{"ref_id":{"expression":false,"value":"735b214e-517e-42c7-aace-0114ef089134"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-databricks-databricksdatabaseaccount"},"label":{"expression":false,"value":"STD DB Acc DeltaLake AWS ALD off src S3(SLC)","label":"STD DB Acc DeltaLake AWS ALD off src S3(SLC)"}}}},"settings":{"encryptType":{"value":null},"fileFormatType":{"value":"CSV"},"execution_mode":{"value":"Execute only"},"sourceTableAlias":{"value":"src"},"sourceType":{"value":"Cloud Storage File"},"fileFormatOptions":{"value":[{"fileFormatOption":{"expression":false,"value":"'header' = 'false'"}}]},"filesProvider":{"value":"Pattern"},"externalTableName":{"value":null},"tableName":{"expression":false,"value":"update_company_employees"},"fileList":{"value":[]},"targetTableAlias":{"value":"trg"},"kmsKey":{"expression":false},"executable_during_suggest":{"value":false},"databaseName":{"expression":false,"value":"default"},"filePattern":{"expression":false,"value":"databricks/csv_company_employees/*.csv"},"onConditionProp":{"expression":false,"value":"src.id=trg.id"},"mergeClauseProp":{"value":[{"actionProp":{"value":"INSERT"},"conditionProp":{"expression":false,"value":null},"whenClauseProp":{"expression":false,"value":"WHEN NOT MATCHED"}}]}},"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":"429patches16955"}},"path_id":"/bigdata/ExtremeElt/std_databricks","path_snode":"62cd494c57a250c3e3246082","target_runtime":"standard"}