Tip of the day: How to export data from SQL
Published Jul 02 2020 02:05 AM 1,744 Views

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.  

 
 

SQLCSV.JPG

 

Export manually, or automate with the following process:  

  1. Define an Azure Data Factory pipeline that exports data from SQL to blob storage using PSV format. 
  1. Define an Event Grid on this storage container that ingests each new blob to Azure Data Explorer. 
Version history
Last update:
‎Jul 02 2020 02:07 AM
Updated by: