Databricks Community

SaugatMukherjee · 12-18-2023

Hi,I am sending databricks sql alerts to an email. I am trying to get the query results table in the body of the email.I have used a custom template with {{QUERY_RESULT_TABLE}}and this works fine for a teams alert. In Teams, I can see the table prope...

SaugatMukherjee · 01-02-2024

Hi Subbaram,You should post a new question for this. I will then try to answer.

SaugatMukherjee · 12-20-2023

Ok, so I have been able to test this.Basically to remove permissions, you will have to use the "Set SQL Warehouse permissions" using "PUT" and provide it the full list of people, who should have access, leaving out those, who shouldn't, like I mentio...

SaugatMukherjee · 12-19-2023

I use Terraform to set sql warehouse permissions, but it should be the same. I use the rest api for other things.So, basically for a warehouse id, you need to pass on the entire array of users who would have access.So, if there were 3 users with perm...

SaugatMukherjee · 12-15-2023

I can now confirm that this works.1. I created a saved query using databricks rest api.2. Created an alert using databricks rest api. This does not include the schedule.3. Created a job with a task of sql_task type with the alert id assigned to the a...

SaugatMukherjee · 12-12-2023

The way I hopefully figured this out (am going to try it out in a couple of days), was first doing it manually, getting an alert out to a teams channel (configured as a destination) , using the default template. When it actually wrote on teams, I got...

Databricks Community

User Stats

User Activity

SQL Alert Email with QUERY_RESULTS_TABLE results in table with no border

Re: Creating Databricks Alerts/Notifications without using the UI

Re: "Revoke" permissions for SQL-Warehouse with API

Re: "Revoke" permissions for SQL-Warehouse with API

Re: Creating Databricks Alerts/Notifications without using the UI

Re: Creating Databricks Alerts/Notifications without using the UI