topic PDF Attachment on an Alert in Data Engineering

PDF Attachment on an Alert

CoopCoop — Mon, 15 May 2023 16:15:58 GMT

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!

Re: PDF Attachment on an Alert

Atanu — Wed, 07 Jun 2023 22:47:13 GMT

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

Re: PDF Attachment on an Alert

CoopCoop — Thu, 08 Jun 2023 13:57:39 GMT

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.

Re: PDF Attachment on an Alert

CoopCoop — Thu, 08 Jun 2023 13:58:16 GMT

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

Re: PDF Attachment on an Alert

Atanu — Thu, 08 Jun 2023 14:03:57 GMT

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.

Re: PDF Attachment on an Alert

Atanu — Thu, 08 Jun 2023 14:04:08 GMT

@Cooper Chung

Re: PDF Attachment on an Alert

CoopCoop — Thu, 08 Jun 2023 14:07:38 GMT

@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!

Re: PDF Attachment on an Alert

ffdfdff233 — Tue, 06 Oct 2026 17:46:05 GMT

Re: PDF Attachment on an Alert

qydub — Tue, 06 Oct 2026 17:54:20 GMT

Re: PDF Attachment on an Alert

qydub — Tue, 06 Oct 2026 17:55:42 GMT

Re: PDF Attachment on an Alert

qydub — Tue, 06 Oct 2026 17:58:30 GMT

dsd

Re: PDF Attachment on an Alert

qydub — Tue, 06 Oct 2026 17:59:17 GMT

sdd

Re: PDF Attachment on an Alert

qydub — Tue, 06 Oct 2026 18:00:45 GMT

sdds

Re: PDF Attachment on an Alert

qydub — Tue, 06 Oct 2026 18:07:55 GMT

dds

Re: PDF Attachment on an Alert

qydub — Tue, 06 Oct 2026 18:09:05 GMT

Re: PDF Attachment on an Alert

charleedfgrd34 — Tue, 06 Oct 2026 20:14:55 GMT

insndfjojowejoieowe oweowe

Re: PDF Attachment on an Alert

charleedfgrd34 — Tue, 06 Oct 2026 20:28:55 GMT

cunskdjf sjdfljweoi

Re: PDF Attachment on an Alert

charleedfgrd34 — Tue, 06 Oct 2026 20:31:01 GMT

nskdfjoweo osdjfoeo