SQL script refactoring of OUTER APPLY
Budget: $30 – $250 USD
Currently we're using Azure SQL database + Azure Data Factory, where we have a complex script for selecting data into a table. The script is around 350 rows, and it is using OUTER APPLY. Now we are migrating to Databricks, which doesn't support OUTER APPLY function.
Thus we need to refactor SQL script from the use of OUTER APPLY to LEFT JOIN.
Thus we need to refactor SQL script from the use of OUTER APPLY to LEFT JOIN.