Hello @filipniziol , I went with your second suggestion as i preferred to use views in this case. It works very well as there is a limited depth and i could just write that many unions.Thanks for your response!
Hi @filipniziol , yes i know that is an option, but that would mean i have to do this every time the source table updates, even if the data could possibly not be used before the next update, which is why i wanted to create a view on the data, because...
I want to create a persistent view on a recursive cte. Is something like that just not possible?As far as i understand:You need to use pyspark to be able to do a recursive cte.BUTYou need to use Spark SQL to create a persistent view. Is there any wo...
