Enhancement ideas: Execute SQL statement & enable Visualization plots

[ThiamHuat_Tan]

(a) In a Notebook, how can we execute a SQL statement? In Databricks notebook, we can change it to be able to execute SQL statement with %sql, but it is not possible in Fabric.

spark.sql("SELECT month, round(SUM (rainfall),2) as MonthlyRainfall FROM ParquetRainfallTable WHERE location == 'Clementi Road' AND year == 2023 GROUP BY month, month_numeric ORDER BY month_numeric").show()

(b) In the above SQL statement, it displays a table of values for month and MonthlyRainfall. However in Databricks, it can display a barplot easily in a Notebook. Can Microsoft consider this as an enhancement? it would be very useful, not only for barplots, but for other visualization like map too. Thanks.