- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-15-2023 09:15 AM
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-08-2023 07:07 AM
@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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-07-2023 03:47 PM
Hello @Cooper Chungโ are you looking for something like this - https://docs.databricks.com/sql/user/dashboards/index.html#dashboard-snapshot-subscriptions ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-08-2023 06:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-08-2023 06:58 AM
Attaching 2nd screenshot here because I can't upload more than 1 file per reply
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-08-2023 07:03 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-08-2023 07:04 AM
@Cooper Chungโ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-08-2023 07:07 AM
@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!
![](/skins/images/582998B45490C7019731A5B3A872C751/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/582998B45490C7019731A5B3A872C751/responsive_peak/images/icon_anonymous_message.png)