I want move || column delimited file from on prem to Synapse using ADF V2 , I am keep getting ADF error that null values are not allowed in my Source data set What's the best way to ingest || column delimited file using ADF
sample:
phone_id||user_id||customer_id||area_code||phone_number||extension||phone_type
100||1||1||512||5551234||23||Home



