Hi @Raj Sethi​ , If you are expecting something like below

%sql

select * from tbl -> This internally uses .display API to display your results. So you can't really control truncation there.

But if you can try the same above command like below, it could help to solve your issue.

spark.sql("select * from tbl").show(truncate = False)

Please let me know if this helps.