When ingesting data from SQL to Azure Data Explorer in CSV format, you may have experienced ingestion failure due to formatting problems.
This happens when the SQL exports to CSV in an ADX-incompatible format.
But don’t panic, there’s a very simple solution: export from SQL in PSV format for ingestion.
Export manually, or automate with the following process:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.