Azure Databricks to load data from App1 to an Azure SQL Data Warehouse

 App1 data is available to Databricks

Azure Data Lake Storage

Azure Data Factory 

Automate data movement using Azure Data Factory, then load data into Azure Data Lake Storage, transform and clean it using Azure Databricks, and make it available for analytics using Azure Synapse Analytics. Modernize your data warehouse in the cloud for unmatched levels of.

Note: 

Integrate data silos with Azure Data Factory, a service built for all data integrations needs and skills level.

Easily Construct ETL and ELT processes code-free within the intuitive visual environment, or write your own code. Visually integrate data sources using more than 90+ natively built and maintainence-free connectors at no added cost.

Focus on your data-- the serverless integration service does the rest.

Reference:

https://azure.microsoft.com/en-us/services/databricks/#capabilities

https://azure.microsoft.com/en-us/services/data-factory/