topic Re: Alerts and Dashboard in Data Engineering

Alerts and Dashboard

Shas_DataE — Mon, 08 Apr 2024 16:51:04 GMT

Hi Team,

In my Databricks workspace, i have created an alerts using the query in such a way the schedule will run on daily basis and the results will get populated to dashboard.

The results from dashboard will be notified via email, but i am seeing results in PDF format but would rather like to have it in Excel format.

Can you please assist on how it can be achieved.

Thanks in Advance.

Re: Alerts and Dashboard

Ayushi_Suthar — Tue, 09 Apr 2024 05:10:55 GMT

HI @Shas_DataE, Good Day!

Could you please check and confirm if there are any special characters in the table column? At this moment, special characters are compatible with Excel.

If yes then please drop the column that has that special character and then you can export the results to Excel.

Also please note that there is a known issue where exporting SQL query results via the UI has a limit of 100k rows to Excel, and more to CSV/TSV.

Please let me know if this helps and leave a like if this information is useful, followups are appreciated.
Kudos
Ayushi

Re: Alerts and Dashboard

Shas_DataE — Tue, 09 Apr 2024 13:43:10 GMT

Hi @Ayushi_Suthar

Thanks for your response, here the context is different . Pfa the snippet where i am expecting an Excel auto populated whenever the alert triggers on daily basis when query is executed but i am seeing in PDF format.

I am looking into an option for an Excel report rather PDF .

Thanks