Ingesting data using Delta Lake
Data can be ingested into Delta Lake in several ways. Azure Databricks offers several integrations with Partners, which provide data sources that are loaded as Delta tables. We can copy a file directly into a table, use AutoLoader, or create a new streaming table. Let's take a deeper look at this.
Partner integrations
Azure Databricks allows us to connect to different partners that provide data sources. These are easy to implement and provide scalable ingestion.
We can view the options that we have for ingesting data from Partner Integrations when creating a new table in the UI, as shown in the following screenshot:
Some of these integrations, such as Qlink, allow you to get data from multiple data sources such as Oracle, Microsoft SQL Server, and SAP and load them into Delta Lake. Of course, these integrations require you to have a subscription to...