Hi @KalingaSena ,

I created a dummy dataset on delta lake and ran a similar query like yours (almost with the same structure). And I am getting the output as expected without any failure. Please see below attached cell.

Although the 'in' keyword can or cannot have space , the error you are getting suggests its mostly syntax related. The only difference in our code is , you are probably reading an externa table from ADLS whereas I am not. If you happen to resolve your issue then pls share here.