Mo
Databricks Employee
Databricks Employee

hello @Akshay_Petkar,

in your data tab, can't you create a dataset using "Create From SQL" and write a query like the following and use this dataset in your canvas?

SELECT COUNT(sales_key) total_sales, distirict FROM my_table
GROUP BY distirict
ORDER BY total_sales DESC
LIMIT 10
 
let me know if I get your question wrong 😉