There are few options you can try. Based of the information shared, I am assuming a skeleton for you complicated query as follows:
WITH cte_one AS (SELECT *FROM view_one),-- Other CTEs...-- Your main query logicSELECTFROM cte_one-- Joins and other cl...
I have been using Azure for the past 4 years, it goes hand-in-hand with Databricks and has lot of great features around Azure purview integration as well. Keep following the official page for the latest on Azure DB updates. Recently, I have started ...
