Tip of the day: How to export data from SQL

This post has been republished via RSS; it originally appeared at: Azure Data Explorer Blog articles.

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. 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.