Databricks Community

Hi @YS1 ,As a workaround you can rewrite pivot to sql with case statements.Below Pivot:data = [ ("ProductA", "North", 100), ("ProductA", "South", 150), ("ProductA", "East", 200), ("ProductA", "West", 250), ("ProductB", "North", 30...

@szymon_dybczak Thank you for your help. Your solution has worked very well for me.

Hi @RishabhGarg ,You're saying SQL, but which dialect? Because every provider has its own extension to ANSI SQL standard. So for example, if you're using SQL Server for example, there is a TOP keyword to limit the rows.

Expected for Q3 in preview mode

If I'm reading this right you created a materialized view to prep your data in Postgres. You may not need to do that, and it will also limit your integration options. It puts more work on Postgres, usually creates more data to move, and will not as m...

@Gareema, since you're using UC, can you use Volumes instead? It basically replaces the old mount approach.

@Venkat369 What is wrong with the link I provided? It actually shows you how to do it. If not, please be more precise.