cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Alerts and Dashboard

Shas_DataE
New Contributor II

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.

2 REPLIES 2

Ayushi_Suthar
Honored Contributor
Honored Contributor

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

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

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!