PDF Attachment on an Alert

[CoopCoop]

Currently my Alert is an HTML table using data pointing to an SQL query.

I was wondering if it is possible to attach the resulting table from this SQL query as a PDF to the alert email.

If anyone has successfully implemented this, please let me know! Thanks!

[Atanu]

Hello @Cooper Chung​  are you looking for something like this - https://docs.databricks.com/sql/user/dashboards/index.html#dashboard-snapshot-subscriptions ?

[CoopCoop]

Hi @Atanu Sarkar​, I've tried using dashboards before and the export as PDF function, but got some less than desirable results. My SQL query has 11 columns, and may contain information as long as a paragraph (user input).

This works as an HTML table in an Alert since cell sizes are dynamically resized based on its contents (That way all the data is shown and fits on screen).

However, this feature does not apply to the dashboard so a good portion of the table gets cut off in both the email subscription/snapshot, and the resulting exported PDF. Please see attached screenshots - 1 shows the email subscription/snapshot being cut off, and 2 shows the PDF export being cut off.

[CoopCoop]

Attaching 2nd screenshot here because I can't upload more than 1 file per reply

[Atanu]

Ok understood the concern, so basically the issue is with PDF rendering as much I understood. Let me know if I am wrong. Let me see if there is any improvement by our engineering team on this front.

[Atanu]

@Cooper Chung​ 

[CoopCoop · Accepted solution]

@Atanu Sarkar​, yes, you are correct. If the SQL query results are too large, it doesn't fit in the email or PDF export.

Thank you!