Performing data ingestion
You have several options to load data into Azure Synapse Data Explorer. You can use one-click ingestion to quickly load some data and automatically create tables and data mappings as needed, with a few clicks of a mouse. For quick data exploration, you can use Kusto Query Language (KQL) commands to ingest data. If you have complex Azure Synapse pipelines or Azure Data Factory pipelines, you can use them for anything from robust data integration jobs to simple data movement tasks, leveraging rich logging, error handling, and more. Finally, if you need to build a custom application that connects to your Data Explorer pool using Data Explorer’s REST API for data ingestion, you can do that too.
The tool that you will use for data ingestion depends on your business needs and scenario. You can refer to the Running your first query section of Chapter 3, Exploring Azure Synapse Studio, where we already walked through the process to load data using the one...