You can try using Azure databricks service. Access the data from DB or any other sources directly or first ingest the data to Data lake gen2 then use it further for transformation in Azure databricks. This involves coding in Scala, Python or Spark SQL.
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav